Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

XML Extract function help

1050736Oct 27 2013 — edited Nov 10 2013

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>

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 8 2013
Added on Oct 27 2013
5 comments
2,857 views