ALL_TRIGGER_COLS

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.

Related Views

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	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`.