ALL_VIEWS

ALL_VIEWS

ALL_VIEWS describes the views accessible to the current user.

Related Views

DBA_VIEWS describes all views in the database.
USER_VIEWS describes the views 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 a 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

See Also: