oracle 批量编码转对应名称

mac2025-07-22  6

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

最新回复(0)