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