Oracle 批量update语句,Oracle之update语句优化研究 批量更新

update (select YP.DEALLOCATE_BUDGET_, YP.REMAIN_BUDGET_ from MP_YEAR_PLAN YP where YP.YEAR_PLAN_ID_ in ('3a9fdccff48c49ddb42563dbac6f3fdd', '45f05792c15d483fa9dd2d9c64c7a784')) set DEALLOCATE_BUDGET_ = REMAIN_BUDGET_；

--注释：红色部分可传list

多表关联执行update:

update (select A.JOIN_STATE as JOIN_STATE_A, B.JOIN_STATE as JOIN_STATE_B

from T_JOIN_SITUATION A, T_PEOPLE_INFO B

where A.PEOPLE_NUMBER = B.PEOPLE_NUMBER

and A.YEAR = '2011'

and A.CITY_NUMBER = 'M00000'

and A.TOWN_NUMBER = 'M51000')

set JOIN_STATE_A = JOIN_STATE_B

标签：语句,JOIN,update,NUMBER,STATE,BUDGET,Oracle,YP

来源： https://www.cnblogs.com/mwd-banbo/p/10564424.html