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.

tjphall · Accepted Answer · 2017-03-12 22:56:20Z

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

Select the Export Data checkbox
Select Loader from the Format dropdown
Select Separate Files from the Save as dropdown
Enter the name of a directory
Click Next
Click Finish

Export Dialog

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

answered Mar 12, 2017 at 22:56

tjphall

4014 silver badges2 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Daniel Machet · Accepted Answer · 2017-03-13 12:20:08Z

0

Is the file stored in cleartext in one of the fiels i.e. not binary or something?

If so then pick the field up in your source qualifier and parse it to a flat file made up of one port e.g. file_in .

If not, could you elaborate the error you are receiving in your current job and describe how the job works?

answered Mar 13, 2017 at 12:20

Daniel Machet

6301 gold badge5 silver badges7 bronze badges

Collectives™ on Stack Overflow

How to export XML file in CLOB column using Oracle SQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related