title: Extract values from XML String in oracle
body: <p>How do you extract the value of an xml string in oracle e.g.</p>
  
  <p>XML Example</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  
  
   &lt;node&gt;
        &lt;key label="name"&gt;Test&lt;/key&gt;
        &lt;key label="lastname"&gt;Test&lt;/key&gt;
     &lt;/node&gt;
  </code></pre>
  
  <p>So far this is what I have tried to extract the values</p>
  
  <pre><code>SELECT &lt;COLUMN&gt;,  EXTRACTVALUE(xmltype(&lt;COLUMN&gt;),'/node/lastname')  AS TEST FROM &lt;TABLE&gt;;
  </code></pre>
  
  <p>But it always returns a null value.</p>