Skip to Main Content
  • Questions
  • What is the most performant way to do large string (> 32K) aggregation

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, fdsafa.

Asked: March 13, 2016 - 7:31 am UTC

Last updated: March 13, 2016 - 9:29 am UTC

Version: 12.1.0.2

Viewed 10K+ times! This question is

You Asked

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.






and Connor said...


Is this answer out of date? If it is, please let us know via a Comment

More to Explore

CLOB/BLOB/etc

Complete documentation on Securefiles and Large Objects here