title: concatenate CLOB data in oracle
body: <p>I need to concatenate various CLOB data into a single CLOB field.</p>
  
  <p>I have a database with various rows, each containing a few char fields (BATCH_ID for example), and a CLOB (BATCH_BODY). I am unsure as to how to concatenate the CLOBs in order to make everything a single row. </p>
  
  <p>the end goal is to group together all rows in which the BATCH_ID is the same into a single row with a single CLOB file that is made up of various BATCH_BODY's</p>