Results 1 to 6 of 6

Thread: Which trigger will fires first?

  1. #1
    Expert Member
    Join Date
    Oct 2006
    Answers
    209

    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]


  2. #2
    Expert Member
    Join Date
    Jun 2006
    Answers
    410

    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.


  3. #3
    Contributing Member
    Join Date
    Jun 2006
    Answers
    95

    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. #4
    Junior Member
    Join Date
    Feb 2007
    Answers
    4

    Re: Which trigger will fires first?

    can u send me answer about this


  5. #5
    Junior Member
    Join Date
    Feb 2007
    Answers
    4

    Re: Which trigger will fires first?

    plz send me


  6. #6
    Junior Member
    Join Date
    Jan 2008
    Answers
    24

    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
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact