SELECT 결과 ROW들 문자열로 합치기

[1]
SELECT
SUBSTR(
XMLAGG(
XMLELEMENT(COL ,',', INST_NM) ORDER BY INST_NM).EXTRACT('//text()'
).GETSTRINGVAL()
, 2) INST_NM
FROM ART_INST_REQ_CNT
GROUP BY REQ_NO;

[2]
SELECT LISTAGG(가져올컬럼, 구분자) WITHIN GROUP (ORDER BY 순서컬럼)
FROM TABLE_NM