oracle查询符号分隔字段，结果再分隔显示

 select listagg(b.check_part_name,';')within group(order by b.check_part_name)
          from DIC_CHECK_PART_DICT b
         where b.check_part_code in  (SELECT REGEXP_SUBSTR(examPartCode,
                     '[^;]+',
                     1,
                     LEVEL,
                     'i') 
  FROM DUAL
CONNECT BY LEVEL <= LENGTHB(TRANSLATE(examPartCode, ';' || examPartCode, ';')) + 1)

examPartCode检查部位编码是‘1；2；3；4’  
DIC_CHECK_PART_DICT 检查部位字典
查询结果‘检查部位1，检查部位2，检查部位3，检查部位4’