Re: Export from Oracle in comma-separated format

From: Lun Wing San (Oracle) <"Lun>
Date: 1997/01/26
Message-ID: <32EBF15C.3E9B_at_qrcsun.qrc.org>#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.

  You can use ltrim or rtrim to trim the spaces.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841
Received on Sun Jan 26 1997 - 00:00:00 CET

Original text of this message