title: Get XML element value in Oracle DBMS_XMLDOM package
body: <p>I have XML file that's stored in the clob column of the table in DB.</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;document&gt;
    &lt;row&gt;
      &lt;organization&gt;asdklfjas;kldfj;LASKJFAS&lt;/organization&gt;
      &lt;phones&gt;sjhdfhjaghjskfg&lt;/phones&gt;
      &lt;persons&gt;hkjg&lt;/persons&gt;
    &lt;/row&gt;                                                  
  &lt;/document&gt;
  </code></pre>
  
  <p>I'm using <code>DBMS_XMLDOM</code> package for parse it.</p>
  
  <pre><code>declare
    v_clob clob;
    v_doc dbms_xmldom.domdocument;
  begin
    ...
    v_doc := dbms_xmldom.newdomdocument(v_clob);
    v_domelement := dbms_xmldom.getdocumentelement(v_doc);
    ...
  end;
  </code></pre>
  
  <p>I need simply to get value from some element, for example <code>&lt;persons&gt;</code>. How can I do it?</p>