update table1 set field1 = '111',field2 = '222'
from (select table1.f1, table1.field3 from table1, table3
where table1.f1 = table3.fd2
and table1.ToCaculateFlag = 1 and table3.fd1 = '333')
as table2 ,table1
where table2.f1 = table1.f1 and table2.field3 = table1.field3;
from (select table1.f1, table1.field3 from table1, table3
where table1.f1 = table3.fd2
and table1.ToCaculateFlag = 1 and table3.fd1 = '333')
as table2 ,table1
where table2.f1 = table1.f1 and table2.field3 = table1.field3;
解决方案 »
- 查询出一个表比另外一个表多出的记录
- oracle sql语句参数最多多少个?
- Orcale完全没碰过,寻求自学书籍!
- xml导入到oracle表中
- 普通视图和物化视图的区别
- ORACLE 9i 数据库的回滚段使用率不断增加,不知何种问题?
- ------------------------------------------------刪除相同紀錄----------------------------------------------------
- 直接用SQL可以从SYS.ALL_TAB_COLS表中可以查到结果,可是从存储过程中确拿不到?
- 如何在Red hat9.0下安装Oracle9i
- 如何去掉空格?急!
- 语句优化,合成,看看有没有可能,不可能能不能给个其他优化思路
- 大家感恩节快乐!~~顺便问个小问题 ORACLE 报的错:maximun number of sessions exceeded
不支持 update ...from...
where exists (select 1 from table3
where table1.f1 = table3.fd2
and table1.ToCaculateFlag = 1 and table3.fd1 = '333'
)
from (select table1.f1, table1.field3, from table1, table3
where table1.f1 = table3.fd2
and table1.ToCaculateFlag = 1 and table3.fd1 = '333')
as table2
where table2.f1 = table1.f1 and table2.field3 = table1.field3
update table1 set (field1,field2)=(select ... from ...) where exists(select 1 from ...)
自己改吧