oracle 触发器问题 - Oracle / 高级技术

SQL code:

create or replace trigger article_log_file
after update or delete or insert
on article
for each row
begin
if updating then
insert into log_file values
(old.authorID,'update',old.artcleName,sysdate);

else if deleting then
insert into log_file values
(old.authorID,'delete',old.artcleName,sysdate);

else if inserting then
insert into log_file values
(new.authorID,'insert',new.artcleName,sysdate);
end if;
end;


虽然语句执行了，但编译器提示编译带有错误，而且我插入时也出现了错误，望指教，初学……

---

我数了下，end if 只有一个，if 却有3个。

if 要与 end if 匹配

---

else if 改为 elsif 试试

PL/SQL if语句语法
if <条件1> then
  <语句1>;
elsif <条件2> then
  <语句2>;
elsif <语句3> then
  ....
else
  <语句n>;
end if;

---

2楼还不睡觉？ 够勤奋的

我睡觉去

---

create or replace trigger article_log_file
after update or delete or insert
on article
for each row
begin
  if updating then
  insert into log_file values
(old.authorID,'update',old.artcleName,sysdate);

  elseif deleting then
  insert into log_file values
(old.authorID,'delete',old.artcleName,sy