ALL_VIEWS_AE

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

Related Views

DBA_VIEWS_AE describes all views (across all editions) in the database.
USER_VIEWS_AE describes the views (across all editions) owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the view
`VIEW_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the view
`TEXT_LENGTH`	`NUMBER`		Length of the view text
`TEXT`	`LONG`		View text. The `BEQUEATH` clause will not appear as part of the `TEXT` column in this view.
`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(128)`		Owner of the type of the view if the view is an typed view
`VIEW_TYPE`	`VARCHAR2(128)`		Type of the view if the view is a typed view
`SUPERVIEW_NAME`	`VARCHAR2(128)`		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(128)`		Name of the application edition where the object is defined
`CONTAINER_DATA`	`VARCHAR2(1)`		Indicates whether the view contains container-specific data. Possible values: `Y` if the view was created with the `CONTAINER_DATA` clause `N` otherwise
`BEQUEATH`	`VARCHAR2(12)`		Possible values: `CURRENT_USER`: When the view is a `BEQUEATH CURRENT_USER` view `DEFINER`: When the view is a `BEQUEATH DEFINER` view For more information about the syntax and semantics of the `BEQUEATH` clause in the SQL `CREATE VIEW` statement, see Oracle Database SQL Language Reference.