写了一个update语句更新Oracle数据库,不知道为什么,报错说“语法未结束”,语句如下 :
update z304
set z304_telephone_4='13918273648',z304_EMAIL_ADDRESS='[email protected]'
from z304,z308
where trim(substr(z308_rec_key,1,22))='0260123' and
trim(substr(z304_rec_key,1,12))=trim(z308_id) and
trim(substr(z304_rec_key,13,14))='01'
update z304
set z304_telephone_4='13918273648',z304_EMAIL_ADDRESS='[email protected]'
from z304,z308
where trim(substr(z308_rec_key,1,22))='0260123' and
trim(substr(z304_rec_key,1,12))=trim(z308_id) and
trim(substr(z304_rec_key,13,14))='01'
解决方案 »
- 卖身求答案,----------一个缺号分析的问题----------一,跪式答谢
- 关于存储过程的问题
- 为什么所有的数据库规范说明文档里面,都说了关键字要大写?
- Oracle并行度和表的degree字段的关系
- idle_time 和 connect_time 在客户端关闭后还起作用么?
- 关于PL/SQL连接数据库的问题,走投无路了高手请进(急)
- 哪里可以下载Microsoft office visio 2003画图软件
- 还有懂Oracle(for Linux/Unix)的朋友在吗?!
- 百分求一句SQL语句,懂的人应该很简单
- 请教PLSQL查询反应慢问题
- oracle语句执行结果代码返回
- 刚接触Oracle数据库求一个Sql查询语句
set z304.z304_telephone_4='13918273648',z304.z304_EMAIL_ADDRESS='[email protected]'
from z304,z308
where trim(substr(z308.z308_rec_key,1,22))='0260123' and
trim(substr(z304.z304_rec_key,1,12))=trim(z308.z308_id) and
trim(substr(z304_rec_key,13,2))='01'
set z304_telephone_4='13918273648',z304_EMAIL_ADDRESS='[email protected]'
-- from z304,z308 Update没有这个, 将其写在Where子句中
where trim(substr(z308_rec_key,1,22))='0260123' and
trim(substr(z304_rec_key,1,12))=trim(z308_id) and
trim(substr(z304_rec_key,13,14))='01'哥们,你写的这个Sql性能很差,如果有索引,该破坏的全都被你破坏掉了
update z304
set z304_telephone_4='13918273648',z304_EMAIL_ADDRESS='[email protected]'
where trim(substr(z304_rec_key,1,12))=
(select trim(z308_id) from z308
where trim(substr(z308_rec_key,1,22))='0260123') and
trim(substr(z304_rec_key,13,14))='01'