Friday, 9 May 2014

What is Trigger and types of Triggers in Oracle


A set of pl/sql statements automatically executed whenever a dml statements are performed on a table. The act of executing a trigger is known as firing the trigger.
Two types of triggers
Row level trigger; this trigger will fire every row manipulated

Statement level trigger; this trigger will be fired only once for dml statements