0 votes
in Oracle by
What is the key difference between ROW-level and STATEMENT-level triggers in Oracle?

1 Answer

0 votes
by
ROW-level triggers fire once for each affected row, therefore allowing row-specific actions.

STATEMENT-level triggers are executed only once for the entire statement. This is regardless of the number of affected rows and is more suitable for actions that don't depend on individual rows.

Related questions

0 votes
asked Jan 17 in Oracle by AdilsonLima
0 votes
asked Mar 27, 2023 in Azure by john ganales
...