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.