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

Home -> Community -> Mailing Lists -> Oracle-L -> removing SQL script from output

removing SQL script from output

From: David cheyne <david.cheyne_at_gmail.com>
Date: Wed, 24 Aug 2005 11:16:48 +0100
Message-ID: <13efe57b05082403165db96c71@mail.gmail.com>


Okay, idiot level question I think.
 I have a script to run on windows as a batchfile:  BATCHFILE:
 sqlplus <C:\bin\script_imp.sql
  SCRIPT
script_imp.sql
 username/password_at_instance
set pagesize 0
set linesize 500
set head off
set verify off
set termout off
set feedback off
spool C:\bin\an_outputfile_imp.csv
 <SQL statement>
 spool off;
  The problem is that the SQL is always shown at the top of the file!!  Thanks!   

-- 
~~~~~~~~~~~~~~~~~~~~~~~
David Cheyne
BA(hons.)

Oracle Database Administrator

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 24 2005 - 05:18:46 CDT

Original text of this message

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