急急急!建了一个触发器,但是提示警告:创建的触发器带有编译错误,哪位大神帮忙看一下
这是建的表:
create table TZ_test
(
ID int,
name varchar2(20),
cc date,
fh date,
sj number
);
这是建的触发器:
CREATE OR REPLACE TRIGGER TZ_ALT
AFTER INSERT OR UPDATE
ON TZ_test
FOR EACH ROW
BEGIN
IF INSERTING THEN
UPDATE TZ_test SET sj=fh-cc WHERE name=NEW.name;
ELSE
UPDATE TZ_test SET sj=fh-cc WHERE name=OLD.name;
END IF;
END;
/