DBA_TRIGGERS v15

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

NameTypeDescription
ownerTEXTUser name of the trigger owner.
schema_nameTEXTName of the schema in which the trigger resides.
trigger_nameTEXTName of the trigger.
trigger_typeTEXTType of the trigger. Possible values are: BEFORE ROW, BEFORE STATEMENT, AFTER ROW, AFTER STATEMENT.
triggering_eventTEXTEvent that fires the trigger.
table_ownerTEXTUser name of the owner of the table on which the trigger is defined.
base_object_typeTEXTIncluded only for compatibility. Value is always TABLE.
table_nameTEXTName of the table on which the trigger is defined.
referencing_namesTEXTIncluded only for compatibility. Value is always REFERENCING NEW AS NEW OLD AS OLD.
statusTEXTStatus indicates if the trigger is enabled (VALID) or disabled (NOTVALID).
descriptionTEXTIncluded onky for compatibility.
trigger_bodyTEXTThe body of the trigger.
action_statementTEXTThe SQL command that executes when the trigger fires.