How to export XML file in CLOB column using Oracle SQL

Question

I have an XML file in a CLOB column, which is present in an Oracle table. I would like to export the XML file into LINUX landing directory which will be done through Informatica. Can you help me out in how to do this. Please share your thoughts.Thank you.

Answer 1

Use SQL Developer ( I used version 3.2.20.09 )

http:/WWW.Oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

Select Export from the right hand context menu

Context Menu

1. Select the Export Data checkbox
2. Select Loader from the Format dropdown
3. Select Separate Files from the Save as dropdown
4. Enter the name of a directory
5. Click Next
6. Click Finish

Export Dialog

It exports the data to separate files but at least it's in clear text.