DBA_VIEWS

Description of all views in the database

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

Examples (SQL*Plus):

View the definition of myview:

set LONG 1000
select TEXT from DBA_VIEWS
where owner='myowner' and view_name='myview';

1000 should be more than large enough to read most view definitions, but if you want to set this exactly look at the TEXT_LENGTH column:

select TEXT_LENGTH from DBA_VIEWS
where view_name = 'myview';

Related:
ALL_Views


 
Copyright © SS64.com 1999-2019
Some rights reserved