Triggers
Definitions: It is special kind of Stored Procedure which is executed whenever specific event is occurred in/on a table or database 2 types in Sql server 2000: 1. DML Trigger Instead of triggers After triggers 3 types in Sql server 2005: • DML Triggers Instead of triggers After triggers • DDL Triggers • CLR Triggers 2 types in Oracle: Row Level Triggers Statement Triggers