title: Select xml element value in Oracle
body: <p>I am trying to extract a value from an xml element, located in an XMLTYPE column in an Oracle Table. The xml element which I am trying to extract have a parent for which a namespace is defined. 
  The xml looks something like:</p>
  
  <pre><code>&lt;a&gt;
    &lt;b xmlns="urn:www.someSite.com/myModel"&gt;
      &lt;c&gt;my value&lt;/c&gt;
    &lt;/b&gt;
  &lt;/a&gt;
  </code></pre>
  
  <p>If I want to extract the content of the "a" element, its context is correctly returned:</p>
  
  <pre><code>SELECT Extract(myColumn, '/a') FROM myTable;
  </code></pre>
  
  <p>But for returning the content of the "c" element I didn't succeed to find any version to work. The following instructions does not work:</p>
  
  <pre><code>SELECT Extract(myColumn, '/a/b/c') FROM myTable;
  
  SELECT Extract(myColumn, '/a/b/c', 'xmlns="urn:www.someSite.com/myModel"') FROM myTable;
  
  SELECT Extract(myColumn, '/a/b/c', 'urn:www.someSite.com/myModel') FROM myTable;
  </code></pre>
  
  <p>Can anybody help me, with the extract statement that would work in this case?</p>