Order of execution of Triggers
If 2 or more triggers are defined on the same statement of a table, then the order of execution of them is –
1. All before statement triggers
2. All before row triggers
3. All after row triggers
4. All after statement triggers
But, along with this, if we have 2 or more triggers defined at the same level, then we can also order their execution. Oracle has provided the FOLLOWS keyword for this.
If 2 or more triggers are defined on the same statement of a table, then the order of execution of them is –
1. All before statement triggers
2. All before row triggers
3. All after row triggers
4. All after statement triggers
But, along with this, if we have 2 or more triggers defined at the same level, then we can also order their execution. Oracle has provided the FOLLOWS keyword for this.
