ora-00907 缺失右括号？？？？？

[tianxia198909]

SELECT /*+ parallel (statcmain )*/
sum(decode(statcmain.certitype,''P'', 1,decode(statcmain.endortype, ''19'', ''-1'', 0))) as Count,
sum((STATCMAIN.CHGPREMIUM - STATCMAIN.CHGMIDDLECOST) * STATCMAIN.CNYEXCHRATE * STATCMAIN.COINSRATE / 100) as premium,
sum(STATCMAIN.CHGINSURED * STATCMAIN.CNYEXCHRATE * STATCMAIN.COINSRATE / 100) as amount,
sum(STATCMAIN.CHGLIMIT * STATCMAIN.CNYEXCHRATE * STATCMAIN.COINSRATE / 100) as limit
FROM rep.Statcmain,
reptest.statcogsharerate,
rep.statdcompanylevel
where Statcmain.Policyno = statcogsharerate.policyno(+)
and statcmain.comcode = statdcompanylevel.comcode
and statcmain.riskcode NOT IN (''YAB0'', ''2797'', ''2798'')
AND STATCMAIN.CLASSCODE <> ''30''
group by statcmain.statdate,
statcmain.StartDate,
statcmain.COMCODE,
decode(statcmain.riskcode,
''2700'',
statcmain.productcode,
statcmain.riskcode),
statcmain.SHAREHOLDERFLAG,
statcmain.BUSINESSNATURE,
((substr(statcmain.othflag, 1, 1))),
statdcompanylevel.centercode,
statcmain.Agentcode,
statcmain.Handler1code,
decode(substr(statcmain.othflag, 15, 1),
NULL,
''0'',
substr(statcmain.othflag, 15, 1)),
statcmain.BusinessKind,
statcmain.BusinessClass,
CASE WHEN (statcmain.businessflag IS NULL OR statcmain.businessflag <> ''1'') THEN (''0'')
ELSE (''1'') END,
statcmain.businesssource,
statcmain.constructtype,
statcmain.channeltype,
statcmain.servicearea,
statcmain.agriFlag,
statcmain.usenaturecode,
statcmain.carkindcode,
statcmain.toncount,
statcmain.applitype,
statcmain.ventureflag,
statcmain.grouppurchaseflag;

[yy1987316]

拼语句的时候，没加空格

[發糞塗牆]

Oracle发来SQLServer干嘛？这个你自己检查就可以拉。

[tianxia198909]

具体是什么原因啊

[Mr_Nice]

错误报的是比较明确的，就是缺失了括号。 lz仔细查一下代码即可。

[backsteet2]

decode(substr(statcmain.othflag, 15, 1)), NULL, ''0'',

[Subfn]

这个问题应该是sql语句的问题，lz仔细检查下吧。。。。。。。。。。