Updating pl sql trigger
2) Statement level trigger - An event is triggered for each sql statement executed.The following hierarchy is followed when a trigger is fired. 2) Next BEFORE row level trigger fires, once for each row affected.4) Finally the AFTER statement level trigger fires.For Example: Let's create a table 'product_check' which we can use to store messages when triggers are fired.
Vishwanath Dalvi is a gifted engineer and tech enthusiast. When not hacking around or supporting the open source community, he is trying to overcome his phobia of dogs.A trigger is triggered automatically when an associated DML statement is executed.