我们经常使用merge into 进行更新
merge into vhisfund a
using vhisfund_1107 b
on (a.fund_account = b.fund_account and a.oc_date = b.oc_date)
when matched then
update set a.MONEY_TYPE = b.MONEY_TYPE
commit;
我们经常使用merge into 进行更新
merge into vhisfund a
using vhisfund_1107 b
on (a.fund_account = b.fund_account and a.oc_date = b.oc_date)
when matched then
update set a.MONEY_TYPE = b.MONEY_TYPE
commit;