Oracle exporting comma separated values (csv)

[luvcal]

Is there any way to export data in a comma separated format?

 

[THoey]

Try:

SELECT MyField1 || "," || MyField2
FROM MyTable; Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[luvcal]

Thanks for the reply. What I really need is a way to export to a file (*.csv) in the comma separated format. I don't know if the EXPORT utility has this functionality or if there is another tool that is relevent.

 

[THoey]

Maybe I am missing something completely. If you do the following, you will have a file in the comma separated format:

SET ECHO OFF;
SET HEAD OFF;
SET FEEDBACK OFF;
SET PAGES 9999
SET LINES 999; -- Make this as wide as your data is
SPOOL C:\MyDir\Data.CSV

SELECT MyField1 || "," || MyField2
FROM MyTable;

SPOOL OFF
SET LINES 80;
SET PAGES 50;
SET ECHO ON;
SET HEAD ON;
SET FEEDBACK ON;

If you are asking if there is a way to do this for every table in a schema through the EXPORT utility, I have never heard of one... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...