title: Extract XML in a Oracle Database Table Column
body: <p>I have a table 'Users' with column 'Values' in a Oracle database which has XML data like so:</p>
  
  <pre><code>&lt;Attributes&gt;
    &lt;Map&gt;
      &lt;entry key="first" value="Linda"/&gt;
      &lt;entry key="groups" value="Manager"/&gt;
      &lt;entry key="last" value="Davis"/&gt;
      &lt;entry key="locked" value="N"/&gt;
      &lt;entry key="status" value="A"/&gt;
    &lt;/Map&gt;
  &lt;/Attributes&gt;
  </code></pre>
  
  <p>I wish to extract them like:</p>
  
  <pre><code>Attributes_Values
  =================
  first = Linda
  groups = Manager
  last = Davis
  </code></pre>
  
  <p>I tried ExtractValue function but it returns error saying 'missing right parenthesis'. My query below:</p>
  
  <pre><code>SELECT EXTRACTVALUE(Values, '/Attributes/Map/entry[@key='first']@value') "Attribute_Values" from 
  Users;
  </code></pre>