title: Oracle blob - inserting long (over 4000 hex-digits) data in sql command
body: <p>How can I, in Oracle 11, insert large data (~100000 hex-digits) into Blob field, <strong>using sql command only</strong> (without any external data with <code>load</code> cluase or such).</p>
  
  <pre><code>update tablename set fieldname='AA';
  </code></pre>
  
  <p>Works - 1 byte;</p>
  
  <pre><code>update tablename set fieldname='AA...(4000 hex-digits)...AA';
  </code></pre>
  
  <p>Doesn't. Niether <code>Concat</code> helps; strings can't be larger than 4000 chars. Is there other way, using sql command only?</p>