Re: Need help with this SQL-Script

From: dave <cowden_at_earthlink.net>
Date: Mon, 26 Apr 1999 23:25:40 -0400
Message-ID: <7g3at2$ik0$1@holly.prod.itd.earthlink.net>

Mike:

The other idea will work, but you can use the following query to get the length you need:

select max(text_length) from all_views;

set long <whatever you got above>

then you can see all the data.

Hope that helps.
Dave

MikeG wrote in message <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 Mon Apr 26 1999 - 22:25:40 CDT