|
|
| Re: What is the diff. between row and statement level trigger? [message #369753 is a reply to message #369750] |
Wed, 04 October 2000 05:27   |
Gs
Messages: 8
Registered: September 2000
|
Junior Member |
|
|
As I understand ....
Statement Trigger : the trigger body (PL/SQL Block) executes once for the event (delete/ update/ insert)
Row Trigger : the trigger body execute once foe EACH ROW affected by the event
So if DML statement affects a single row, the statement/ row trigger fire exactly one, but if many row affects, and statement trigger fire only once, but the row trigger fire as per the rows affected.
Hope this will help.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
