Re: Column Headings using sqlplus script not working
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Wed, 11 Jan 2012 21:07:43 +0100
Message-ID: <4f0dec0f$0$5057$ba620e4c_at_news.skynet.be>
Roger wrote:
> 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
Date: Wed, 11 Jan 2012 21:07:43 +0100
Message-ID: <4f0dec0f$0$5057$ba620e4c_at_news.skynet.be>
Roger wrote:
> 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
A question: do you expect csv output? Received on Wed Jan 11 2012 - 14:07:43 CST