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!

query to get XML path

3802575Oct 16 2018 — edited Oct 16 2018

Hi,

I have one XML file. Based on the XML file I am trying to get

IsGroup list for the column value objName and number element values. So have written a query as below.There are more number of IsGroup elements.
But as its a big file posted here only few elements.
removed the XML file data.

select x.*
    from xml_dataThanks

Kris

This post has been answered by Jason_(A_Non) on Oct 16 2018
Jump to Answer
Comments
Post Details
Added on Oct 16 2018
1 comment
1,133 views