[Home] [Help] [Dependency Information]
Object Name: | CDB_TRIGGER_COLS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Column usage in all triggers in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRIGGER_OWNER | VARCHAR2 | (30) | Owner of the trigger | |
TRIGGER_NAME | VARCHAR2 | (30) | Name of the trigger | |
TABLE_OWNER | VARCHAR2 | (30) | Owner of the table | |
TABLE_NAME | VARCHAR2 | (30) | 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 | |
CON_ID | NUMBER | container id |
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
, CON_ID
FROM SYS.CDB_TRIGGER_COLS;
SYS.CDB_TRIGGER_COLS does not reference any database object
SYS.CDB_TRIGGER_COLS is referenced by following:
|
|
|