How do I find the select statement of an old View in Oracle?
March 25, 2010 - 8:09 am
I’m new to Oracle and working in SQL plus. There are several old views that were created before my time. How could I read the SQL statements for those VIEWs? I tried the following….
select * from all_views where name=’permit_issued’
Try out
dba_views or user_views
you will get the statement in these views
March 25th, 2010 at 1:27 pm
Try out
dba_views or user_views
you will get the statement in these views
References :