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>
Date: Thu, 17 Jan 2008 06:35:59 -0800 (PST)
Message-ID: <3ff8a56b-5509-49ec-8656-9a7e319961a3@d70g2000hsb.googlegroups.com>
Hello,
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?
TIA
J
Received on Thu Jan 17 2008 - 08:35:59 CST