title: How to write oracle insert script with one field as CLOB?
body: <p>I want to create an insert script which will be used only to insert one record into one table.</p>
  
  <p>It has 5 columns and one of them is of type CLOB.</p>
  
  <p>Whenever I try, it says can not insert string is so long . larger than 4000.</p>
  
  <p>I need an insert statement with clob as one field.</p>
  
  <pre><code>INSERT INTO tbltablename 
              (id, 
               NAME, 
               description, 
               accountnumber, 
               fathername) 
  VALUES      (1, 
               N'Name', 
               clob'some very long string here, greater than 4000 characters', 
               23, 
               'John') ;
  </code></pre>