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
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)27885841Received on Sun Jan 26 1997 - 00:00:00 CET