| Multiple Trigers on a Table [message #50187] |
Tue, 05 March 2002 07:53  |
ashu
Messages: 7
Registered: March 2002
|
Junior Member |
|
|
|
Does Oracle allow multiple triggers to be created on a table for the same DML command, eg 2 Insert or 2 Update Triggers? If it does can we configure the order of execution of these triggers & is there any performance hits?
|
|
|
|
| Re: Multiple Trigers on a Table [message #50189 is a reply to message #50187] |
Tue, 05 March 2002 08:00  |
saleem
Messages: 65
Registered: January 2002
|
Member |
|
|
|
you can have multiple triggers on a table, but the question is why would you? if both triggers are going to fire on the same action, the just place the code in the correct order in the trigger and you will have what you need.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
