with t as(

select '0102223333' as tel, '내용1  ' as bigo from dual union all

select '0102223333' as tel, '내용2  ' as bigo from dual union all

select '0103334444' as tel, '내용 a ' as bigo from dual union all

select '0103334444' as tel, '내용 b ' as bigo from dual union all

select '0109999999' as tel, '내용 가' as bigo from dual

)

select tel

     , count(1)

     , listagg(bigo, ' ') within group(order by tel) 

     , replace(wm_concat(bigo || ' '), ',', '') 

  from t

 group by tel

 감사드립니다. ~