DBA Data[Home] [Help] [Dependency Information]


TABLE: SYS.TRIGGERCOL$

Object Details
Object Name: TRIGGERCOL$
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
I_TRIGGERCOL1 NORMAL NONUNIQUE TablespaceSYSTEM ColumnOBJ#
ColumnCOL#
ColumnTYPE#
ColumnPOSITION#
I_TRIGGERCOL2 NORMAL NONUNIQUE TablespaceSYSTEM ColumnOBJ#
ColumnINTCOL#
ColumnTYPE#
ColumnPOSITION#
Columns
Name Datatype Length Mandatory Comments
OBJ# NUMBER
Yes
COL# NUMBER
Yes
TYPE# NUMBER
Yes
POSITION# NUMBER

INTCOL# NUMBER
Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OBJ#
,      COL#
,      TYPE#
,      POSITION#
,      INTCOL#
FROM SYS.TRIGGERCOL$;

Dependencies

[top of page]

SYS.TRIGGERCOL$ does not reference any database object

SYS.TRIGGERCOL$ is referenced by following:

SchemaSYS
ViewALL_TRIGGER_COLS
ViewDBA_TRIGGER_COLS
ViewKU$_TRIGGERCOL_VIEW
ViewUSER_TRIGGER_COLS