Hi,
I have a table in Oracle which contains a field having CLOB as datatype. I want to export data from that field to either XML or Text file on local drive strictly using SQL/PL-SQL.

Kindly let me know how it can be achieved.

Thanks in advance.

Regards,
Avadhoot