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