DBA_VIEWS

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

Related: