Oracle Update Select

Our sky

已于 2022-05-11 10:49:00 修改

阅读量607

点赞数

分类专栏：数据库文章标签： java oracle

于 2022-05-11 10:48:24 首次发布

本文链接：https://blog.csdn.net/fei0700/article/details/124705028

版权

数据库专栏收录该内容

7 篇文章 0 订阅

订阅专栏

Oracle 更新多行

BEGIN
  FOR cr IN (SELECT Zlwl_Zc_AccountId, AmountOfproduction
               FROM Zlwl_Zc_ScrapApply a
              WHERE Zlwl_Zc_ScrapApplyId =
                    '251dacca-756c-49f8-98e6-14cb8f49e985') loop
    
    UPDATE Zlwl_Zc_Account a
       SET a.ZC_STATE = '2', a.AmountOfproduction = cr.AmountOfproduction
     WHERE a.Zlwl_Zc_AccountId = cr.Zlwl_Zc_AccountId; 
  
  END loop; -
END;