看不出,下面是我之前的例子: create or replace trigger tri_test1 after insert or update or delete on emp for each row --是否需要针对每条操作的数量做关注; begin if inserting then insert into log values (user,'EMP',sysdate,'Insert'); elsif updating then insert into log values (user,'EMP',sysdate,'Update'); else insert into log values (user,'EMP',sysdate,'Delete'); end if; end tri_test1;
不会啊。我是在同一个用户下建的
用户是test1啊
不好意思,schema杂用呢?不清楚啊
create or replace trigger tri_test1
after insert or update or delete on emp
for each row --是否需要针对每条操作的数量做关注;
begin
if inserting then
insert into log values (user,'EMP',sysdate,'Insert');
elsif updating then
insert into log values (user,'EMP',sysdate,'Update');
else
insert into log values (user,'EMP',sysdate,'Delete');
end if;
end tri_test1;