title: Merge BLOB data in oracle
body: <p>We have a table which has blob data (uncompressed ,text in xml form).</p>
  
  <p>we cannot change the data type to clob or any other.</p>
  
  <p>i want to merge 2 rows of blob data to create a new single row.</p>
  
  <p>since it is xml simple concat will not work ,i will need to download them to unix then modify them then again insert back to same table.</p>
  
  <p>there is no limitation of blob (can be greater than 4000 characters).</p>
  
  <p>i am struggling to find a solution to download entire blob in a file.</p>