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: 21148
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: Execute immediate + Tuning this piece of code (merged)
Next Topic: Move LOB to new tablespace but still visible in old...
Goto Forum:

Current Time: Tue Aug 22 00:37:31 CDT 2017

Total time taken to generate the page: 0.13426 seconds