Re: Oracle 6 to flat file

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: Sat, 10 Jul 1999 21:47:37 -0400
Message-ID: <7m8tim$q83$1@autumn.news.rcn.net>

Hi Chris,

If Oracle 6 allows you to modify the column separator do this:

    SQL> SET COLSEP ,
    SQL> SPOOL my file
    SQL> SELECT * FROM  mytable;
    SQL> SPOOL OFF

If Oracle 6 won't let you change the column separator you will have to change the select statement to look like:

SQL>SELECT column1||','||column2||','||...||','||column n

You can then use your favorite editor to do any final cleanup on the ouput file.

regards
Jerry Gitomer

Chris Fletcher wrote in message
<931608204.18959.0.nnrp-09.9e98417d_at_news.demon.co.uk>...
>Hi
> Does anybody know how I can 'dump' an Oracle 6 table into a
flat file ie
>something like CSV?
>
>Any help and or pointers would be really appreciated.
>
>
Received on Sat Jul 10 1999 - 20:47:37 CDT