XML_Type Data Transfer from Oracle source to Oracle Target table

Highlighted
Four Stars

XML_Type Data Transfer from Oracle source to Oracle Target table

Hi all,

In my table have one column datatype XMLTYPE and data like this <row id='12' xml:space='pre'><c1>12</c1><c2>23</c2><c3>34</c3><c4>45</c4><c5>56</c5></row>. How can i transfer the data from Oracle to Oracle table. Actually my Output table have XMLTYPE datatype column.

 

Design:
toracleInput --> toracleoutput

Moderator

Re: XML_Type Data Transfer from Oracle source to Oracle Target table

Hello,

In your oracle source, you can use EXTRACTVALUE() EXTRACT() and so on.
like Smiley FrustratedELECT extract(xmltypetest, '/PurchaseOrder/ShippingInstructions')
FROM xmltype_test.

And for target table, tOracleOutput supports Object-->XMLType mapping.

Let us know if it is OK with you.

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.