Introduction Oracle LISTAGG is invaluable for concatenating multi-row values into a single string. Yet developers often encounter the dreaded ORA-01489 error: “result of string concatenation is too long.” This occurs because LISTAGG output is bound by the VARCHAR2 limit, 4000 bytes in SQL and 32767 bytes in PL/SQL. For tables with many values or long ...