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