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

Object Details

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

[View Source]

Columns

Name	Datatype	Length
VERS_MAJOR	CHAR	(1)
VERS_MINOR	CHAR	(1)
OBJ_NUM	NUMBER
SCHEMA_OBJ	KU$_SCHEMAOBJ_T	(2768)
AUDIT_VAL	VARCHAR2	(38)
COLS	NUMBER
INTCOLS	NUMBER
PROPERTY	NUMBER
PROPERTY2	NUMBER
FLAGS	NUMBER
TEXTLENGTH	NUMBER
TEXT	CLOB	(4000)
PARSED_TEXT	XMLTYPE	(64)
WITH_OPTION	KU$_CONSTRAINT0_T	(264)
TEXTVCNT	KU$_VCNT	(0)
COL_LIST	KU$_SIMPLE_COL_LIST_T	(64)
COL_LIST2	KU$_COLUMN_LIST_T	(64)
OWNER_NAME	VARCHAR2	(128)
NAME	VARCHAR2	(128)
TYPETEXTLENGTH	NUMBER
TYPETEXT	VARCHAR2	(4000)
OIDTEXTLENGTH	NUMBER
OIDTEXT	VARCHAR2	(4000)
TRANSTEXTLENGTH	NUMBER
TRANSTEXT	VARCHAR2	(4000)
UNDERTEXTLENGTH	NUMBER
UNDERTEXT	VARCHAR2	(4000)
CON1_LIST	KU$_CONSTRAINT1_LIST_T	(64)
CON2_LIST	KU$_CONSTRAINT2_LIST_T	(64)

Query Text

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


SELECT VERS_MAJOR
,      VERS_MINOR
,      OBJ_NUM
,      SCHEMA_OBJ
,      AUDIT_VAL
,      COLS
,      INTCOLS
,      PROPERTY
,      PROPERTY2
,      FLAGS
,      TEXTLENGTH
,      TEXT
,      PARSED_TEXT
,      WITH_OPTION
,      TEXTVCNT
,      COL_LIST
,      COL_LIST2
,      OWNER_NAME
,      NAME
,      TYPETEXTLENGTH
,      TYPETEXT
,      OIDTEXTLENGTH
,      OIDTEXT
,      TRANSTEXTLENGTH
,      TRANSTEXT
,      UNDERTEXTLENGTH
,      UNDERTEXT
,      CON1_LIST
,      CON2_LIST
FROM SYS.KU$_VIEW_VIEW;

Dependencies

[top of page]

SYS.KU$_VIEW_VIEW references the following:

SYS: CDEF$; DBMS_METADATA - show dependent code; DBMS_METADATA_UTIL - show dependent code; DUAL; KU$_COLUMN_LIST_T; KU$_COLUMN_VIEW; KU$_CONSTRAINT0_T; KU$_CONSTRAINT0_VIEW; KU$_CONSTRAINT1_LIST_T; KU$_CONSTRAINT1_VIEW; KU$_CONSTRAINT2_LIST_T; KU$_CONSTRAINT2_VIEW; KU$_CONSTRAINT_COL_LIST_T; KU$_DOMIDX_2NDTAB_LIST_T; KU$_EDITION_SCHEMAOBJ_VIEW; KU$_INDEX_COL_LIST_T; KU$_IND_COMPART_LIST_T; KU$_IND_PART_LIST_T; KU$_IND_SUBPART_LIST_T; KU$_INSERT_TS_LIST_T; KU$_JIJOIN_LIST_T; KU$_JIJOIN_TABLE_LIST_T; KU$_PART_COL_LIST_T; KU$_SCHEMAOBJ_T; KU$_SIMPLE_COL_LIST_T; KU$_SIMPLE_COL_VIEW; KU$_SUBCOLTYPE_LIST_T; KU$_VCNT; KU$_VIEW_T; OBJ$; SESSION_ROLES; STANDARD - show dependent code; TYPED_VIEW$; UTL_RAW - show dependent code; VIEW$; XMLTYPE

SYS.KU$_VIEW_VIEW is referenced by following:

SYS: KU$_11_2_VIEW_VIEW