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
Tim... OCP DBA 7.3, 8, 8i, 9i, 10g, 11g OCA PL/SQL Developer Oracle ACE Director My website: oracle-base.com My blog: oracle-base.com/blog
Forum Rules