1 2 Previous Next 16 Replies Latest reply on Sep 11, 2012 1:52 PM by Jason_(A_Non) Go to original post
      • 15. Re: xmltype column data parsing
        i have a following requirement. I am not able to get the desired output. By using Multi namespaces I am able to get for e.g. both Account9999 in a single row in one column.
        I need to get "Account" only and need to ignore the "9999" row saw:g
        Thanks for any help.

        <?xml version="1.0" encoding="utf-8"?>
        <saw:a xmlns:saw="pqr.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlVersion="201008230" xmlns:sawx="pqr.com">
        <saw:c xsi:type="saw:d" op="and">
        <saw:c xsi:type="saw:d" op="or">
        <saw:c xsi:type="saw:f" op="in">
        <saw:c xsi:type="saw:e">Account</saw:c>
        <saw:c xsi:type="saw:g">9999</saw:c></saw:c>
        <saw:c xsi:type="saw:f" op="in">
        <saw:c xsi:type="saw:e">State</saw:c>
        <saw:c xsi:type="saw:g" default="XXXX">DC</saw:c></saw:c></saw:c>
        <saw:c xsi:type="sawx:comparison" op="equal">
        <saw:c xsi:type="saw:e">Date</saw:c>
        <saw:c xsi:type="sawx:variable" op="server">today</saw:c></saw:c>
        <saw:c xsi:type="sawx:comparison" op="notEqual">
        <saw:c xsi:type="saw:e">Product</saw:c>
        <saw:c xsi:type="xsd:string">Fruit</saw:c></saw:c></saw:c></saw:b>

        Desired Output

        • 16. Re: xmltype column data parsing
          Please don't hijack an old thread to ask your new question. Please start a new thread for your question. Also include your version of Oracle
          select * from v$version
          In this case, also include the SQL that you have started so we can make corrections to it, or rewrite it, based on what is better.
          1 2 Previous Next