WITH TABLE1 AS ( SELECT '01' AS COLUMN1 FROM dual UNION ALL SELECT '03' AS COLUMN1 FROM dual UNION ALL SELECT '05' AS COLUMN1 FROM dual UNION ALL SELECT '08' AS COLUMN1 FROM dual ) SELECT SUBSTR(REPLACE(XMLAGG(XMLELEMENT("nm", ', ' || COLUMN1)).EXTRACT('//text()').GetStringVal(), ', , ', NULL), 3) FROM TABLE1;