Oracle迁移MySQL

1、左连接（+）改为left join

Oracle

select p.orgid, p.org_name 
from sys_org_info p, sys_org_info c 
where p.org_pid = 'A0001' 
and p.orgid = c.org_pid(+) 
group by p.orgid, p.org_name 
order by p.orgid

MySQL

SELECT p.orgid, p.org_name 
FROM sys_org_info p 
LEFT JOIN sys_org_info c 
ON p.orgid = c.org_pid 
WHERE p.org_pid = 'A0001' 
GROUP BY p.orgid, p.org_name 
ORDER BY p.orgid

2、listagg、xmlagg方法

Oracle

xmlagg(xmlparse(content b.iso ||',' wellformed)order by b.id).getclobval() as orgnames 

listagg(b.iso,',') within group (order by b.id) as orgnames 
 

(select listagg(n.group_name,',') within group (order by group_name) as group_names

MySQL

GROUP_CONCAT(b.iso order by b.id SEPARATOR ',') AS orgnames 

(SELECT GROUP_CONCAT(n.group_name order by group_name SEPARATOR ',') AS group_names