DBA_VIEWS

Description of all views in the database

Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes Owner of the view
VIEW_NAME VARCHAR2 (30) Yes Name of the view
TEXT_LENGTH NUMBER

Length of the view text
TEXT LONG (0)
View text
TYPE_TEXT_LENGTH NUMBER

Length of the type clause of the object view
TYPE_TEXT VARCHAR2 (4000)
Type clause of the object view
OID_TEXT_LENGTH NUMBER

Length of the WITH OBJECT OID clause of the object view
OID_TEXT VARCHAR2 (4000)
WITH OBJECT OID clause of the object view
VIEW_TYPE_OWNER VARCHAR2 (30)
Owner of the type of the view if the view is an object view
VIEW_TYPE VARCHAR2 (30)
Type of the view if the view is an object view
SUPERVIEW_NAME VARCHAR2 (30)
Name of the superview, if view is a subview

Usage:


cursor cur_vw_source(c_name  in dba_objects.object_name%type
                   , c_owner in dba_objects.owner%type)
is select text
   from dba_views
   where view_name = c_name
   and   owner = c_owner;