How to go from Oracle to CSV

Here is a trick to to create a comma delimited file from oracle. You can create a csv file simply using SQL*Plus with any sql statement. Here it is -

set feedback off  
set heading off  
set underline off  
set colsep ','  
spool /path/to/file/mysheet.csv  
select * from table  
spool off

Here are some other ways I found online

Srini's Point of View