当前位置:数据库 > Oracle >>

提示报错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'
Oracle
MySQL
Access
SQLServer
DB2
Excel
SQLite
SYBASE
Postgres
如果你遇到数据库难题:
请访问www.zzzyk.com 试试
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,