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$_PCOLUMN_VIEW

Object Details

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

[View Source]

Columns

Name	Datatype	Length
OBJ_NUM	NUMBER
COL_NUM	NUMBER
SEGCOL_NUM	NUMBER
SEGCOLLENGTH	NUMBER
OFFSET	NUMBER
NAME	VARCHAR2	(128)
ATTRNAME	VARCHAR2	(4000)
TYPE_NUM	NUMBER
LENGTH	NUMBER
FIXEDSTORAGE	NUMBER
PRECISION_NUM	NUMBER
SCALE	NUMBER
NOT_NULL	NUMBER
DEFLENGTH	NUMBER
DEFAULT_VAL	VARCHAR2	(4000)
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)
PLOBMD	KU$_PARTLOB_T	(3280)
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

Query Text

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


SELECT OBJ_NUM
,      COL_NUM
,      SEGCOL_NUM
,      SEGCOLLENGTH
,      OFFSET
,      NAME
,      ATTRNAME
,      TYPE_NUM
,      LENGTH
,      FIXEDSTORAGE
,      PRECISION_NUM
,      SCALE
,      NOT_NULL
,      DEFLENGTH
,      DEFAULT_VAL
,      BINARYDEFVAL
,      INTCOL_NUM
,      BASE_INTCOL_NUM
,      BASE_COL_TYPE
,      BASE_COL_NAME
,      PROPERTY
,      PROPERTY2
,      CHARSETID
,      CHARSETFORM
,      CON
,      TYPEMD
,      LOBMD
,      PLOBMD
,      OPQMD
,      OIDINDEX
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      SPARE5
,      SPARE6
,      IDENTITY_COL
,      ATTRNAME2
,      COL_SORTKEY
FROM SYS.KU$_PCOLUMN_VIEW;

Dependencies

[top of page]

SYS.KU$_PCOLUMN_VIEW references the following:

SYS: ATTRCOL$; COL$; DBMS_METADATA - show dependent code; DBMS_METADATA_UTIL - show dependent code; KU$_COLTYPE_T; KU$_COLTYPE_VIEW; KU$_CONSTRAINT0_T; KU$_CONSTRAINT0_VIEW; KU$_CONSTRAINT_COL_VIEW; KU$_IDENTITY_COL_T; KU$_IDENTITY_COL_VIEW; KU$_LOB_T; KU$_LOB_VIEW; KU$_OIDINDEX_T; KU$_OIDINDEX_VIEW; KU$_OPQTYPE_T; KU$_OPQTYPE_VIEW; KU$_PARTLOB_T; KU$_PARTLOB_VIEW; KU$_PCOLUMN_T; KU$_SUBCOLTYPE_LIST_T; OPQTYPE$; STANDARD - show dependent code; UTL_RAW - show dependent code

SYS.KU$_PCOLUMN_VIEW is referenced by following:

SYS: KU$_ACPTABLE_VIEW; KU$_PFHTABLE_VIEW; KU$_PIOTABLE_VIEW