Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Confusion in Order of row and statement level trigger

685758Sep 16 2011 — edited Sep 16 2011
Hi can anyone tell me, if i create some trigger on table emp as in below order..

BEFORE INSERT .. ROW LEVEL
BEFORE INSERT .. STMNT LEVEL
AFTER INSERT .. ROW LEVEL
AFTER INSERT .. STMNT LEVEL


than what will will be order of execution of trigers?
How oracle will decide order?

plz provide me some documents related to triggers execution order..thnx in advance..!
This post has been answered by BluShadow on Sep 16 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 14 2011
Added on Sep 16 2011
6 comments
1,402 views