CREATE OR REPLACE TRIGGER TEST_TRIGGER
BEFORE DELETE ON TABLE SYSTEM.TEMP1
FOR EACH ROW
BEGIN
INSERT INTO TEMP2
(TAG_CODE, DAY_ID, SYZ, BYZ)
VALUES
(:TEMP1.TAG_CODE, :TEMP1.DAY_ID, :TEMP1.SYZ, :TEMP1.BYZ);
END;
SQL语句无效,表名无效请大家指点。
BEFORE DELETE ON TABLE SYSTEM.TEMP1
FOR EACH ROW
BEGIN
INSERT INTO TEMP2
(TAG_CODE, DAY_ID, SYZ, BYZ)
VALUES
(:TEMP1.TAG_CODE, :TEMP1.DAY_ID, :TEMP1.SYZ, :TEMP1.BYZ);
END;
SQL语句无效,表名无效请大家指点。
2、倒数第2行中的“:TEMP1”换成“:OLD”或“:NEW”
BEFORE DELETE ON TEMP1
FOR EACH ROW
BEGIN
INSERT INTO TEMP2
(TAG_CODE, DAY_ID, SYZ, BYZ)
VALUES
(:OLD.TAG_CODE, :OLD.DAY_ID, :OLD.SYZ, :OLD.BYZ);
END;
修改成以上,提示END处,无效的SQL语句