LISTAGG with CLOB? String aggregation exceeding 4000 characters with XMLAGG.

Uli Bethke Oracle

We all know that the Oracle LISTAGG function does not support the CLOB datatype. In my opinion this is a severe limitation of LISTAGG (and BTW also of PIVOT and UNPIVOT etc.). So what are your options? One option is to create your own user defined aggregate function. I found such an example on the Oracle forums. However, if you ...