ALL_TRIGGERS v16

The ALL_TRIGGERS view provides information about the triggers on tables that the current user can accessed.

NameTypeDescription
ownerTEXTUser name of the trigger owner.
schema_nameTEXTName of the schema in which the trigger resides.
trigger_nameTEXTName of the trigger.
trigger_typeTEXTThe type of the trigger. Possible values are: BEFORE ROW, BEFORE STATEMENT, AFTER ROW, AFTER STATEMENT.
triggering_eventTEXTThe event that fires the trigger.
table_ownerTEXTThe user 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_nameTEXTIncluded 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 only for compatibility.
trigger_bodyTEXTThe body of the trigger.
action_statementTEXTThe SQL command that executes when the trigger fires.