v$ Performance views

DBA_VIEWS

Description of all views in the database

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

Related Commands:

 DBA_UPDATABLE_COLUMNS    ALL_UPDATABLE_COLUMNS USER_UPDATABLE_COLUMNS




Back to the Top

Simon Sheppard
SS64.com