v$ Performance views

ALL_VIEWS

Description of views accessible to the user

Columns
   ___________________________
 
   TYPE_TEXT
      Type clause of the object view
   VIEW_TYPE
      Type of the view if the view is an object view
   VIEW_TYPE_OWNER
      Owner of the type of the view if the view is an object view
   OWNER
      Owner of the view
   OID_TEXT_LENGTH
      Length of the WITH OBJECT OID clause of the object view
   TYPE_TEXT_LENGTH
      Length of the type clause of the object view
   TEXT
      View text
   TEXT_LENGTH
      Length of the view text
   VIEW_NAME
      Name of the view
   OID_TEXT
      WITH OBJECT OID clause of the object view

Related Commands:

 DBA_UPDATABLE_COLUMNS    ALL_UPDATABLE_COLUMNS USER_UPDATABLE_COLUMNS




Back to the Top

Simon Sheppard
SS64.com