What are cascading triggers?

A Trigger that contains statements which cause invoking of other Triggers are known as cascading triggers. Here’s the order of execution of statements in case of cascading triggers:

• Execute all BEFORE statement triggers that apply to the current statement.
• Loop for each row affected statement.
• Execute all BEFORE row triggers that apply to the current statement in the loop.
• Lock and change row, perform integrity constraints check; release lock.
• Execute all AFTER row triggers that apply to the current statement.
• Execute all AFTER statement triggers that apply to the current statement.

Posted in: 500 Oracle interview questions and answers