Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Which trigger will fires first?

This is a discussion on Which trigger will fires first? within the SQL forums, part of the Databases category; 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 ...

Geeks Talk > Databases > SQL Which trigger will fires first?

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   12-28-2006

JobHelper Expert Member   Join Date: Oct 2006 Posts: 690 Thanks: 0 Thanked 49 Times in 41 Posts

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]

The Following 2 Users Say Thank You to JobHelper For This Useful Post:

deepak81, k_Mahesh02

Sponsored Links

#2 (permalink)   02-06-2007

jamesravid Expert Member   Join Date: Jun 2006 Location: India Posts: 411 Thanks: 15 Thanked 33 Times in 25 Posts

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. __________________ Cheers, :) James:)

The Following User Says Thank You to jamesravid For This Useful Post:

Jim.Anderson

#3 (permalink)   02-07-2007

Jim.Anderson Expert Member   Join Date: Jun 2006 Posts: 140 Thanks: 2 Thanked 12 Times in 9 Posts

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.

#4 (permalink)   02-10-2007

srwr_shaikh Junior Member   Join Date: Feb 2007 Location: nasik (india) Posts: 4 Thanks: 1 Thanked 1 Time in 1 Post

Re: Which trigger will fires first? can u send me answer about this

#5 (permalink)   02-10-2007

srwr_shaikh Junior Member   Join Date: Feb 2007 Location: nasik (india) Posts: 4 Thanks: 1 Thanked 1 Time in 1 Post

Re: Which trigger will fires first? plz send me

#6 (permalink)   01-24-2008

chaitueeturi Junior Member   Join Date: Jan 2008 Posts: 23 Thanks: 0 Thanked 0 Times in 0 Posts

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

Geeks Talk > Databases > SQL

« what is trigger | Finding Error in PL/SQL Code »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

All times are GMT -4. The time now is 06:22 AM.