with table1 as
(
select 001 FcaID,'卡片1' FName from dual union all
select 001 FcaID,'卡片2' FName from dual union all
select 002 FcaID,'卡片3' FName from dual union all
select 002 FcaID,'卡片4' FName from dual union all
select 002 FcaID,'卡片4' FName from dual
)
select FcaID,listagg(FName, '') within group(order by rownum),replace(to_char(wm_concat(FName)),',','') from table1 group by FcaID