The DBA_TRIGGERS view provides the information about all triggers in the database.

Parameter Type Description
owner TEXT The username of the owner to which a 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 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 Indicates 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 is activated.