Oracle Triggering Attributes

Category,Timing, and Level Triggering

Triggers can be fired based on the following criteria:

Category - (INSERT, DELETE, UPDATE) i.e. which kind of DML statement causes the trigger to fire.

Timing – (BEFORE or AFTER) i.e. whether the trigger fires before the statement is executed of after.

Level – (Row or Statement) i.e. whether it fires once for each row affected by trigger statement or whether it fires once.