title: Update xml tag in a CLOB column in Oracle
body: <p>I have this xml value in a CLOB column in Oracle 11g:</p>
  
  <pre><code>&lt;Energy xmlns="http://euroconsumers.org/notifications/2009/01/notification"&gt;    
      &lt;Gender&gt;M&lt;/Gender&gt;
      &lt;FirstName&gt;MAR&lt;/FirstName&gt;
      &lt;Name&gt;VAN HALL&lt;/Name&gt;
      &lt;Email/&gt;&lt;Telephone&gt;000000000&lt;/Telephone&gt;
      &lt;InsertDate&gt;2013-10-09&lt;/InsertDate&gt;
  &lt;/Energy&gt;
  </code></pre>
  
  <p>I want to update the value of InserDate for several rows.</p>
  
  <p>I was using next below sql command:</p>
  
  <pre><code>update tmp_tab_noemail_test p1 
  set p1.sce_msg = updatexml(xmltype(p1.sce_msg),
                   '//Energy/InsertDate/text()','Not Valid').getClobVal()
  </code></pre>
  
  <p>But is not working.</p>
  
  <p>Do you have some ideas to modify only the values of the xml tag of InsertDate?</p>
  
  <p>Thanks in advances</p>