"B.-" <beby.akselrad@gmail.com> schreef in bericht
> Hi! I need to spool the result of a select 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!

set ECHO off

Met vriendelijke groeten

Roelof Schierbeek; DBA