Re: Only select data in spool-file

"Kristoffel" <krd_at_pandora.be> wrote in message news:3CCED027.53CBB87D_at_pandora.be...
> Hi,
>
> I want only the selected data in a spool-file (I use sqlplus 8.1.7 for
> NT4).
>
> set pagesize
> set echo off
> spool xxxx
> select ..... from .... ;
> spool off
>
> But I still have the select query and the spool-msg in the spool file.
> Are there other settings that I overlook?
>
> Kristoffel
>
>

Save the code above to a file and run it with @<filename>
and you will be OK

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address