DBA_TRIGGERS v10

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

NameTypeDescription
ownerTEXTUser name of the trigger’s owner.
schema_nameTEXTThe name of the schema in which the trigger resides.
trigger_nameTEXTThe name 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 for compatibility only. Value will always be TABLE.
table_nameTEXTThe name of the table on which the trigger is defined.
referencing_namesTEXTIncluded for compatibility only. Value will always be REFERENCING NEW AS NEW OLD AS OLD.
statusTEXTStatus indicates if the trigger is enabled (VALID) or disabled (NOTVALID).
descriptionTEXTIncluded for compatibility only.
trigger_bodyTEXTThe body of the trigger.
action_statementTEXTThe SQL command that executes when the trigger fires.