Triggers

A trigger is a special database procedure (a sequence of statements) that the database system executes after a specific event occurs.

You can define the following types of triggers:

?     Triggers that are executed after an SQL statement changes data in a base table (or a view table based on this base table).

?     System triggers, that the database system executes after the database instance is restarted.

You can define as many triggers as required.

See also:

SQL Reference Manual

Trigger Name

CREATE TRIGGER Statement (create_trigger_statement)

CREATE SYSTEM TRIGGER Statement (create_system_trigger_statement)