|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
To be finished...
Execution order of triggers
If there are multiple triggers (for example before update of XYZ) on a table, Oracle does not guarantee the execution order of these triggers. At least not until Oracle 11g.
Instead of triggers
The create trigger statement creates a trigger.
A logoff trigger fires when someone disconnects from Oracle.
A servererror trigger fires when an error is encountered.
Disabling triggers on a table
Triggers that were created on a table can be disabled with one single command:
alter table name_of_table disable all triggers;
Similarly, the triggers can be enabled again with
alter table name_of_table enable all triggers;