Difference between Row level and Statement level triggers
Last Updated :
18 Feb, 2023
Triggers are defined as stored programs which are automatically executed whenever some events such as CREATE, ALTER, UPDATE, INSERT, DELETE takes place.They can be defined on a database, table, view with which event is associated.
Triggers can be broadly classified into Row Level and Statement Level triggers.
Broadly, these can be differentiated as:
Row Level Triggers |
Statement Level Triggers |
Row level triggers executes once for each and every row in the transaction. |
Statement level triggers executes only once for each single transaction. |
Specifically used for data auditing purpose. |
Used for enforcing all additional security on the transactions performed on the table. |
“FOR EACH ROW” clause is present in CREATE TRIGGER command. |
“FOR EACH STATEMENT” clause is omitted in CREATE TRIGGER command. |
Example: If 1500 rows are to be inserted into a table, the row level trigger would execute 1500 times. |
Example: If 1500 rows are to be inserted into a table, the statement level trigger would execute only once. |
Like Article
Suggest improvement
Share your thoughts in the comments
Please Login to comment...