oracle触发器,用于选单后修改选单的表的触发动作。 --备货检验选单后 回写备货状态 CREATE OR REPLACE TRIGGER tri_TobaccoStockINSERT after I
oracle触发器,用于选单后修改选单的表的触发动作。
--备货检验选单后 回写备货状态
CREATE OR REPLACE TRIGGER tri_TobaccoStockINSERT
after INSERT
ON "TobaccoStockQuality"
FOR each ROW
BEGIN
UPDATE "GoodsStock" SET "FirstCheckState"=-1 WHERE "ID"=:NEW."GoodsStock_ID";
END;
--备货检验修改选单后 回写备货状态
CREATE OR REPLACE TRIGGER tri_TobaccoStockUPDATE
before UPDATE
ON "TobaccoStockQuality"
FOR each ROW
BEGIN
UPDATE "GoodsStock" SET "FirstCheckState"=decode(to_number(:NEW."AuditStatus"),0,-1) WHERE "ID"=:NEW."GoodsStock_ID";
IF :NEW."GoodsStock_ID"<>:OLD."GoodsStock_ID" THEN
UPDATE "GoodsStock" SET "FirstCheckState"=-1 WHERE "ID"=:OLD."GoodsStock_ID";
END IF;
END;
--备货检验删除单据后 回写备货状态
CREATE OR REPLACE TRIGGER tri_TobaccoStockDELETE
before DELETE
ON "TobaccoStockQuality"
FOR each ROW
BEGIN
UPDATE "GoodsStock" SET "FirstCheckState"=-1 WHERE "ID"=:OLD."GoodsStock_ID";
END;
--结束END--
本文标题: Oracle触发器实例代码
本文链接: https://www.lsjlt.com/news/51579.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
2024-09-20
2024-09-19
2024-09-19
2024-09-19
2024-09-19
2024-09-18
2024-09-18
2024-09-18
2024-09-18
2024-09-18
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0