ALL_TRIGGERS v13
The ALL_TRIGGERS view provides information about the triggers on tables that may be accessed by the current user.
| Name | Type | Description |
|---|---|---|
owner | TEXT | User name of the trigger’s owner. |
schema_name | TEXT | The name of the schema in which the trigger resides. |
trigger_name | TEXT | The name of the trigger. |
trigger_type | TEXT | The type of the trigger. Possible values are: BEFORE ROW, BEFORE STATEMENT, AFTER ROW, AFTER STATEMENT |
triggering_event | TEXT | The event that fires the trigger. |
table_owner | TEXT | The user name of the owner of the table on which the trigger is defined. |
base_object_type | TEXT | Included for compatibility only. Value will always be TABLE. |
table_name | TEXT | The name of the table on which the trigger is defined. |
referencing_name | TEXT | Included for compatibility only. Value will always be REFERENCING NEW AS NEW OLD AS OLD. |
status | TEXT | Status indicates if the trigger is enabled (VALID) or disabled (NOTVALID). |
description | TEXT | Included for compatibility only. |
trigger_body | TEXT | The body of the trigger. |
action_statement | TEXT | The SQL command that executes when the trigger fires. |