Re: Export to CSV using SQL Plus

From: Mark Gumbs <mgumbs_at_hotmail.com>
Date: Tue, 28 Sep 1999 08:54:31 +0100
Message-ID: <37f07198.0@145.227.194.253>

Also in sqlplus

set trimspool on        -- Removes white space at the end of each record
set pagesize 1000      -- Page long enough so you don't get page breaks

set heading off

Mark

LKR <tunnel_at_hananet.net> wrote in message news:7spdv5$ktb$1_at_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 Tue Sep 28 1999 - 02:54:31 CDT