how would you wrap quotes around text columns so that commas in the data
don't get misinterpreted?

-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x14986977.[Email address protected]
Sent: 03 August 2004 11:38
To: LazyDBA Discussion
Subject: RE: Exporting data from tables into a CSV delimited file


set colsep ','

set heading off
set feedback off
set flush off
set termout off

spool emp.txt

select * from emp;

spool off


-----Original Message-----
From: Satheesh
[mailto:oracledba-ezmlmshield-x42257972.[Email address protected]
Sent: Tuesday, August 03, 2004 5:27 AM
To: LazyDBA Discussion
Subject: RE: Exporting data from tables into a CSV delimited file


What about this?,

Set colsep ','

Spool tname.csv
Select * from table;
Spool off;



Thanks and Regards,
Satheesh Babu.S



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page