在线等，急求sql语句转成oracle。

[Yan_nis]

领导脑子被门夹了，好好的数据库要转成oracle，然后本宝宝自己写的有一小段sql语句也不知道怎么转，不怎么熟悉oracle，也希望能学习一下。我觉得最主要的问题可能就是内置函数
好了上截图

图上传不了。。。
放sql server语句

with t as (select s.GroupName,c.Mobile,c.Email,c.UserName from dbo.SysGroup as s
inner join dbo.Customers as c on c.GroupId=s.Id)
SELECT NEWID() as Id, GroupName,
STUFF(
(
SELECT ','+ Mobile FROM t a WHERE b.GroupName = a.GroupName FOR XML PATH('')
),1 ,1, '') Mobile,
STUFF(
(
SELECT ';'+ Email FROM t a WHERE b.GroupName = a.GroupName FOR XML PATH('')
),1 ,1, '') Email,
STUFF(
(
SELECT ','+ UserName FROM t a WHERE b.GroupName = a.GroupName FOR XML PATH('')
),1 ,1, '') UserName
FROM t b
GROUP BY GroupName

焦灼的很啊！

[js14982]

我就看出来你的+号改成||，||在oracle中是连接符。其他召唤水果大神@卖水果的net

[mayanzs]

试试 with t as (select s.GroupName,c.Mobile,c.Email,c.UserName from dbo.SysGroup as s inner join dbo.Customers as c on c.GroupId=s.Id) SELECT trunc(dbms_random.value(1,9999999999)) as Id, GroupName, wm_concat(Mobile) Mobile,wm_concat(Email) Email,wm_concat(UserName) UserName FROM t GROUP BY GroupName

[卖水果的net]

NEWID() 用 sys_guid 代替 FOR XML PATH('') ，可以换成 listagg 函数