XML oracle functions

[bblasu]

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>
<X>6152369875 </X>
<Y>8977</Y>
<Z>the number is not valid</Z>
</GETRESPONSE>
<GETRESPONSE>
<X>6152369878 </X>
<Y>8974</Y>
<Z>the number is no longer in use</Z>
</GETRESPONSE>
</VNgetvalue>

it'll be greatful if i get smeone's help to resolve this problem..
Thanks in Advance..

[jkmyoung]

Could you show what you expect as output?

Are you sorting the x values in any way?