22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE TRIGGER TR_TEST1
AFTER INSERT
ON A
FOR EACH ROW
DECLARE PL1 A.PL%TYPE;
JG1 B.JG%TYPE ;
JG2 A.JG%TYPE;
NN NUMBER;
begin
PL1:=:NEW.PL;
JG2:=:NEW.JG;
SELECT MAX(JG) AS MJG INTO JG1 FROM B WHERE PL=PL1;
SELECT COUNT(*) AS NUM1 INTO NN FROM B WHERE PL=PL1;
IF NN<>0 THEN
CASE WHEN JG1>=200+JG2 UPDATING THEN
INSERT INTO B (PL,JG) VALUES(PL1,JG1) ;
END CASE;
END IF;
end;