title: String split for a CLOB value and insert splitted strings after a certain position as new row
body: <p>I have a string in which there are several sentences seperated by ';'.
  I need a solution to split the string into seperate rows and insert them into another table.</p>
  
  <p>The condition to split the string should be as follows:</p>
  
  <blockquote>
    <p>The string length should accomodate atmost 699 characters and end at the nearest ';' character as that marks the end of a statement and we wont want it to end midway.</p>
  </blockquote>
  
  <p>For example:If we have a string like "abcdefg;thjiksfg;a;" 
  and we want our string length to be atmost 12chars 
  then the resulting rows after split and processing should have values like </p>
  
  <pre><code>row1:abcdefg; 
  row2:thjiksfg;a; 
  </code></pre>
  
  <p>Please suggest how can I do it using a pl/sql procedure.</p>
  
  <p>The current string is stored in a table as a CLOB value as it can accommodate as much as 7000/8000 characters.</p>
  
  <p>Any help regarding this is much appreciated.</p>