Re: View description

From: <esiyuri_at_my-dejanews.com>
Date: Thu, 15 Oct 1998 16:23:45 GMT
Message-ID: <7057ih$5ap$1@nnrp1.dejanews.com>

In article <701vh7$40g$1_at_schbbs.mot.com>, "Alan D. Mills" <alanmNOSPAM_at_uk.europe.mcd.mot.com> wrote:
> 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.
>

Alan,

you can look at a long column in SQLPLUS, you just have to change a setting so that it is not truncated. Try this...

SQL> set long 32000
SQL> select TEXT from ALL_VIEWS were ... (your criteria);

--
Regards
Yuri McPhedran

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 15 1998 - 11:23:45 CDT