oracle sql 将逗号隔开的id 转换成对应的字符

1：
select ggg.id,wm_concat(ggg.Gx_tdclbh) from (select ccc.,b.gx_tdclbh from (
select a.,
regexp_substr(GX_NO, ‘[^；]+’, 1, level) GX_NO_FEN
from WZX_HGJC a
connect by level <= regexp_count(GX_NO, ‘；’) + 1
and id = prior id
and prior dbms_random.value is not null
) ccc left join wzx_gx_gx b on ccc.GX_NO_FEN=b.gx_tdclbh_old order by ccc.id asc) ggg group by ggg.id;

2：select ggg.id,wm_concat(ggg.GX_TDCLBH) from (select b.gx_tdclbh,bbb.id from (select * from WZX_HGJC t left join wzx_gx_gx b on instr(t.GX_NO,b.gx_tdclbh_old)>0 ) bbb
left join wzx_gx_gx b on bbb.gx_tdclbh_old=b.gx_tdclbh_old order by bbb.ID asc) ggg group by ggg.id;

3：
select ggg.SUM_ID,wm_concat(ggg.GX_TDCLBH) from (select b.gx_tdclbh,bbb.SUM_ID,bbb.numIndex from (select t.*, instr(t.GX_NO,b.gx_tdclbh_old) as numIndex,b.gx_tdclbh_old from WZX_JYHZ t left join wzx_gx_gx b on instr(t.GX_NO,b.gx_tdclbh_old)>0 ) bbb
left join wzx_gx_gx b on bbb.gx_tdclbh_old=b.gx_tdclbh_old order by bbb.SUM_ID asc,numIndex asc) ggg group by ggg.SUM_ID ;