Shulou(Shulou.com)06/01 Report--

Oracle trigger, which is used to modify the trigger action of the menu table after the menu.

-- write back the stock status CREATE OR REPLACE TRIGGER tri_TobaccoStockINSERTafter INSERTON "TobaccoStockQuality" FOR each ROWBEGINUPDATE "GoodsStock" SET "FirstCheckState" =-1 WHERE "ID" =: NEW. "GoodsStock_ID" after the END;-- stock inspection menu; write back the stock status CREATE OR REPLACE TRIGGER tri_TobaccoStockUPDATEbefore UPDATEON "TobaccoStockQuality" FOR each ROWBEGINUPDATE "GoodsStock" SET "FirstCheckState" = decode (to_number (: NEW. "AuditStatus") WHERE "ID" =: NEW. "GoodsStock_ID" IF: NEW. "GoodsStock_ID": OLD. "GoodsStock_ID" THENUPDATE "GoodsStock" SET "FirstCheckState" =-1 WHERE "ID" =: OLD. "GoodsStock_ID"; END IF;END;-- stock inspection, delete the document and write back the stock status CREATE OR REPLACE TRIGGER tri_TobaccoStockDELETEbefore DELETEON "TobaccoStockQuality" FOR each ROWBEGINUPDATE "GoodsStock" SET "FirstCheckState" =-1 WHERE "ID" =: OLD. "GoodsStock_ID"; END

The above is the example code of Oracle trigger introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave a message for me, and the editor will reply you in time. Thank you very much for your support to the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.