[Home] [Help] [Dependency Information]
Object Name: | KU$_PRIM_COLUMN_VIEW |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJ_NUM | NUMBER | |||
COL_NUM | NUMBER | |||
INTCOL_NUM | NUMBER | |||
SEGCOL_NUM | NUMBER | |||
PROPERTY | NUMBER | |||
PROPERTY2 | NUMBER | |||
NAME | VARCHAR2 | (128) | ||
TYPE_NUM | NUMBER | |||
LENGTH | NUMBER | |||
PRECISION_NUM | NUMBER | |||
SCALE | NUMBER | |||
NOT_NULL | NUMBER | |||
DEFLENGTH | NUMBER | |||
DEFAULT_VAL | VARCHAR2 | (4000) | ||
DEFAULT_VALC | CLOB | (4000) | ||
PARSED_DEF | XMLTYPE | (64) | ||
BINARYDEFVAL | CLOB | (4000) | ||
GUARD_ID | NUMBER | |||
CHARSETID | NUMBER | |||
CHARSETFORM | NUMBER | |||
BASE_INTCOL_NUM | NUMBER | |||
BASE_COL_TYPE | NUMBER | |||
BASE_COL_NAME | VARCHAR2 | (0) | ||
CON | KU$_CONSTRAINT0_T | (264) | ||
SPARE1 | NUMBER | |||
SPARE2 | NUMBER | |||
SPARE3 | NUMBER | |||
SPARE4 | VARCHAR2 | (1000) | ||
SPARE5 | VARCHAR2 | (1000) | ||
SPARE6 | VARCHAR2 | (19) | ||
IDENTITY_COL | KU$_IDENTITY_COL_T | (3304) | ||
EVALEDITION_NUM | NUMBER | |||
UNUSABLEBEF_NUM | NUMBER | |||
UNUSABLEBEG_NUM | NUMBER | |||
COL_SORTKEY | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT OBJ_NUM
, COL_NUM
, INTCOL_NUM
, SEGCOL_NUM
, PROPERTY
, PROPERTY2
, NAME
, TYPE_NUM
, LENGTH
, PRECISION_NUM
, SCALE
, NOT_NULL
, DEFLENGTH
, DEFAULT_VAL
, DEFAULT_VALC
, PARSED_DEF
, BINARYDEFVAL
, GUARD_ID
, CHARSETID
, CHARSETFORM
, BASE_INTCOL_NUM
, BASE_COL_TYPE
, BASE_COL_NAME
, CON
, SPARE1
, SPARE2
, SPARE3
, SPARE4
, SPARE5
, SPARE6
, IDENTITY_COL
, EVALEDITION_NUM
, UNUSABLEBEF_NUM
, UNUSABLEBEG_NUM
, COL_SORTKEY
FROM SYS.KU$_PRIM_COLUMN_VIEW;
|
|
|