view_name varchar2(30) name of the view
text_length number y length of the view text
text long y view text
type_text_length number y length of the type clause of the object view
type_text varchar2(4000) y type clause of the object view
oid_text_length number y length of the with object oid clause of the object view
oid_text varchar2(4000) y with object oid clause of the object view
view_type_owner varchar2(30) y owner of the type of the view if the view is an object view
view_type varchar2(30) y type of the view if the view is an object view
superview_name varchar2(30) y name of the superview, if view is a subview
sql>
sql> set heading off echo off long 1000000000 pages 10000
sql> select text from dba_views where view_name ='dba_users';
select u.name, u.user#, u.password,
m.status,
decode(u.astatus, 4, u.ltime,
5, u.ltime,
6, u.ltime,
8, u.ltime,
9, u.ltime,
10, u.ltime, to_date(null)),
decode(u.astatus,
1, u.exptime,
2, u.exptime,
5, u.exptime,
