Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: View description
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