-
Expert Member
Which trigger will fires first?
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: [This question was asked by vishalkumar]
-
Expert Member
Re: Which trigger will fires first?
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.
-
Contributing Member
Re: Which trigger will fires first?
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.
-
Junior Member
Re: Which trigger will fires first?
can u send me answer about this
-
Junior Member
Re: Which trigger will fires first?
-
Junior Member
Re: Which trigger will fires first?
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules