创建触发器

对表进行增，删，查，改；

create or replace trigger tr_test
  before insert or update or delete on log_student 

declare
 content varchar(20);
begin
 if inserting then
content :='新增';
elsif updating then
content:='修改';
else
content:='删除';
end if;
insert into log_student values(seq.nextval,content,sysdate);
end tr_test;

限制操作（只能在星期一或星期五修改）；

create or replace trigger tr_command
  before insert or update or delete on student 
declare
begin
  if(TO_CHAR(SYSDATE,'DY') not IN ('MON','FRI')) then
    RAISE_APPLICATION_ERROR(-20500,'非法时间修改表错误');
  end if;
end tr_command;

转载于:https://www.cnblogs.com/blogsport/archive/2010/12/09/1901023.html