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: View description

Re: View description

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Wed, 14 Oct 1998 12:22:48 +0100
Message-ID: <7021h0$59a$1@schbbs.mot.com>


Ok got it!. TOAD gives me the SQL.

Thanks TOAD!

--
Alan D. Mills

Alan D. Mills wrote in message <701vh7$40g$1_at_schbbs.mot.com>...
>Using V7.3.4 how can I extract the SQL statement making up a view from the
>syetem tables (or other). I cannot locate the original view creation
script
>yet need to have the SQL for it.
>
>I have looked at ALL_VIEWS but the TEXT column is LONG and so not readable.
>
>Any clues?
>
>--
>Alan D. Mills
>
>
>
>
Received on Wed Oct 14 1998 - 06:22:48 CDT

Original text of this message

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