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

VIEW: SYS.USER_VIEWS_AE

Object Details
Object Name: USER_VIEWS_AE
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
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
EDITION_NAME VARCHAR2 (128)
Name of the Application Edition where the object is defined
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
Query Text

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


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

Dependencies

[top of page]

SYS.USER_VIEWS_AE references the following:

SchemaSYS
TableOBJ$
TableSUPEROBJ$
TableTYPED_VIEW$
TableVIEW$
View_ACTUAL_EDITION_OBJ
SYS.USER_VIEWS_AE is referenced by following:

SchemaPUBLIC
SynonymUSER_VIEWS_AE