Re: Need help with this SQL-Script

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Fri, 23 Apr 1999 12:43:23 -0400
Message-ID: <7fq82u$hdi$2_at_autumn.news.rcn.net>

Hi Mike,

    Try this:

    spool <filename>
    select owner, text from all_views there owner='MISDBA';     spool off
    host <display command> <filename>

    (Of course instead of using the host command you could exit SQL*Plus)

regards

Jerry Gitomer

---

MikeG wrote in message <7fplf7$9g9$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 - 18:43:23 CEST