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

E40402-12
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

ALL_VIEWS describes the views 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 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
EDITIONING_VIEW VARCHAR2(1)   Reserved for future use
READ_ONLY VARCHAR2(1)   Indicates whether the view is read-only (Y) or not (N)