sqlplus csv column headings

From: <burrell.john_at_yahoo.com>
Date: Thu, 17 Jan 2008 06:35:59 -0800 (PST)
Message-ID: <3ff8a56b-5509-49ec-8656-9a7e319961a3@d70g2000hsb.googlegroups.com>

I am
trying to generate csv file from the output of a sqlplus. 9i on unix.
Dome quite well so far.
spool wed.csv
set colsep |
set heading off
set feedback off
set linesize 4000
set trimspool on
set pagesize 0

That colsep command is really useful BTW. Anyhow know how can I get the column heads just once?

J Received on Thu Jan 17 2008 - 08:35:59 CST

Original text of this message