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