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

最新推荐文章于 2024-07-18 08:28:50 发布

weixin_30707875

最新推荐文章于 2024-07-18 08:28:50 发布

阅读量346

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/mwd-banbo/p/10564424.html

版权

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

转载于:https://www.cnblogs.com/mwd-banbo/p/10564424.html