Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Trigger execution order

Trigger execution order

From: Sameer Utrankar <sameeru_at_exchnage.ml.com>
Date: Fri, 21 Aug 1998 15:58:20 -0400
Message-ID: <35DDD15B.E86BE8B7@exchnage.ml.com> 





If I have 2 triggers on a table


(1) before insert row


(2) before insert or update row




how would I know which one is going to get executed first ?



If order is not guaranteed then that would mean I could never separate
out triggers the way I have specified above and will always have to have
"before insert or update row" and keep on checking if inserting and if
updating. Is that necessary ?

Received on Fri Aug 21 1998 - 14:58:20 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US