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