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

VIEW: SYS.DBA_VIEWS_AE

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

Description of all views in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of the view
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 an object view
VIEW_TYPE VARCHAR2 (128)
Type of the view if the view is an 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 OWNER
,      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.DBA_VIEWS_AE;

Dependencies

[top of page]

SYS.DBA_VIEWS_AE references the following:

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

SchemaPUBLIC
SynonymDBA_VIEWS_AE