如何将这条SQL的update语句改成Oracle的语句(同时修改多字段)？

mobbs 2003-10-28 06:10:58

如何将这条SQL的update语句改成Oracle的语句(同时修改多字段)？
update table1 set f1=b.f1,f2=b.f2,f3=b.f3 from table1 a,bable2 b where a.id=b.id

...全文

182 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

beckhambobo 2003-10-28

打赏
举报

update table1 a set (f1,f2,f3)=(select f1,f2,f3 from bable2 b where a.id=b.id)

smallcrocodile 2003-10-28

打赏
举报

支持楼上

vrv0129 2003-10-28

打赏
举报

update table1
set
f1=(select b.f1 from bable2 b,table1 a where a.id=b.id),
f2=(select b.f2 from bable2 b,table1 a where a.id=b.id),
f3=(select b.f3 from bable2 b,table1 a where a.id=b.id)；

hdkkk 2003-10-28

打赏
举报

update table1 set (f1,f2,f3)=select f1,f2,f3 from bable2 b where a.id=b.id
where exist(select 1 from bable2 b,table1 a where a.id=b.id)

LGQDUCKY 2003-10-28

打赏
举报

oracle要这样写
update table1
set f1=(select b.f1 from bable2 b,table1 a where a.id=b.id),
f2=(select b.f2 from bable2 b,table1 a where a.id=b.id),
f3=(select b.f3 from bable2 b,table1 a where a.id=b.id)；

jiezhi 2003-10-28

打赏
举报

update table1 set f1=b.f1,f2=b.f2,f3=b.f3
from table1 a,bable2 b where a.id=b.id
--------->>>>
update table1
set f1=(select b.f1 from bable2 b,table1 a where a.id=b.id),
f2=(select b.f2 from bable2 b,table1 a where a.id=b.id),
f3=(select b.f3 from bable2 b,table1 a where a.id=b.id)
where exist(select 1 from bable2 b,table1 a where a.id=b.id)