WM_CONCAT, XmlAgg , Listagg

select wm_concat(rows1)
from(
select 'A' rows1 from dual
union
select 'B' rows1 from dual
union
select 'D' rows1 from dual
union
select 'D' rows1 from dual
)

 

order by 할라믄?

 

select listagg(rows1, ',') within group (order by rows1)
from(
select 'A' rows1 from dual
union
select 'B' rows1 from dual
union
select 'D' rows1 from dual
union
select 'D' rows1 from dual
)

 

 

오라클 10g 이상일때 사용가능한 WM_CONCAT...안될땐??

 

select substr(xmlagg (xmlelement(x,',', rows1) order by rows1).EXTRACT('//text()'),2) rowsString
from(
select 'A' rows1 from dual
union
select 'B' rows1 from dual
union
select 'C' rows1 from dual
union
select 'D' rows1 from dual
)