View Full Version : What is trigger?

05-12-2011, 10:54 AM
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.

03-13-2013, 09:30 AM
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