Overload listagg to work with clobs

[rimblas]

Or add a new listagg_clob like the Carten's code outlines. http://sql-plsql-de.blogspot.de/2014/01/sql-listagg-mit-clob-ausgabe-kein.html

[antonellyb]

This function can also be implemented as follows: select XMLCAST(XMLAGG(XMLELEMENT(t, f_field || ',') order by f_field) AS CLOB) s_aggregate FROM t_table