The ALL_TRIGGERS view provides the information about the triggers on tables that may be accessed by the current user.

Parameter Type Description
owner TEXT The username of the owner to which the trigger belongs.
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 activate the trigger.
table_owner TEXT The username of the owner that the table belongs to. The trigger is defined in this table.
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_name TEXT This parameter is supported for compatibility only. The value is REFERENCING NEW AS NEW OLD AS OLD.
status TEXT The status of the trigger. A value of VALID indicates that the trigger is enabled, and a value of NOTVALID indicates that the trigger is disabled.
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 activates.