В Оракле можно конкантенировать строки следующим способом:
select cast(wm_concat(a) as varchar2(255)) x
from (select '1' a from dual
union all
select '2' a from dual
union all
select '3' a from dual
union all
select '4' a from dual)
/
или начиная с Оракла 11
select LISTAGG(a, ', ') WITHIN GROUP (ORDER BY a) x
from (select '1' a from dual
union all
select '2' a from dual
union all
select '3' a from dual
union all
select '4' a from dual)
/
select cast(wm_concat(a) as varchar2(255)) x
from (select '1' a from dual
union all
select '2' a from dual
union all
select '3' a from dual
union all
select '4' a from dual)
/
или начиная с Оракла 11
select LISTAGG(a, ', ') WITHIN GROUP (ORDER BY a) x
from (select '1' a from dual
union all
select '2' a from dual
union all
select '3' a from dual
union all
select '4' a from dual)
/
Комментариев нет:
Отправить комментарий