Re: Export from Oracle in comma-separated format

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 CST