17,086
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE TRIGGER PROVIEW.TRI_COILS2
AFTER INSERT OR UPDATE
ON PROVIEW.COILS1
FOR EACH ROW
DECLARE
V_NUM1 NUMBER(2);
V_NUM2 NUMBER(2);
V_VAR1 VARCHAR(4);
V_NUM3 NUMBER(4);
BEGIN
IF UPDATING THEN
BEGIN
V_NUM2 := TO_NUMBER(SUBSTR(:NEW.UF3,3,2));
V_NUM1 := TO_NUMBER(SUBSTR(:NEW.UF3,1,2));
V_NUM3 := TO_NUMBER(SUBSTR(:NEW.UF3,1,4));
V_VAR1 := TO_CHAR((V_NUM3-20));
IF ((V_NUM1>=1 AND V_NUM1<=23) AND (V_NUM2>=21 AND V_NUM2<=32) AND:NEW.FLAG = 119 ) THEN
UPDATE COILS1 SET PRIORITY = 0 WHERE UF3 = V_VAR1 AND FLAG = 119;
END IF;
END;
END IF;
END;