Re: Export from Oracle in comma-separated format
From: S. Johnson <scjonson_at_fyiowa.infi.net>
Date: 1997/01/23
Message-ID: <32E8556B.1128_at_fyiowa.infi.net>#1/1
Date: 1997/01/23
Message-ID: <32E8556B.1128_at_fyiowa.infi.net>#1/1
BoB Pierce wrote:
>
> Is there an easy way to dump an Oracle table in comma-separated format?
> I wrote a simple SQL report, changing the column separator to ',' but
> all the columns are padded with spaces. I just want
> value1,value2,value3 not value1 ,value2 , etc.
>
> Every other DB I've ever seen spits out CSV at the touch of a button.
> Surely I'm missing something here.
>
> Thanks,
>
> Bob Pierce
You're going to have to write a SQL statement concatenating the columns
together.
SELECT column_a || ',' || column_b || ',' || column_c FROM table;
Steve J. Received on Thu Jan 23 1997 - 00:00:00 CET