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
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
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.
Sup
It’s a great day today at work and I have time to surf the internet. I was looking on concrete and construction information and Googled your blog. I enjoy it, it’s cute and I also love the way you write your articles.
Definitely it’s a pleasant surprise and I’m glad Google pointed towards your direction.
Goodbye!
[Reply]