Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the difference between a ROW-LEVEL trigger and a STATEMENT-LEVEL trigger?

April 26, 2017difference row-level statement-level Trigger

0

Posted

What is the difference between a ROW-LEVEL trigger and a STATEMENT-LEVEL trigger?

1 Answer

0

Posted

A ROW-LEVEL trigger fires once for every row affected by the triggering statement and references the values for each of the rows. A STATEMENT-LEVEL trigger is executed only once, before or after the triggering SQL statement is executed. It cannot refer to any values in the rows affected by the SQL statement.