Re: getting full sql of a view

From: Ross Cuthbertson <cuthberr_at_unisys.com>
Date: Wed, 7 Apr 1999 11:02:52 +1000
Message-ID: <7eeao6$fhi$1@mail.pl.unisys.com>

Thanks for that my brain went dead.

Regards
Ross

TurkBear wrote in message <370a12c8.1141000_at_news.dot.state.mn.us>...
>In SqlPlus use
>set long = 1000 ( or some other large number )..
>By defau;t, SqlPlus returns only the first 80 chars of a field of type LONG
>
>Good Luck,
>John Greco
>Oracle DBA/Application Developer
>MnDOT Human Resource Office
>
>
>"Ross Cuthbertson" <cuthberr_at_unisys.com> wrote:
>
>>can someone remind me of how to get the full text of view. DBA_VIEWS only
>>gies you the first 80 odd characters.
>>
>>Many thanks for any help
>>
>>Regards
>>Ross Cuthbertson
>>
>>
>
>To reply please remove the 'nospam' part of the address
Received on Tue Apr 06 1999 - 20:02:52 CDT