Results 1 to 2 of 2

Thread: What is trigger?

  1. #1
    Senior Member Padsall's Avatar
    Join Date
    May 2011
    Location
    uk
    Posts
    100

    What is trigger?

    I know that A trigger is a special kind of stored procedure that is invoked whenever an attempt is made to modify the data in the table it protects. Modifications to the table are made ussing INSERT,UPDATE,OR DELETE statements.

    For example, if you have a table with a field that contains the date this record has been modified, you could set a trigger on updates and inserts that will set this field to the current date so you wont have to handle this field in your application code.

    Triggers are used to enforce data integrity and business rules such as automatically updating summary data. It allows to perform cascading delete or update operations. If constraints exist on the trigger table,they are checked prior to the trigger execution. If constraints are violated statement will not be executed and trigger will not run.Triggers are associated with tables and they are automatic . Triggers are automatically invoked by SQL SERVER. Triggers prevent incorrect , unauthorized,or inconsistent changes to data.

  2. #2
    Junior Member
    Join Date
    Mar 2013
    Posts
    1
    A database trigger is procedural code that is routinely execute in answer to assured events on a exacting table or view in a database. The trigger is mostly used for maintaining the honor of the in sequence on the database.but my expertise in oracle cloud services for that you can visit veebrij.com

    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •