Trigger event predicates (PL/SQL)

The trigger event predicates, UPDATING, DELETING, and INSERTING can only be used in a trigger to identify the event that activated the trigger.

>>-+-DELETING--+-----------------------------------------------><
   +-INSERTING-+   
   '-UPDATING--'   

DELETING

True if the trigger was activated by a delete operation. False otherwise.

INSERTING

True if the trigger was activated by an insert operation. False otherwise.

UPDATING

True if the trigger was activated by an update operation. False otherwise.

These predicates can be specified as a single search condition, or as a boolean factor within a complex search condition in a WHEN clause or PL/SQL statement.