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

This is easy. I do it all the time to import data into Excel. From the UNIX command line (or within a shell script) enter the following commands

sqlplus -s userid/password <<EOT!!! >outfile select cola, ',', colb, ',', colc, from any_table; EOT!!! The above will give you the values from cola, colb and colc delimited by commas. Also, there is an sqlplus SET command which sets the character which delimits values returned by a select statement (the default is space). Received on Tue Sep 30 1997 - 00:00:00 CEST