Oracle数据库update触发器

在项目中使用到Oracle数据库的Update触发器，先记录下来方便以后查阅。

预备知识和格式以后再编辑吧，先把内容贴出来。

CREATE OR REPLACE TRIGGER demo_trigger

AFTER UPDATE ON tb_goods

REFERENCING NEW AS NEW OLD AS OLD

FOR EACH ROW

WHEN( NEW.AMOUNT = 10  OR NEW.AMOUNT = 0)

DECLARE
 MSG VARCHAR2(100);
 RECEIVER NUMBER;
 SENDER NUMBER;
 goUrl VARCHAR2(200);
 STATE VARCHAR2(2);
-- Params VARCHAR2(30);
--Pvalue NUMBER;

BEGIN
 
     
     MSG :=  '您的商品' || :NEW.GOODSNAME;
     SENDER := 0;
     STATE := '0';
     goUrl := 'goodsAction_query.action';
     
     SELECT S.USER_ID INTO RECEIVER FROM TB_SHOP S WHERE S.SHOP_ID = :NEW.SHOPID;
     
     IF :NEW.AMOUNT = 10  THEN
           
       MSG := MSG || '库存数量不足10件，请及时补货！';
       INSERT INTO TB_ME