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

最新推荐文章于 2023-05-19 14:05:12 发布

胡晔可可

最新推荐文章于 2023-05-19 14:05:12 发布

阅读量198

点赞数

分类专栏： java 文章标签： sql 数据库

本文链接：https://blog.csdn.net/huyekeke1989/article/details/126262546

版权

java 专栏收录该内容

24 篇文章 0 订阅

订阅专栏

码值转换：
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