Hi,
I have an xml response as below having multiple elements.
I want to Extract those values in oracle say for ex ...
The value of nodes 'Y' and 'Z' for each value of 'X' .
<VNRESPONSE>
<GETRESPONSE>
<X>6152369874 </X>
<Y>8976</Y>
<Z>the number is valid</Z>
</GETRESPONSE>
<GETRESPONSE>...