17,377
社区成员
发帖
与我相关
我的任务
分享
create or replace trigger trib_log
after insert or update or delete on student
for each row
declare
integrity_error exception;
errno integer;
errmsg char(200);
begin
if inserting then
insert into log(afterName) values (:NEW.beforName);
elsif updating then
insert into log(afterName) values (:NEW.beforName);
elsif deleting then
insert into log(beforName) values (:OLD.beforName);
end if;
exception
when integrity_error then
raise_application_error(errno, errmsg);
end;