Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Only select data in spool-file

Only select data in spool-file

From: Kristoffel <krd_at_pandora.be>
Date: Tue, 30 Apr 2002 17:09:24 GMT
Message-ID: <3CCED027.53CBB87D@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 Received on Tue Apr 30 2002 - 12:09:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US