extract CLOB data into text file

hi
how do i extract CLOB data into flat file?

Sarov

spool testfile.txt
select clob_field from table
spool off

Hi.

Try this:

http://www.oracle-base.com/Articles/8i/ExportClob.asp

Cheers