Re: Export from Oracle in comma-separated format

>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.
>

select col1||','||col2||','||...coln
from table;

Or if you need values in quotes:

select '"'||col1||'","'||col2...
from table;

-- 
=========================================================
            http://www.li.net/~gsa/index.html
This is my signature file, not part of this mail message.