The USER_TRIGGERS view provides the information about all triggers on tables owned by the current user.

Parameter Type Description
schema_name TEXT The name of the schema to which the trigger belongs.
trigger_name TEXT The name of the trigger.
trigger_type TEXT The type of the trigger. Valid values:
  • BEFORE ROW
  • BEFORE STATEMENT
  • AFTER ROW
  • AFTER STATEMENT
triggering_event TEXT The event that fires the trigger.
table_owner TEXT The username of the owner of the table on which the trigger is defined.
base_object_type TEXT This parameter is supported for compatibility only. The value is TABLE.
table_name TEXT The name of the table on which the trigger is defined.
referencing_names TEXT This parameter is supported for compatibility only. The value is REFERENCING. NEW AS NEW OLD AS OLD.
status TEXT Specifies whether the trigger is enabled (VALID) or disabled (NOTVALID).
description TEXT This parameter is supported for compatibility only.
trigger_body TEXT The body of the trigger.
action_statement TEXT The SQL statement that is executed when the trigger fires.