create or replace trigger tr2 after--插入的时间 insert or delete or update on stu0824 --目标对象 for each row--如果写这个，表示对每行都进行触发 declare
begin if inserting then insert into stulog1(id,stime,info) values(xk0824.nextval,sysdate,'插入操作'); elsif deleting then insert into stulog1(id,stime,info) values(xk0824.nextval,sysdate,'删除操作'); else insert into stulog1(id,stime,info) values(xk0824.nextval,sysdate,'更新操作'); end if; end tr1; /
createorreplacetrigger up_sal
after updateon emp
for each row
beginif(:new.sal<:old.sal) theninsertinto tmp_table
values(:old.empno,:old.ename,:old.sal,:new.sal,:old.job);
endif;
end;
