This discussion is archived
1 Reply Latest reply: Nov 2, 2012 11:13 AM by Jason_(A_Non) RSS

How to get number of occurences of a particular node in a xml clob

SUBHASISH_319401 Newbie
Currently Being Moderated
Hi All,

How can I get number of occurences of a particular node in a xml clob. Is there any sql function on xmlType?

Supose i want the number of occurence of "deliveryaddress/addressline1" in the below xml tags.

<order>
<orderno>ABCDE</orderno>
<productno>11111</productno>
<deliveryaddress>
<addressline1>gggggg</addressline1>
<postcode>gggggg</postcode>
</deliveryaddress>
<deliveryaddress>
<addressline1>hhhhh</addressline1>
<postcode>hhhhh</postcode>
</deliveryaddress>
</order>




Thanks and regards,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points