I have below xml in oracle table, how to extract partial address data "10 Otterburn Gardens, ISLEWORTH, Middlesex TW4 5JJ" using sql
<?xml version="1.0"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<qas:QASearchResult xmlns:qas="http://www.qas.com/web-2009-08" VerifyLevel="None">
<qas:QAPicklist AutoFormatSafe="true">
<qas:FullPicklistMoniker>0_MGBRFQbdBwAAAAABAQEAAQAAAADfKULSACEYAgAAAAAAMTYAAP..ZAAAAAD.....AAAAAAAAAAA-</qas:FullPicklistMoniker>
<qas:PicklistEntry FullAddress="true">
<qas:Moniker>0XOGBRFQbdBwAAAAABAwEAAAAA3ylC0gAhGAIAAAAAADE2AAD..2QAAAAA.....wAAAAAAAAAAADE2IE90dGVyYnVybiBHYXJkZW5zLCBUVzcgNUpKAA--</qas:Moniker>
<qas:PartialAddress>10 Otterburn Gardens, ISLEWORTH, Middlesex TW4 5JJ</qas:PartialAddress>
<qas:Picklist>16 Otterburn Gardens, ISLEWORTH, Middlesex</qas:Picklist>
<qas:Postcode>TW7 5JJ</qas:Postcode>
<qas:Score>100</qas:Score>
</qas:PicklistEntry>
<qas:Prompt>Enter selection</qas:Prompt>
<qas:Total>1</qas:Total>
</qas:QAPicklist>
</qas:QASearchResult>
</soap:Body>
</soap:Envelope>