求教以下代码

2011-11-08 02:55:15 95 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

安装Anaconda和Labelme的教程 1 登录Anaconda官网，选择Download https://www.anaconda.com/distribution/ 2 选择你想下载的Python版本，选择你的操作系统和位数，然后点击Download按钮就开始下载了 3 开始安装下面两个框框都勾选点击next，等待安装成功打开Anaconda Navigator 点击红色圈圈的按钮在cmd中输入（1）创建虚拟环境 conda create -n labelme python=3.6 （2）激活虚拟环境 conda activa 阅读详情

create or replace trigger BillMadeUpdate
before update of made on bill
for each row
DECLARE
CURSOR curBF(billUUID bf.billuuid%type) IS SELECT BillUUID, FoodId, Copies FROM bf WHERE BillUUID = :new.billUUID;
CURSOR curFM(foodId fm.foodid%type) IS SELECT * FROM fm WHERE FoodId = foodId;
foodId bf.foodid%type; -- 菜编号
copies bf.copies%type; -- 份数
materialID fm.materialid%type; -- 食材编号
materialNum fm.materialnumber%type; -- 食材量
BEGIN
-- 一个订单会有多道菜
FOR r in curBF(:new.BillUUID)
LOOP
foodId := r.FoodId;
copies := r.copies;
-- 一道菜对应多种食材
FOR r1 IN curFM(foodId)
LOOP
materialID := r1.MaterialId;
materialNum := r1.Materialnumber * copies;
UPDATE Material SET Remain = Remain - materialNum WHERE r1.MaterialId = materialId;
END LOOP;
END LOOP;
end BillMadeUpdate;

上面运行不明白多减去了什么

...全文