update a set (name)=(select b.name from b where b.id=a.id)
where exists (select 1
from b
where b.id=a.id
)
或
merge into a
using b
on (b.id=a.id)
when matched then
update set
a.name =b.name
where exists (select 1
from b
where b.id=a.id
)
或
merge into a
using b
on (b.id=a.id)
when matched then
update set
a.name =b.name