title: Combine multiple clob rows into one
body: <p>I have a table which has 2 fields :</p>
  
  <p>1) <strong>id</strong> - number</p>
  
  <p>2) <strong>description</strong> - clob</p>
  
  <p>This table has multiple rows for one particular id. I want to create one other table using this table which combine the <code>clob</code> rows into one for a particular id. I am trying to use below sql to combine the rows -</p>
  
  <pre><code>    SELECT id,
          rtrim(xmlagg(xmlelement(e,
                  description,
                 CHR (10) || CHR (10) ).extract('//text()')
   order by rowid).GetClobVal(),chr(10)||chr(10))
                 description2
         FROM table a
     GROUP BY id
  </code></pre>
  
  <p>But this is giving me <code>ORA-22813</code> error. Is there any workaround to solve this?</p>
  
  <blockquote>
    <p>ORA-22813: operand value exceeds system limits</p>
  </blockquote>