title: How to fetch data from xml?
body: <p>How can I fetch the data out of the query? I need the tags "Result", "ApprovalCode" and "id" from the body:</p>
  
  <pre><code>&lt;ns28:response xmlns:ns2="xx" xmlns:ns40="yy" Result="Approved"ApprovalCode="529827"&gt;&lt;ns28:Specific&gt;&lt;ns14:CardVsdc Id="3"/&gt;&lt;/ns28:Specific&gt;
  </code></pre>
  
  <pre><code>    select Id
        into v_RiskLevel
        from xmltable('/response' passing g_xmlResult columns 
                      Id varchar2(50) path '@ApprovalCode');
  </code></pre>