[Home] [Help] [Dependency Information]
Object Name: | KU$_COLUMN_VIEW |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJ_NUM | NUMBER | |||
COL_NUM | NUMBER | |||
SEGCOL_NUM | NUMBER | |||
SEGCOLLENGTH | NUMBER | |||
OFFSET | NUMBER | |||
NAME | VARCHAR2 | (128) | ||
ATTRNAME | VARCHAR2 | (4000) | ||
FULLATTRNAME | VARCHAR2 | (4000) | ||
TYPE_NUM | NUMBER | |||
LENGTH | NUMBER | |||
FIXEDSTORAGE | NUMBER | |||
PRECISION_NUM | NUMBER | |||
SCALE | NUMBER | |||
NOT_NULL | NUMBER | |||
DEFLENGTH | NUMBER | |||
DEFAULT_VAL | VARCHAR2 | (4000) | ||
PARSED_DEF | XMLTYPE | (64) | ||
BINARYDEFVAL | CLOB | (4000) | ||
INTCOL_NUM | NUMBER | |||
BASE_INTCOL_NUM | NUMBER | |||
BASE_COL_TYPE | NUMBER | |||
BASE_COL_NAME | VARCHAR2 | (4000) | ||
PROPERTY | NUMBER | |||
PROPERTY2 | NUMBER | |||
CHARSETID | NUMBER | |||
CHARSETFORM | NUMBER | |||
CON | KU$_CONSTRAINT0_T | (264) | ||
TYPEMD | KU$_COLTYPE_T | (64) | ||
LOBMD | KU$_LOB_T | (64) | ||
OPQMD | KU$_OPQTYPE_T | (1232) | ||
OIDINDEX | KU$_OIDINDEX_T | (1264) | ||
SPARE1 | NUMBER | |||
SPARE2 | NUMBER | |||
SPARE3 | NUMBER | |||
SPARE4 | VARCHAR2 | (1000) | ||
SPARE5 | VARCHAR2 | (1000) | ||
SPARE6 | VARCHAR2 | (19) | ||
IDENTITY_COL | KU$_IDENTITY_COL_T | (3304) | ||
ATTRNAME2 | VARCHAR2 | (4000) | ||
COL_SORTKEY | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT OBJ_NUM
, COL_NUM
, SEGCOL_NUM
, SEGCOLLENGTH
, OFFSET
, NAME
, ATTRNAME
, FULLATTRNAME
, TYPE_NUM
, LENGTH
, FIXEDSTORAGE
, PRECISION_NUM
, SCALE
, NOT_NULL
, DEFLENGTH
, DEFAULT_VAL
, PARSED_DEF
, BINARYDEFVAL
, INTCOL_NUM
, BASE_INTCOL_NUM
, BASE_COL_TYPE
, BASE_COL_NAME
, PROPERTY
, PROPERTY2
, CHARSETID
, CHARSETFORM
, CON
, TYPEMD
, LOBMD
, OPQMD
, OIDINDEX
, SPARE1
, SPARE2
, SPARE3
, SPARE4
, SPARE5
, SPARE6
, IDENTITY_COL
, ATTRNAME2
, COL_SORTKEY
FROM SYS.KU$_COLUMN_VIEW;
|
|
|