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 Query a XML Column

37f36731-7735-4a0e-a981-4aed6a0ebefaSep 22 2015 — edited Sep 23 2015

Hi

I have a table which has 2 columns

1) Id      int pk

2) def    XMLTYPE

The xml stored will be of like

<?xml version="1.0"?>
<dP>
<aD>
<Id>1</Id>
<aN>Lat</aN>
</aD>

<des>
<dE>
<dn>ISB</dn>
<tn>A_DE</tn>
<dE>String</dE>
<bDO>Low</bDO>
<tdo>Admin</tdo>
</dE>

<dE>
<dn>ISB</dn>
<tn>A_DE</tn>
<dE>String</dE>
<bDO>Hig</bDO>
<tdo>adm</tdo>
<dQ>A</dQ>
</dE>

</des>

</dP>

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 21 2015
Added on Sep 22 2015
2 comments
524 views