[Home] [Help] [Dependency Information]
Object Name: | DBA_TRIGGER_COLS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Column usage in all triggers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRIGGER_OWNER | VARCHAR2 | (128) | Owner of the trigger | |
TRIGGER_NAME | VARCHAR2 | (128) | Name of the trigger | |
TABLE_OWNER | VARCHAR2 | (128) | Owner of the table | |
TABLE_NAME | VARCHAR2 | (128) | Name of the table on which the trigger is defined | |
COLUMN_NAME | VARCHAR2 | (4000) | Name of the column or the attribute of the ADT column used in trigger definition | |
COLUMN_LIST | VARCHAR2 | (3) | Is column specified in UPDATE OF clause? | |
COLUMN_USAGE | VARCHAR2 | (17) | Usage of column within trigger body |
Cut, paste (and edit) the following text to query this object:
SELECT TRIGGER_OWNER
, TRIGGER_NAME
, TABLE_OWNER
, TABLE_NAME
, COLUMN_NAME
, COLUMN_LIST
, COLUMN_USAGE
FROM SYS.DBA_TRIGGER_COLS;
|
|
|