Triggers [Oracle]

To be finished...

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.

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.

Differences between before, after, each row and table level triggers.

:new and :old.

dba_triggers.

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;