pl/sql触发器案列

--pl/sql触发器--对表emp2进行insert,delete,update操作的具体信息进行记录create table emp2_log(uname varchar2(20),--操作人action varchar2(10),--操作类型atime  date         --时间);--定义触发器create or replace trigger trig  -- before insert or delete or update ........  after insert or delete or update on emp2 for each rowbegin  if inserting then  --USER为关键字,代表当前用户     insert into emp2_log values(USER,'insert',sysdate);  elsif deleting then --inserting,deleting,updating均为关键字     insert into emp2_log values(USER,'delete',sysdate);  elsif updating then     insert into emp2_log values(USER,'update',sysdate);  end if;end;