oracle多个字典数据以逗号分隔查询

(

SELECT wm_concat(NAME) FROM FBS_TREE_DICTIONARY a WHERE a.TYPE='1000' AND a.CODE in 

(
SELECT REGEXP_SUBSTR(SPJZ, '[^,]+', 1, LEVEL, 'i') FROM DUAL 
CONNECT BY LEVEL <= LENGTH(SPJZ) - LENGTH(REGEXP_REPLACE(SPJZ, ',', '')) + 1
)

) SPJZMC。

SPJZ为要查询的字段。

字段数据SPJZ：1021,1022,1023

查询到的数据为：查询,预约,申报

FBS_TREE_DICTIONARY 为字典表