Re: Converting oracle table's data into csv on client computer

On 22 Jul 2005 02:15:14 -0700, "nirav" <shivam71_at_gmail.com> wrote:

>...
>to have a table or more than one table converted to a
>csv (comma seperated value) format.
>(Oracle 9i on solaris).
>...

Assuming the delimiter is a comma, I use

        set colsep ,

then spool

        SELECT * ... and then remove the spaces in the spoolfile around the commas with the Unix command

        sed "s/ *, */g" spoolfile > file2

Jaap. Received on Sat Jul 23 2005 - 15:26:44 CDT