Hi

We have system (Oracle 12.1.0.2), where there is need to aggregate strings to bigger entities. Total sizes of aggregated strings are > 32K so we cannot use listagg/stragg functions.

We have used clobagg function (gotten from somewhere in the net) and for performance reasons xmlagg function in a style of:
xmlagg(xmlelement(f,rowdata,chr(10)).extract('//text()') order by rowdata).GetClobVal(),',')

But is there any faster way to do this ?

I very much appreciate the good work You all are doing.