Oracle中如何将逗号分隔的代码字段批量转换为名称列表

czjg 字段值：'01,03,05'

select 
    pkid,
    (
        select 
            listagg(b.mc, ',') within group (order by b.dm)
        from 
            zhxg_xtgl_dmk_cl b
        where 
            b.dmbz = 'xlzx_zdgzxs_czjg'
            and (',' || t.czjg || ',') like '%,' || b.dm || ',%'
    ) as czjgmc
from 
    shxd_xlzx_zdgz_gzsf t;