Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

jamesgluten

Hey, i see you are facing a lot of problem due to high disk usage of your system that many times leads to lagging.Well i have the solution to your problem i found this link on internet..really a helping article http://errorcodespro.com/tiworker-exe-high-disk-usage-windows/. At begining i thought it was because of hard drive failure but i applied the solution it worked very well. You can find your solution at the given system.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 8 2013
Added on Oct 27 2013
#xml, #xquery
5 comments
2,932 views