wmsys.wm_concat

--链接字段,它的作用是以','链接字符
SELECT 'T_DRP_ZD_DHCYD' BM,
       '调货-调出方认定' YWM,
       COUNT(*) JLS,
       WMSYS.WM_CONCAT(DHCYDBH) DJH,
       DCMDID WLDWXXID
  FROM T_DRP_ZD_DHCYD A
 WHERE STATE = '未确认'
   AND DELFLAG = 0
 GROUP BY DCMDID
;

SELECT * FROM t_drp_xs_posmx;

SELECT POSID,wmsys.wm_concat(wlzhid),SUM(ysje) ysje FROM t_drp_xs_posmx GROUP BY posid;

SELECT POSID,wmsys.wm_concat(wlzhid) FROM t_drp_xs_posmx GROUP BY posid;

SELECT * FROM t_drp_xs_posmx WHERE posid='001c8f2fb0524da8a5b07761c24af456';

SELECT wmsys.wm_concat(A.KWXM) XMBH FROM (
 SELECT DISTINCT A.ZCKWBH,A.Xmbh,'库位'||A.Zckwbh||',箱码'||A.Xmbh||'.' KWXM
 FROM t_erp_kc_cpzcdmx_pda A
 LEFT JOIN t_erp_kc_cpzcdmx_pda B ON 1=1 AND A.Zckwbh=B.Zckwbh AND A.Xmbh=B.Xmbh AND A.Cpzcdmxid<>B.Cpzcdmxid
 WHERE B.Cpzcdid='b3a9ba46a5284eb882034fc6b529c7e2' AND NVL(A.Wcbj,0)=0
 ) A