ALL_TRIGGER_COLS describes the use of columns in triggers owned by user or in triggers on tables owned by user. If the user has the CREATE ANY TRIGGER privilege, this view describes the use of columns in all triggers.
DBA_TRIGGER_COLS provides such information for all triggers in the database.
USER_TRIGGER_COLS provides such information for all triggers owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
TRIGGER_OWNER |
VARCHAR2(30) |
Owner of the trigger | |
TRIGGER_NAME |
VARCHAR2(30) |
Name of the trigger | |
TABLE_OWNER |
VARCHAR2(30) |
Owner of the table on which the trigger is defined | |
TABLE_NAME |
VARCHAR2(30) |
Table on which the trigger is defined | |
COLUMN_NAME |
VARCHAR2(4000) |
Name of the column used in the trigger | |
COLUMN_LIST |
VARCHAR2(3) |
Column specified in UPDATE clause (YES | NO) |
|
COLUMN_USAGE |
VARCHAR2(17) |
How the column is used in the trigger. All applicable combinations of NEW, OLD, IN, OUT, and IN OUT. |