Oracle View Question

[BRL123]

Is there an Oracle command to retreive the code used to create a view ?
I am using Oracle 9i.
Thanks very much.

 

[SantaMufasa]

select text from user_views
where view_name ='<UPPER-case name of VIEW>';

You can replace "user_views" (yours) with "all_views" (yours and others to whom you have GRANTed privileges) or "dba_views" (all views in the database). You must have DBA or specially granted privileges to access DBA_VIEWS.


Let us know if this resolves your need.


Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]