Home » SQL & PL/SQL » SQL & PL/SQL » triggers
triggers [message #321824] Wed, 21 May 2008 07:14 Go to next message
gauravpuri2002
Messages: 24
Registered: October 2007
Location: Bangalore
Junior Member
Hi

can we create two before insert trigger on same table.the trigger name will be different.

Regards
GAurav
Re: triggers [message #321825 is a reply to message #321824] Wed, 21 May 2008 07:16 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try, and you'll know.
Re: triggers [message #321832 is a reply to message #321824] Wed, 21 May 2008 07:44 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
What you can't do (until 11g) is guarantee which order they will fire in.
I've generally found that they fire in the order of the most recently compiled first, but there is no guarantee of this.
Previous Topic: Help On Instead Of triggers
Next Topic: Join question
Goto Forum:
  


Current Time: Sun Dec 11 04:11:20 CST 2016

Total time taken to generate the page: 0.10492 seconds