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(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