Re: How to export to comma delimited file from Oracle8?

[Quoted] spool the data to A file and then using sql*plus issue a command that resembles this

spool test.txt

select

rtrim(col1) ||  ',' ||  rtrim(col2) ||  ',' ||  rtrim(col3) ||  ',' ||
rtrim(col4) || ',' ||   rtrim(col5) ||  ',' ||  rtrim(col6) ||  ',' ||
rtrim(col7) || ',' ||  rtrim(col8) from table;

spool off

kgrigg_at_acxiom.com wrote:

>Hello All!
>I am wanting to export the rows from an Oracle 8 database table to a comma
>delimited file. I have been trying to use the export function in the
>Enterprise manager. But, when I do this, I get a file that looks like it
>has information on re-creating the tables, etc, along with the data with
>'squares' as a delimiter (seen while looking at the file with WordPad).
>Where can I look for info on this (a utility or commands from SQL*Plus)?
 

>I am basically wanting to dunp the data out because I am dropping the
>tables I created while learning, use the new scripts I have written to
>create proper tablespaces, tables..etc. And then re-load them from these
>dump files.
 

>Any help greatly appreciated!!
 

>Kelly
>kgrigg_at_acxiom.com
 

>ps. Please cc by mail too, our newsfeed here isn't reliable...
 

>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Tue Sep 30 1997 - 00:00:00 CEST