triggers [message #321824] |
Wed, 21 May 2008 07:14  |
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 #321832 is a reply to message #321824] |
Wed, 21 May 2008 07:44  |
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.
|
|
|