This content has been marked as final. Show 4 replies
another method found :
select text from dba_views where owner='username' and view_name='viewname';
Actually they are more or less same. ALL_VIEWS & DBA_VIEWS.
There's another USER_VIEWS. This is bit different coz this only shows for current Schema.
These are all views provided by Oracle and are in Data Dictionary.
This's 'll give you a lot of information.
select * from DICTIONARY;