Hi! I need to spool the result of a select consult into a file, but not
the consult itself. Is there any way to do this?
My code is:

set termout off
set pagesize 0
set feedback off
set verify off
set linesize 2000
set heading off
set trimspool on


spool c:\data.dat
select 'whatever' from table1;
spool off

So in the data.dat file I get

select 'whatever' from table1;
data
data
data
data

retieved x lines

Is there any way I can get only de "data" lines?
Thanks!