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

VIEW: SYS.USER_VIEWS

Object Details
Object Name: USER_VIEWS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Description of the user's own views

[View Source]

Columns
Name Datatype Length Mandatory Comments
VIEW_NAME VARCHAR2 (128) Yes Name of the view
TEXT_LENGTH NUMBER

Length of the view text
TEXT LONG (0)
View text
TEXT_VC VARCHAR2 (4000)
Possibly truncated view text as VARCHAR2
TYPE_TEXT_LENGTH NUMBER

Length of the type clause of the object view
TYPE_TEXT VARCHAR2 (4000)
Type clause of the object view
OID_TEXT_LENGTH NUMBER

Length of the WITH OBJECT OID clause of the object view
OID_TEXT VARCHAR2 (4000)
WITH OBJECT OID clause of the object view
VIEW_TYPE_OWNER VARCHAR2 (128)
Owner of the type of the view if the view is a object view
VIEW_TYPE VARCHAR2 (128)
Type of the view if the view is a object view
SUPERVIEW_NAME VARCHAR2 (128)
Name of the superview, if view is a subview
EDITIONING_VIEW VARCHAR2 (1)
An indicator of whether the view is an Editioning View
READ_ONLY VARCHAR2 (1)
An indicator of whether the view is a Read Only View
CONTAINER_DATA VARCHAR2 (1)
An indicator of whether the view contains Container-specific data
BEQUEATH VARCHAR2 (12)
An indicator of whether the view is invoker rights
ORIGIN_CON_ID NUMBER

ID of Container where row originates
Query Text

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


SELECT VIEW_NAME
,      TEXT_LENGTH
,      TEXT
,      TEXT_VC
,      TYPE_TEXT_LENGTH
,      TYPE_TEXT
,      OID_TEXT_LENGTH
,      OID_TEXT
,      VIEW_TYPE_OWNER
,      VIEW_TYPE
,      SUPERVIEW_NAME
,      EDITIONING_VIEW
,      READ_ONLY
,      CONTAINER_DATA
,      BEQUEATH
,      ORIGIN_CON_ID
FROM SYS.USER_VIEWS;

Dependencies

[top of page]

SYS.USER_VIEWS references the following:

SchemaSYS
FunctionGETLONG
ViewINT$DBA_VIEWS
SYS.USER_VIEWS is referenced by following:

SchemaPUBLIC
SynonymUSER_VIEWS