Home » Server Options » Text & interMedia » how to spool csv?
how to spool csv? [message #76153] Wed, 08 December 2004 23:02 Go to next message
Messages: 15
Registered: June 2001
Junior Member
hi can any body solve my problem?

please see above....

Re: how to spool csv? [message #76160 is a reply to message #76153] Fri, 10 December 2004 11:58 Go to previous message
Just John
Messages: 69
Registered: November 2004
Can't you just

spool text.csv
SELECT column1||','||column2||','||column3
from table;
spool off

you can perform similar tasks with UTL_FILE and TEXT_IO.

Previous Topic: How to extract datas from table to csv
Next Topic: BInd problem while loading to oracle
Goto Forum:

Current Time: Wed Aug 23 16:34:05 CDT 2017

Total time taken to generate the page: 0.02457 seconds