Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL to create views needed

Re: SQL to create views needed

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 20 Nov 2003 03:14:05 GMT
Message-ID: <1kWub.651$uU2.11@news01.roc.ny> 






"Randy Harris" <randy_at_SpamFree.com> wrote in message news:VIUub.11454$P%1.10007289_at_newssvr28.news.prodigy.com...


> I've lost some scripts that I used to create some rather complex views in

> Oracle 8.1.7.  How can I query the database to recover the original SQLs

> that were used to create the views?

>

> Thank you for your help.

>

>




set long 10000



select text from user_views;



HTH


Anurag
Received on Wed Nov 19 2003 - 21:14:05 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US