1 Reply Latest reply: Nov 2, 2012 1:13 PM by Jason_(A_Non) RSS

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

    SUBHASISH_319401
      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,