title: Oracle BLOB to base64 CLOB
body: <p>Can I convert an oracle BLOB to Base64 CLOB in One go?</p>
  
  <p>like:</p>
  
  <pre><code>CREATE TABLE test
  (
  image BLOB,
  imageBase64 CLOB
  );
  
  INSERT INTO test(image)
  VALUES (LOAD_FILE('/full/path/to/new/image.jpg'));
  
  UPDATE test SET imageBase64 = UTL_ENCODE.base64_encode(image);
  
  commit;
  </code></pre>
  
  <p>I know I can add functions/Stored proc to do the work. Performance aspect is very important,so I am asking if there is a way to overcome the 32K limitation by directly pushing the data into a CLOB.</p>