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;