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
Selva
Messages: 15
Registered: June 2001
Junior Member
hi can any body solve my problem?

please see above....

selva
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
Member
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: Question on index
Next Topic: Accessing Database of Oracle using thin driver of JDBC
Goto Forum:
  


Current Time: Thu Mar 28 09:56:34 CDT 2024