extends listagg beyond its varchar2 limits
@@listagg_clob_t_ts.sql
@@listagg_clob_t_tb.sql
@@listagg_clob.sql
SQL> select listagg_clob(owner)
2 from dba_objects
3 where rownum <= 10;
LISTAGG_CLOB(OWNER)
-----------------------------------------------
SYS,SYS,SYS,SYS,SYS,SYS,SYS,SYS,SYS,SYS
1 row selected.
This software comes WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
Acknowledgements to the ground laying work by Anton Scheffer, via https://technology.amis.nl/2015/03/13/using-an-aggregation-function-to-query-a-json-string-straight-from-sql/