Column Headings using sqlplus script not working

From: Roger <rfrench5_at_gmail.com>
Date: Wed, 11 Jan 2012 08:59:43 -0800 (PST)
Message-ID: <cc1133b1-ac9d-40b3-a8da-dfdbae403e3c_at_a8g2000vba.googlegroups.com>



Hello,
Stupid question here. I'm having brain freeze. I have a real simple script that I run in sqlplus

set colsep ','
set HEAD ON
set pagesize 0
set trimspool on
set linesize 1000
set feedback off
spool paymastr3.csv
select * from paymastr
  where check_date='30-Dec-11';
spool off

I can execute the sql script and the csv file is created, but NO column headings are appearing. I have tried everything, but still no headings. I've tried set HEADINGS ON but that doesn't work

This is Oracle 9i

Any ideas?

Thanks,
-R Received on Wed Jan 11 2012 - 10:59:43 CST

Original text of this message