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

One Response to “How do I find the select statement of an old View in Oracle?”

  1. pradip0075 Says:

    Try out

    dba_views or user_views

    you will get the statement in these views
    References :

Leave a Reply