What are cascading triggers?

What are cascading triggers?

At times when SQL statement of a trigger can fire other triggers. This results in cascading triggers. Oracle allows around 32 cascading triggers. Cascading triggers can cause result in abnormal behavior of the application.

Oracle - What are cascading triggers? - Feb 07, 2010 at 14:20 PM by Shuchi Gauri

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.

Oracle - What are cascading triggers? - April 10, 2009 at 11:00 AM

What are cascading triggers?  

When a statement in a trigger body causes another trigger to be fired, the triggers are said to be cascading.

Also read

Difference between post database commit & post-form commit

Post-form commit fires once during the post and commit transactions process, after the database commit occurs. The post-form-commit trigger fires after inserts.............

Disadvantages of trigger in oracle

Triggers can execute every time some field in database is updated. If a field is likely to be updated often.............

Oracle Triggers

What is trigger in oracle?, What are the types of triggers?, How the triggers are attached to the table?, What are triggering attributes?..............

Explain the difference between trigger and stored procedure.

Procedure runs only when one call them manually whereas a trigger runs when there is any activity (insert,update,delete) on table on which the trigger is written..........

Explain Row level and statement level trigger.

Row Level Trigger is fired each time row is affected by Insert, Update or Delete command. If statement doesn’t affect any row, no trigger action happens.......... 

<<Previous  Next>>

Write your comment - Share Knowledge and Experience