Oracle 根据某字段将其他字段进行拼接的方法SYS_CONNECT_BY_PATH

SELECT djbh, LTRIM(MAX(SYS_CONNECT_BY_PATH(uname, ' ')), ',') appname,LTRIM(MAX(SYS_CONNECT_BY_PATH(ucode, ' ')), ',') appcode
FROM (SELECT wf.pk_check,user.ucode,user.uname,wf.djbh, ROW_NUMBER() OVER(PARTITION BY wf.djbh ORDER BY wf.pk_check DESC) RN
FROM wfn wf
left join user on wf.pk_check= user.pk_user
where checknote is null and approvestatus = '0')
START WITH RN = 1
CONNECT BY RN - 1 = PRIOR RN
AND djbh = PRIOR djbh
GROUP BY djbh;