oracle wmsys.wm_concat() 多行传为一行

前提：支持10g或以上版本

SELECT DISTINCT B21HPLUNUM,replace(wm_concat(to_char(M132HGLCHIDSC)),',','/') AS M132HGLCHIDSC,
            replace(wm_concat(to_char(M132HGLDSC)),',','/') AS M132HGLDSC
FROM ZTB21H,ZTM132
WHERE B21HHGLCOD = M132HGLCOD AND
            B21HMKTCOD = 'HK' AND
            B21HPLUNUM = '0S20BNBBAC1C17' AND
            M132STS = '010'
 GROUP by B21HPLUNUM