CREATE OR REPLACE TRIGGER GUOTRI
after insert or delete or update on tiggerRecord for each ROW
BEGIN
IF inserting THEN
INSERT INTO tiggerRecord VALUES (USER,'insert',SYSDATE);
ELSE IF updating THEN
INSERT into tiggerRecord VALUES (USER,'update',SYSDATE);
ELSE IF deleting THEN
INSERT INTO tiggerRecord VALUES (USER,'delete',SYSDATE);
END IF;
END;
plsql报错信息为
9/7 PLS-00103: 出现符号 ";"在需要下列之一时: if
after insert or delete or update on tiggerRecord for each ROW
BEGIN
IF inserting THEN
INSERT INTO tiggerRecord VALUES (USER,'insert',SYSDATE);
ELSE IF updating THEN
INSERT into tiggerRecord VALUES (USER,'update',SYSDATE);
ELSE IF deleting THEN
INSERT INTO tiggerRecord VALUES (USER,'delete',SYSDATE);
END IF;
END;
plsql报错信息为
9/7 PLS-00103: 出现符号 ";"在需要下列之一时: if
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货