update bb
set (bb.col1,bb.col2)=(select aa.col1,aa.col2 from aa where bb.key=aa.forkey)
where exists(
select 1 from aa where bb.key=aa.forkey
)
Oracle 之 update 例子
最新推荐文章于 2021-04-02 21:06:14 发布
update bb
set (bb.col1,bb.col2)=(select aa.col1,aa.col2 from aa where bb.key=aa.forkey)
where exists(
select 1 from aa where bb.key=aa.forkey
)