Oracle 之 update 例子

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
)