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.

Read syntax diagramSkip visual syntax diagramDELETINGINSERTINGUPDATING
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.