Re: Only select data in spool-file

Look into

set termout off
<your query here>
set termout on

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a82950/ch1.htm#1001102

Kristoffel wrote:
>
> 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

-- 
 
 
 -----------------------------
* http://pipers.hypermart.net *
 -----------------------------