set long 4000
set long 8000
...
until it's long enough
MikeG heeft geschreven in bericht <7fpihp$63f$1_at_newsread.f.de.uu.net>...
>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 - 11:36:33 CDT
