Pages

Friday, 29 November 2013

Explain Row level and statement level trigger.

A trigger if specified FOR EACH ROW; it is fired for each of the table being affected by the triggering statement. For example if a trigger needs to be fired when rows of a table are deleted, it will be fired as many times the rows are deleted.  
If FOR EACH ROW is not specified, it is application to a statement and the trigger is executed at a statement level.

No comments:

Post a Comment

Enter Your Question

Total Pageviews

Blog