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;