Home » SQL & PL/SQL » SQL & PL/SQL » How to spool CLOB Column's data to file? (Oracle 10g)
How to spool CLOB Column's data to file? [message #393949] Wed, 25 March 2009 03:03 Go to next message
ora_dev_vz
Messages: 1
Registered: March 2009
Junior Member
Hi Guys,

I'm very new to this forum. I hope someone could suggest me on my question.

I'm using Oracle 10g. My requirement is, I've to spool a CLOB datatype column's data to a file. The field usually contains XML data with several lines.

Pls let me know any chance of doing this.

Thanks in advance.

- Venkat
Re: How to spool CLOB Column's data to file? [message #393982 is a reply to message #393949] Wed, 25 March 2009 04:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
spool myfile
select mycol from mytable;
spool off

Regards
Michel

[Updated on: Wed, 25 March 2009 04:59]

Report message to a moderator

Re: How to spool CLOB Column's data to file? [message #394021 is a reply to message #393949] Wed, 25 March 2009 06:49 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Use UTL_FILE to write the data out to a file on the server.
Previous Topic: & used input values
Next Topic: Date between issue
Goto Forum:
  


Current Time: Sun Dec 04 06:39:59 CST 2016

Total time taken to generate the page: 0.05767 seconds