Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

LISTAGG Vs XMLELEMENT

Rajneesh S-OracleFeb 3 2020 — edited Feb 4 2020

Hello All,

I  guess LISTAGG will allow 4000 bytes and XMLELEMENT will allow up to 32767 bytes (as CLOB variable).

Just curious to know if any alternative / work around if your concatenation requires more than 32767?

Thanks,

Rajneesh
This post has been answered by BluShadow on Feb 3 2020
Jump to Answer
Comments
Post Details
Added on Feb 3 2020
2 comments
604 views