oracle 结果集 拼接 LISTAGG

    SELECT 
                    p.id,
                    LISTAGG ( wp.fname, '->' ) WITHIN GROUP ( ORDER BY w.forder) as fname
            FROM yg_bs_process p 
                    LEFT JOIN yg_bs_process_workstep w ON p.id = w.fparentid
                    LEFT JOIN yg_bs_workstep wp ON w.fworkstep=wp.id
                    where p.status!=1 and w.status!=1 and wp.status!=1
                    GROUP BY p.id