SELECT
LISTAGG( TO_CHAR(CM01.ITEM_CNAME), ',')
FROM 数据库名.TEDCM01 CM01 WHERE CM01.CODESET_CODE='ppms.bp.matterType' AND '00,10' LIKE '%'||CM01.ITEM_CODE||'%'
oracle 分割 并且行转列
最新推荐文章于 2024-07-07 20:00:41 发布
SELECT
LISTAGG( TO_CHAR(CM01.ITEM_CNAME), ',')
FROM 数据库名.TEDCM01 CM01 WHERE CM01.CODESET_CODE='ppms.bp.matterType' AND '00,10' LIKE '%'||CM01.ITEM_CODE||'%'