Возможны следующие следующие варианты решения:
1. С помощью xmlagg:
1. С помощью xmlagg:
with t as ( select 1 as id, 'aaa' as str from dual union all select 2 as id, 'bbb' as str from dual union all select 3 as id, 'ccc' as str from dual ) SELECT xmlagg(xmlelement("node", t.str, ', ')).extract('//text()').getStringVal() as result1 , rtrim(xmlagg(xmlelement("node", t.str, ', ').extract('//text()')),', ') as result2 FROM t; RESULT1 RESULT2 ------------------ ------------------ aaa, bbb, ccc, aaa, bbb, ccc