Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
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(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. This column returns the correct value only when the row originates from the current container. The BEQUEATH clause will not appear as part of the TEXT column in this view.
TEXT_VC VARCHAR2(4000)   View text. This column may truncate the view text. The BEQUEATH clause will not appear as part of the TEXT_VC 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 a 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
EDITIONING_VIEW VARCHAR2(1)   Reserved for future use
READ_ONLY VARCHAR2(1)   Indicates whether the view is read-only (Y) or not (N)
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.

ORIGIN_CON_ID VARCHAR2(256)   The ID of the container where the data originates. Possible values include:
  • 0: This value is used for rows in non-CDBs. This value is not used for CDBs.

  • n: This value is used for rows containing data that originate in the container with container ID n (n = 1 if the row originates in root)