写了一个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 数据库实现自增长列
- 运行SQL出错,请大虾们帮忙,给力100分
- Oracle数据库插入小数的问题
- 大家帮忙分析这个SQL,高分哦
- 在ORACLE8中创建视图,出现错误提示:ORA-00904,无效列名,检查了表里的字段名称,没错,原因何在?在线等,着急!
- (在线等待,急急急) 关于一个insert语句的写法
- 关于ORACLE8.1.6与金山毒霸2002的冲突问题
- 如何发语句统计所有表的记录数,表名是A1到A500。
- sys.WRH$_SQL_BIND_METADATA表被锁了,怎么办,急求高手帮忙处理!!!!!
- Plsqldeveloper r 7.1.5.1398连接Oracle 10g问题
- 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'