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

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

Re: triggers [message #321825 is a reply to message #321824] Wed, 21 May 2008 07:16 Go to previous messageGo to next message
Messages: 21064
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
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: Wed Apr 26 11:12:47 CDT 2017

Total time taken to generate the page: 0.22146 seconds