CREATE OR REPLACE TRIGGER STUD_TRG_324
BEFORE INSERT OR UPDATE OR DELETE ON STUD_324
FOR EACH ROW
BEGIN
IF INSERTING THEN
INSERT INTO ST_324
VALUES(:NEW.SNO,:NEW.SNAME,(SYSDATE-:NEW.BIRTHDAY)/365);
END IF;
IF UPDATING THEN
DELETE FROM ST_324 WHERE SNO=:OLD.SNO;
INSERT INTO ST_324
VALUES(:NEW.SNO,:NEW.SNAME,(SYSDATE-:NEW.BIRTHDAY)/365);
END IF;
IF DELETING THEN
DELETE FROM ST_324 WHERE SNO=:OLD.SNO;
END IF;
END.创建时提示:警告: 创建的触发器带有编译错误。
什么问题??
BEFORE INSERT OR UPDATE OR DELETE ON STUD_324
FOR EACH ROW
BEGIN
IF INSERTING THEN
INSERT INTO ST_324
VALUES(:NEW.SNO,:NEW.SNAME,(SYSDATE-:NEW.BIRTHDAY)/365);
END IF;
IF UPDATING THEN
DELETE FROM ST_324 WHERE SNO=:OLD.SNO;
INSERT INTO ST_324
VALUES(:NEW.SNO,:NEW.SNAME,(SYSDATE-:NEW.BIRTHDAY)/365);
END IF;
IF DELETING THEN
DELETE FROM ST_324 WHERE SNO=:OLD.SNO;
END IF;
END.创建时提示:警告: 创建的触发器带有编译错误。
什么问题??
真傻
哪位跟下贴
直接给分了