If i have created triggers of same structure i.e both are on the same table, same event and same timing. Then which one will fires first?
NOTE: [I][This question was asked by vishalkumar][/I]
Printable View
If i have created triggers of same structure i.e both are on the same table, same event and same timing. Then which one will fires first?
NOTE: [I][This question was asked by vishalkumar][/I]
In Oracle it is undefined. Any one of the triggers will fire first. It is better to merge them as a single trigger if there is any dependency in the order of execution.
agree with james...
You can create multiple triggers of the same type (BEFORE, AFTER, INSTEAD OF) for the same triggering event. The order of execution among the triggers is indeterminate.
can u send me answer about this
plz send me
the recently created trigger will be fired first
suppose u created trigger t1 and then t2 for the same instant
here t2 will be fired first and then t1