oracle函数 wm_concat 与 listagg

select t.type, to_char(wm_concat(t.id||'---'||t.seq)) as id_seq, to_char(wm_concat(t.seq)) as seqs
from (
    select 'A' type, 'A001' id,  1 seq from dual union all 
    select 'A' type, 'A002' id,  2 seq from dual union all 
    select 'B' type, 'B001' id,  1 seq from dual 
) t group by t.type;

SELECT 
  T.type,
  listagg(T.id ||'---'||T.seq, ',') WITHIN GROUP(ORDER BY T .seq) id_seq,
  listagg(T.seq, ',') WITHIN GROUP(ORDER BY T .seq desc) seqs
FROM (
    select 'A' type, 'A001' id,  1 seq from dual union all 
    select 'A' type, 'A002' id,  2 seq from dual union all 
    select 'B' type, 'B001' id,  1 seq from dual 
) t 
WHERE T.type in ('A', 'B') 
GROUP BY T.type;