Re: Need help with this SQL-Script

TEXT is a LONG. Use set command in SQL*Plus like so :

SET LONG 20000 Default is 2000 and this is why you only get first 2000 characters.

Regards,

Marc Mazerolle
InforMaze Technologies

MikeG wrote:

> Hi all,
>
> I try to select all SQL-Scripts used to create a view with following
> statement
>
> select owner, text from all_views there owner='MISDBA'
>
> The problem is that the result set for each row of text column is very long,
> so that I can't see the whole result, because it end's by 2000 bytes.
>
> Does anyone knows a possibiliy to spool the whole result set ???
>
> Thanx
>
> Mike
Received on Fri Apr 23 1999 - 18:56:54 CEST