eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.KU$_PRIM_COLUMN_VIEW

Object Details

Object Name:	KU$_PRIM_COLUMN_VIEW
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
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

Query Text

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;

Dependencies

[top of page]

SYS.KU$_PRIM_COLUMN_VIEW references the following:

SYS: COL$; DBMS_EDITIONS_UTILITIES - show dependent code; DBMS_METADATA - show dependent code; DBMS_METADATA_UTIL - show dependent code; ECOL$; KU$_CONSTRAINT0_T; KU$_CONSTRAINT0_VIEW; KU$_CONSTRAINT_COL_VIEW; KU$_IDENTITY_COL_T; KU$_IDENTITY_COL_VIEW; KU$_PRIM_COLUMN_T; OBJ$; OPQTYPE$; STANDARD - show dependent code; USER$; UTL_RAW - show dependent code; XMLTYPE

SYS.KU$_PRIM_COLUMN_VIEW is referenced by following:

SYS: KU$_HTABLE_VIEW; KU$_PHTABLE_VIEW