Hi1. State the order in which the trigger will get fired2.I have an doubt in trigger. I created two trigger. trigger name is only different but structure is same. I want to know the order in which these two trigger will get fired

ily_saravanan
Profile Answers by ily_saravanan Questions by ily_saravanan
Nov 14th, 2006
3
1947

Questions by ily_saravanan answers by ily_saravanan

Showing Answers 1 - 3 of 3 Answers

subasini

Nov 17th, 2006

basically database trigger fired in this order.
Before Statement lable trigger
before row lebel
after row lable
After statement lable

Prashanth

Apr 24th, 2007

the one that is created last executes first

krishnaindia2007
Profile Answers by krishnaindia2007

Jun 22nd, 2008

1.Firing sequence of Database triggers on multiple rows
  Before statement trigger
  Before row trigger for first row
  After row trigger for first row
  Before row trigger for second row
  After row trigger for second row
  ..............................
After statement trigger
2.   The order in which multiple triggers of the same type fire is undefined in oracle. In 11g, one can define the execution order of triggers for the same event also.