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: 20847
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: Mon Oct 24 15:51:59 CDT 2016

Total time taken to generate the page: 0.10053 seconds