Question

读代码，读到这么一句sql语句，到pl/sql执行时显示缺失右括号,语句如下：

select * from (select sum(JE) as sumje,month(XSDATE) as xsmonth from SELL where year(XSDATE)='2013' group by month(XSDATE) union select 0,MonthName from GetMonth() where MonthName not in (select month(XSDATE) as xsmonth from SELL where year(XSDATE)='2013' group by month(XSDATE))) temp order by temp.xsmonth

Answer 1

GetMonth（）应该是别人自己写的sql函数

追问

应该就是这样的

Answer 2

from GetMonth() ???

追问

对，就是这个貌似有问题，原来的sql语句貌似是sqlserver的，如果要改成oracle
的怎么改？我查了sqlserver好像也没这个呀..