sqlserver中sql语法是这样的啊.怎么在oracle中就报错呢,应该怎么写?update PRT_ECUSERS_TMP set PRT_ECUSERS_TMP.state=3 from PRT_ECUSERS_TMP inner join PRT_ECUSERS on prt_ECUSER.msisdn = PRT_ECUSERS_TMP.msisdn and PRT_ECUSER.servicecode = PRT_ECUSERS_TMP.servicecode where PRT_ECUSER.startdate < PRT_ECUSER.enddate and PRT_ECUSER.enddate >= PRT_ECUSERS_TMP.startdate and PRT_ECUSERS_TMP.state='1'报?这里错误 state=3 ?from
ERROR 位于第 1 行:
ORA-00933: SQL 命令未正确结束
ERROR 位于第 1 行:
ORA-00933: SQL 命令未正确结束
解决方案 »
- 求解SQL
- 请有治疗巧克力囊肿经验的朋友,到如下地址和病友交流(恳求不要删除)
- oracle中function能否这样使用临时表
- 求Oracle 10g Web开发书籍!
- 各位大虾,有个问题请教,关于自定义数据导入数据库的
- 在 oracle 网站下载的 Oracle 10g 与购买正版的有什么区别呢?
- dbf文件能导入到oracle数据库中吗?
- plsql里面两个集合的合集、差集、交集怎么写?
- 我管理的服务器最近总是出现不能连接到数据库,WEB服务登陆界面出现Database Log In Failed 是什么原因,8i,SUN E250,请教各位大虾
- 关于外键的disable
- 有谁知道在哪里能下载到OCCI
- 这条sql语句该怎么写呀
set PRT_ECUSERS_TMP.state = 3
where msisdn in
(select prt_eCUSERS.msisdn
from PRT_ECUSER, PRT_ECUSERS_TMP
where PRT_ECUSER.servicecode = PRT_ECUSERS_TMP.servicecode and
PRT_ECUSER.startdate < PRT_ECUSER.enddate and
PRT_ECUSER.enddate >= PRT_ECUSERS_TMP.startdate and
PRT_ECUSERS_TMP.state = '1')
update PRT_ECUSERS_TMP set PRT_ECUSERS_TMP.state=3 from PRT_ECUSERS_TMP inner join PRT_ECUSERS on prt_ECUSER.msisdn = PRT_ECUSERS_TMP.msisdn and PRT_ECUSER.servicecode = PRT_ECUSERS_TMP.servicecode where PRT_ECUSER.startdate < PRT_ECUSER.enddate and PRT_ECUSER.enddate >= PRT_ECUSERS_TMP.startdate and PRT_ECUSERS_TMP.state='1'在sqlserver里就能用啊.在oracle里如果不用in,应该怎么写啊