title: Updating CLOB field in Oracle
body: <p>I have a table in Oracle database with field with data type <code>CLOB</code>. The name of field is <code>XMLString</code>. I am storing XML string which is 10,000 characters long for each record. I have more than 100, 000 of records in this table.</p>
  
  <p>I need to update segment of the XML string on each record at specific place. For example I need to update each record at 14th position with some string like "My New text".  This replacement text is 11 characters long. So this simply means it will replace 11 characers starting from 14th character.</p>
  
  <p>I tried to use <code>DBMS_LOB.FRAGMENT_REPLACE</code>, but it is not exactly what I wanted.</p>
  
  <p>Is there any simple command like    </p>
  
  <pre><code>Replace(XMLString, 14, ‘My New text’) 
  </code></pre>
  
  <p>so that I can do something like below?</p>
  
  <pre><code>UPDATE MYTABLE 
  SET MyClobField = Replace(MyClobField, 14, 'My New text')
  WHERE MyTableID&gt;5000
  </code></pre>
  
  <p>Any help would be appreciated.</p>