Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-08
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_VIEWS_AE

ALL_VIEWS_AE describes the views (across all editions) accessible to the current user.

Related Views

Column Datatype NULL Description
OWNER VARCHAR2(30) NOT NULL Owner of the view
VIEW_NAME VARCHAR2(30) NOT NULL Name of the view
TEXT_LENGTH NUMBER   Length of the view text
TEXT LONG   View text
TYPE_TEXT_LENGTH NUMBER   Length of the type clause of the typed view
TYPE_TEXT VARCHAR2(4000)   Type clause of the typed view
OID_TEXT_LENGTH NUMBER   Length of the WITH OID clause of the typed view
OID_TEXT VARCHAR2(4000)   WITH OID clause of the typed view
VIEW_TYPE_OWNER VARCHAR2(30)   Owner of the type of the view if the view is an typed view
VIEW_TYPE VARCHAR2(30)   Type of the view if the view is a typed view
SUPERVIEW_NAME VARCHAR2(30)   Name of the superview, if the view is a subview
EDITIONING_VIEW VARCHAR2(1)   Indicates whether the view is an editioning view (Y) or not (N)
READ_ONLY VARCHAR2(1)   Indicates whether the view is read-only (Y) or not (N)
EDITION_NAME VARCHAR2(30)   Name of the application edition where the object is defined