oracle 批量编码转对应名称

SELECT (select to_char(wm_concat(INDICATORS.NAME))
            from JG_YSHJ_INDICATORS INDICATORS
            where INDICATORS.DELETE_FLAG =0 and INDICATORS.STATE = 0
            and instr(YSHJCASE.BL_INDICATORS,INDICATORS.ID) > 0 ) BL_INDICATORS,
            ID,TITLE,source,AREA_CODE,AREA_TXT,DESCRIBE,CREATE_UNIT,CREATE_TIME,PUBLISH_TIME
             FROM JG_YSHJ_CASE YSHJCASE WHERE id = #{id} and IS_DELETE = '0';

 

wm_concat('columnName')

instr('123,1234',columnId)>0