|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Oracle Trigger execution order
Hi,
Suppose a table have three AFTER INSERT triggers A, B and C. How to determine the order of these triggers' execution? Do we have the control to decide how these triggers should be fired? Then, is it possible to force a trigger to be executed at last? Thanks, |
|
#2
|
|||
|
|||
|
doesnt it depend on if a trigger should be fired before insert etc
so three triggers: A before insert b after insert c on update so the execution would probably be A B C or cant u nest triggers? or make them into one big one thus controlling the way u want things to happen |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Oracle Trigger execution order |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|