DBA_TRIGGERS

All triggers in the database

Columns
___________________________
OWNER
Owner of the trigger
TRIGGER_NAME
Name of the trigger
TRIGGER_TYPE
When the trigger fires - BEFORE/AFTER and STATEMENT/ROW
TRIGGERING_EVENT
Statement that will fire the trigger - INSERT,UPDATE and/or DELETE
TABLE_OWNER
Owner of the table that this trigger is associated with
BASE_OBJECT_TYPE
--
TABLE_NAME
Name of the table that this trigger is associated with
COLUMN_NAME
The name of the column on which the trigger is defined over
REFERENCING_NAMES
Names used for referencing to OLD and NEW values within the trigger
WHEN_CLAUSE
WHEN clause must evaluate to true in order for triggering body to execute
STATUS
If DISABLED then trigger will not fire
DESCRIPTION
Trigger description
ACTION_TYPE
--
TRIGGER_BODY
Action taken by this trigger when it fires