ID（码值Value）拼接串转换成Name（码值Label）拼接串

码值转换：
SELECT
RESULTSFORMS,
(
SELECT
wm_concat(a.CODELABEL)
FROM
FW_CODELIST a
WHERE
INSTR(( SELECT ‘,’ || TO_CHAR( wm_concat( RESULTSFORMS ))|| ‘,’ FROM XM_PROJECTAPPLY WHERE projectapplyID = t1.projectapplyID ), ‘,’ || a.CODEVALUE || ‘,’ )>0
AND a.CODETYPE = ‘KYXT_YQCGXSM’
) companyName
FROM
XM_PROJECTAPPLY t1

或者：
SELECT
employeeIDs,
(
SELECT
wm_concat(a.employeeName)
FROM
FW_EMPLOYEE a
WHERE
INSTR(( SELECT ‘,’ || TO_CHAR( wm_concat( employeeIDs ))|| ‘,’ FROM XM_PROJECT WHERE projectID = t1.projectID ), ‘,’ || a.EMPLOYEEID || ‘,’ )>0
) employeeNames
FROM
XM_PROJECT t1