What are cascading triggers and how many maximum number of cascading triggers at a time we can write ? Thank you in advance.
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Answer by OraLearner · Jan 25, 2010 at 10:57 AM
When a statement in a trigger body causes another trigger to be fired, the triggers are said to be cascading triggers.
Maximum no of cascading triggers at a time = 32.
Answers Answers and Comments
No one has followed this question yet.
What are the various types of parameter modes in a procedure ?
how to find (A+B)/C from a single row when we assign grades to them
What is Pragma Init Exception in oracle?
What are the uses of Data Dictionary ?
How does we keep a history of PL/SQL code changes ?