提示报错oracle 中 ORA-00936: missing expression ,请问语法上有什么问题吗
"INSERT INTO Op_FiexdCallFeeSms "
"SELECT d.PHONE_NO,b.ID_NO,b.CONTRACT_NO, a.ATTR_VALUE,a.ATTR_ID,c.BILL_DAY,'10001','0',nvl(sum(d.CHRG_AMOUNT),'0') "
"FROM "
"PD_USERPRCATTR_INFO a, "
"UR_USER_INFO b,"
"UR_BILLDAY_INFO c, "
"AC_ACCTSHTUNPAID_CUR_%d d "
"WHERE "
"a.ATTR_ID ='P008' AND a.EXP_DATE >= sysdate AND a.EFF_DATE <sysdate "
"AND a.ID_NO=b.ID_NO AND b.ID_NO=c.ID_NO AND a.ID_NO=d.ID_NO AND having sum(d.CHRG_AMOUNT)>=a.ATTR_VALUE AND a.ATTR_VALUE !='0'
答案:把双引号去掉
没有GROUP BY
AND a.ATTR_VALUE !='0'应该在having之前
HAVING前面不应该有AND
上一个:oracle新建的数据文件里创建用户问题?
下一个:如何将下面的Oracle语句变为MySQL的而实现相同的功能?求助!!!