Skip to Main Content

Database Software

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 extract from XML string when all tags are the same

jkoradbaApr 26 2010 — edited Apr 27 2010
Hi, this is my first time working with XML data. I have an XML data source where all the tags are 'string'. Below is an abbreviated example. Is there a way to do this, i.e. extract these items into table columns?

Thanks!

Julian



<?xml version="1.0" encoding="UTF-8"?>
<java version="1.5.0_12" class="java.beans.XMLDecoder">
<object class="java.util.HashMap">
<void method="put">
<string>Product[0].Account Information[0].Account State</string>
<string>NY</string>
</void>
<void method="put">
<string>Product[0].Account Information[0].Insured Information[0].Name</string>
<string>Some Name</string>
</void>
</object>
</java>
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2010
Added on Apr 26 2010
3 comments
1,873 views