Srini's Point of View

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 -

?View Code SQLset 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
http://kpanchan.blogspot.com/2007/05/extract-csv-file-format-in-oracle-sql.html
http://www.oracle-base.com/articles/9i/GeneratingCSVFiles.php
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:68212348056

Nice article on oracle DATE and TIMESTAMP’s. Good place to go for quick reference. Just go either here or here to read in detail.