sqlplus_bat_sql.txt

:: START BAT FILE
sqlplus username/password@host:port/service -i @run.sql
:: END BAT FILE


--START SQL FILE run.sql
SET VERIFY OFF;
SET FEEDBACK OFF
SET TERMOUT OFF 
SET PAGESIZE 0
SET HEADING OFF
SET COLSEP ","
SET LINESIZE 32767
SET TRIMSPOOL ON

SPOOL \\path\to\results.csv

-- WRITE HEADER TO FILE
SELECT '"a"'
||','||	'"b"' as optional_header_row from dual;

Select * from dual;
SPOOL OFF

SET TERMOUT ON
prompt *********** Finished CSV ***********
SET HEADING ON
SET FEEDBACK ON
SET VERIFY ON;
--END SQL FILE run.sql