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
CREATE TRIGGER Statement (create_trigger_statement)
CREATE SYSTEM TRIGGER Statement (create_system_trigger_statement)