如何处理字典表映射的字段中有逗号

SELECT REGEXP_SUBSTR ('XSHG,XSHE', '[^,]+', 1,rownum) AS m_type
 FROM dual
 CONNECT BY ROWNUM <=
LENGTH ('XSHG,XSHE') - LENGTH (REPLACE ('XSHG,XSHE', ',', ''))+1

select * from ( SELECT REGEXP_SUBSTR ('XSHG,XSHE', '[^,]+', 1,rownum) AS m_type
 FROM dual
 CONNECT BY ROWNUM <=
LENGTH ('XSHG,XSHE') - LENGTH (REPLACE ('XSHG,XSHE', ',', ''))+1) T
left join (select T.KEY,T.VALUE from dict t) D
ON D.KEY=T.m_type;

select wm_concat(d.value) from ( SELECT REGEXP_SUBSTR ('XSHG,XSHE', '[^,]+', 1,rownum) AS m_type
 FROM dual
 CONNECT BY ROWNUM <=
LENGTH ('XSHG,XSHE') - LENGTH (REPLACE ('XSHG,XSHE', ',', ''))+1) T
left join (select T.KEY,T.VALUE from dict t) D
ON D.KEY=T.m_type;

CREATE OR REPLACE FUNCTION GET_FRO_MARKETS(MARKETS VARCHAR2)
  RETURN VARCHAR2 IS
  MARKETS_VALUE VARCHAR(50);
BEGIN
  SELECT WM_CONCAT(D.VALUE) AS M_TYPE
  INTO MARKETS_VALUE
  FROM (SELECT REGEXP_SUBSTR(MARKETS, '[^,]+', 1, ROWNUM) AS M_TYPE
        FROM DUAL
        CONNECT BY ROWNUM <=
                   LENGTH(MARKETS) -
                   LENGTH(REPLACE(MARKETS, ',', '')) + 1) T
  LEFT JOIN (SELECT T.KEY,
                    T.VALUE
             FROM DICT T) D
  ON D.KEY = T.M_TYPE;
  RETURN MARKETS_VALUE;
END;

SELECT T.ACCID,
       GET_FRO_MARKETS(T.MARKETS) AS MARKETS
FROM TEXT_FOR_DICT T;