oracle 合并多行数据

WITH tab AS(
select '01' no,'ss' name, 10 jiner,'麦子' you from dual union all
select '02' no,'dd' name, 11 jiner,'萝卜' you from dual union all
select '03' no,'cc' name, 9 jiner,'大豆' you from dual union all
select '01' no,'ss' name, 10 jiner,'白菜' you from dual)
SELECT a.no, a.name, a.jiner, ltrim(MAX(sys_connect_by_path(you, ',')), ',') you
FROM (SELECT row_number() over(PARTITION BY a.no, a.name, a.jiner 
         ORDER BY a.no, a.name, a.jiner) rn,a.*
          FROM tab a) a
START WITH rn = 1
CONNECT BY PRIOR rn = rn - 1 AND
           a.no = PRIOR a.no AND
           a.name = PRIOR a.name AND
           a.jiner = PRIOR a.jiner
GROUP BY a.no, a.name, a.jiner

我自己修改的例子

 SELECT a.pmeps,a.pmpbs, to_nclob(ltrim(MAX(sys_connect_by_path(to_char(pmkml), ',')), ',')) pmkml
FROM (SELECT row_number() over(PARTITION BY  a.pmeps, a.pmpbs 
         ORDER BY  a.pmeps, a.pmpbs) rn,a.*
          FROM placemark a) a
START WITH rn = 1
CONNECT BY PRIOR rn = rn - 1 AND
           a.pmeps = PRIOR a.pmeps AND
           a.pmpbs = PRIOR a.pmpbs
GROUP BY  a.pmeps, a.pmpbs