Re: SqlPlus report keeps outputting the SQL statement
From: T. Schwickert <schwickert_at_yahoo.com>
Date: 23 Aug 2001 07:57:00 -0700
Message-ID: <5fcc15a8.0108230657.12a1dd3b_at_posting.google.com>
Date: 23 Aug 2001 07:57:00 -0700
Message-ID: <5fcc15a8.0108230657.12a1dd3b_at_posting.google.com>
Hi,
"news.kolumbus.fi" <Jaakko.Terhonen_at_kolumbus.fi> wrote in message news:<9m2caj$rhq$1_at_news.kolumbus.fi>...
> Steve, thank You very, very much.
>
> Did You really think that I had not done that already?
have you ?
>
>
> "Steve Long" <slong3_at_mediaone.net> kirjoitti viestissä
> news:E2Wg7.2271$L8.37481_at_typhoon.jacksonville.mediaone.net...
> > look up the SET options in the SQL*Plus manual.
> >
well he's not wrong ...
however:
set echo off
set pagesize 0
set feedback off
set termout off
spool yourfile
select ...
Hth
Thomas
Received on Thu Aug 23 2001 - 16:57:00 CEST