The below code WAS working fine, but since we have more data, I'm now receiving an ORA-01480 error. I've seen posts on here where using XMLAGG allows for more larger strings, but I can't seem to convert the below statement to use to use it. Can someone assist?
RTRIM(
REGEXP_REPLACE((LISTAGG(TO_CHAR(table.column),';') WITHIN GROUP (ORDER BY table.column)
OVER (PARTITION by table.column, table.column)),
'([^;]*)(;\1)+($|;)',
'\1\3'),
';') AS ZZZZZ