Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to write sql query to parse xml?

newmindJul 31 2013 — edited Jul 31 2013

Hi, I am new to this parsing xml. I need to extract value from xml using sql query. Please find the sample xml file. Kindly help me.

<?xml version="1.0" encoding="UTF-8"?>

<MaterialUpdates>

  <Materials>

     <SalesOrg>

       <ID>KAR12</ID>

     </SalesOrg>

</Materials>

</MaterialUpdates>

I need to extratct ID value : /MaterialUpdates/Materials/SalesOrg/ID
This post has been answered by BCV on Jul 31 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 28 2013
Added on Jul 31 2013
17 comments
1,102 views