17,086
社区成员
发帖
与我相关
我的任务
分享
with t as(
select 1 id,'a' name,'hello' text from dual
union all
select 2,'a','world' from dual
union all
select 3,'a','haha' from dual
union all
select 4,'b','ccc' from dual
union all
select 5,'b','ddd' from dual
)select
name,replace(wm_concat(text),',','')
from t
group by name;
NAME REPLACE(WM_CONCAT(TEXT),',',''
---- --------------------------------------------------------------------------------
a helloworldhaha
b cccddd