Re: Export to CSV using SQL Plus

From: LKR <tunnel_at_hananet.net>
Date: Tue, 28 Sep 1999 12:53:40 +0900
Message-ID: <7spdv5$ktb$1@news.kren.nm.kr>

Tim Singline <Tim.Singline_at_launceston.tas.gov.au>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦ news:37f03990_at_derwent.nt.tas.gov.au¿¡ °Ô½ÃÇÏ¿´½À´Ï´Ù.
> I need to create an ASCII CSV export file from an Oracle 7 database to
> import into another system.
>
> I can get the appropriate header row and the data rows but I do not want
the
> extra spaces between records and at the end of each row (up to LINESIZE).
>
> Can anyone help eliminate these unwanted space characters?
>
>

Like this

SQL> spool temp
SQL> select c1||','||c2||','||c3

2 > from table1;
SQL> SPOOL OFF Now you can get temp.lst file. edit this file ... Received on Mon Sep 27 1999 - 22:53:40 CDT