Static Data Dictionary Views, 95 of 452

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 NULL Description

TRIGGER_OWNER

VARCHAR2(30)

NOT NULL

Owner of the triggers

TRIGGER_NAME

VARCHAR2(30)

NOT NULL

Name of the trigger

TABLE_OWNER

VARCHAR2(30)

NOT NULL

Owner of the table on which the trigger is defined

TABLE_NAME

VARCHAR2(30)

NOT NULL

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: Y | N

COLUMN_USAGE

VARCHAR2(17)

How the column is used in the trigger. All applicable combinations of NEW, OLD, IN, OUT, and IN OUT.

Column	Datatype	NULL	Description
`TRIGGER_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the triggers
`TRIGGER_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the trigger
`TABLE_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the table on which the trigger is defined
`TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	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: Y \| N
`COLUMN_USAGE`	`VARCHAR2(17)`		How the column is used in the trigger. All applicable combinations of `NEW`, `OLD`, `IN`, `OUT`, and `IN` `OUT`.