Oracle两表关联更新

方法1： 
UPDATE T1 
SET T1.FMONEY = (select T2.FMONEY from t2 where T2.FNAME = T1.FNAME)
WHERE EXISTS(SELECT 1 FROM T2 WHERE T2.FNAME = T1.FNAME);

更新多个字段

update student stu
　　set (stu.name,stu.sex) =
　　(select bak.name,bak.sex
　　from student_bak bak
　　where bak.id = stu.id
　　and stu.age = 20
　　)
　　where exists (select 1
　　from student_bak bak
　　where bak.id = stu.id
　　and stu.age = 20
　　)

方法2：内联视图更新

UPDATE (
select t1.fmoney  fmoney1,t2.fmoney  fmoney2 from t1,t2 where t1.fname = t2.fname
)t
set fmoney1 =fmoney2;

方法3：merge更新

merge into t1
using (select t2.fname,t2.fmoney from t2) t
on (t.fname = t1.fname)
when matched then 
  update  set t1.fmoney = t.fmoney;