SQL & PL/SQL

Hi All,

<?xml version='1.0' encoding='UTF-8'?><S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/"><S:Body>
<ns2:rate xmlns:ns2="http://www.esure.com">
<result>
<a>37f97d07-7653-4444-b6bd-90e673247513</a>
<b>1.0</b>
<c>150</c>
</result></ns2:rate>
</S:Body>
</S:Envelope>

How to extract the values of the xml tags a,b,c from the above xml in oracle?

Thanks,
Vivekan

Edited by: BluShadow on 03-Sep-2012 11:06
added {noformat}

{noformat} tags so the XML is readable properly.  Please read: {message:id=9360002} and learn to do this yourself in future.