Re: getting full sql of a view

From: TurkBear <johng_at_nospam.mm.com>
Date: Tue, 06 Apr 1999 13:59:35 GMT
Message-ID: <370a12c8.1141000@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 - 08:59:35 CDT