mysql视图sql转换为oracle视图sql

mysql导出的视图sql:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `v_privilegelist` AS select `p`.`id` AS `id`,`p`.`name` AS `NAME`,`p`.`info` AS `info`,group_concat(`u`.`id` separator ',') AS `url_id`,group_concat(`u`.`name` separator ',') AS `url_name`,group_concat(`u`.`url` separator ',') AS `url_url` from ((`privilege` `p` left join `privilegeurl` `pu` on((`p`.`id` = `pu`.`privilegeid`))) left join `url` `u` on((`pu`.`urlid` = `u`.`id`))) group by `p`.`id`;

改为oracle可执行的sql:

CREATE  VIEW v_privilegelist AS select p.id  id,p.name  NAME,p.info  info,
listagg(u.id , ',')within group( order by u.id)  url_id,
listagg(u.name , ',')within group( order by u.name)  url_name,
listagg(u.url , ',')within group( order by u.url)  url_url from ((privilege p left join privilegeurl pu on((p.id = pu.privilegeid))) left join url u on((pu.urlid = u.id))) group by p.id,p.name,p.info;