René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Triggers [Oracle]

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

Links

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;