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

Object Details

Object Name:	KU$_STRMCOL_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
COL_SORTKEY	NUMBER
BASE_INTCOL_NUM	NUMBER
BASE_COL_TYPE	NUMBER
PROPERTY	NUMBER
PROPERTY2	NUMBER
NAME	VARCHAR2	(128)
ATTRNAME	VARCHAR2	(4000)
TYPE_NUM	NUMBER
LENGTH	NUMBER
PRECISION_NUM	NUMBER
SCALE	NUMBER
NOT_NULL	NUMBER
CHARSETID	NUMBER
CHARSETFORM	NUMBER
CHARLENGTH	NUMBER
LOB_PROPERTY	NUMBER
TYPEMD	KU$_STRMCOLTYPE_T	(64)
BASE_COL_NAME	VARCHAR2	(4000)
ATTRNAME2	VARCHAR2	(4000)

Query Text

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


SELECT OBJ_NUM
,      COL_NUM
,      INTCOL_NUM
,      SEGCOL_NUM
,      COL_SORTKEY
,      BASE_INTCOL_NUM
,      BASE_COL_TYPE
,      PROPERTY
,      PROPERTY2
,      NAME
,      ATTRNAME
,      TYPE_NUM
,      LENGTH
,      PRECISION_NUM
,      SCALE
,      NOT_NULL
,      CHARSETID
,      CHARSETFORM
,      CHARLENGTH
,      LOB_PROPERTY
,      TYPEMD
,      BASE_COL_NAME
,      ATTRNAME2
FROM SYS.KU$_STRMCOL_VIEW;

Dependencies

[top of page]

SYS.KU$_STRMCOL_VIEW references the following:

SYS: ATTRCOL$; COL$; DBMS_METADATA - show dependent code; DBMS_METADATA_UTIL - show dependent code; KU$_STRMCOLTYPE_T; KU$_STRMCOLTYPE_VIEW; KU$_STRMCOL_T; KU$_STRMSUBCOLTYPE_LIST_T; OPQTYPE$; STANDARD - show dependent code

SYS.KU$_STRMCOL_VIEW is referenced by following:

SYS: KU$_STRMTABLE_VIEW