Home » SQL & PL/SQL » SQL & PL/SQL » Set a order to execute triggers of the same type
Set a order to execute triggers of the same type [message #336993] Tue, 29 July 2008 10:26 Go to next message
shoaib123
Messages: 118
Registered: December 2007
Location: Chicago
Senior Member
Window Professional 2002 and Oracle9i Enterprise Edition Release 9.2.0.8.0

what is the order of execution in case when there are multiple triggers of the same type? How do we know which trigger will be executed first. Can we intentionally set a order to execute the trigger of the same type on any table.

[Updated on: Tue, 29 July 2008 11:03] by Moderator

Report message to a moderator

Re: Set a order to execute triggers of the same type [message #336996 is a reply to message #336993] Tue, 29 July 2008 10:38 Go to previous message
szogu
Messages: 21
Registered: July 2008
Junior Member

Check out this link, it has you answer

http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg13trg.htm#704

regards
Previous Topic: Compare oracle timestamp
Next Topic: Error ORA-01460
Goto Forum:
  


Current Time: Mon Nov 11 01:36:16 CST 2024