Re: Column Headings using sqlplus script not working

in this script use to_date('30-Dec-11','DD-MON-RR') in condition also set pagesize 50 as usual

On Wednesday, 11 January 2012 22:29:43 UTC+5:30, 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
Received on Sat Dec 07 2013 - 10:40:45 CET