不用做三个触发器,只要做一个就行
create or replace trigger tr_a after insert or update or delete on table_a for each row
begin
if inserting then
........................
elseif deleting then
........................
else
........................
end if
end;
create or replace trigger tr_a after insert or update or delete on table_a for each row
begin
if inserting then
........................
elseif deleting then
........................
else
........................
end if
end;
after
insert or update or delete on x
for each rowdeclare
....
begin
if inserting then
....
if updating then
....
if deleting then
....
end;
after
insert or update or delete on x
for each row
declare
....
begin
if inserting then
....
if updateing then
....
if deleteing then
....
end;
if inserting then ...... set tag=1;
if updating then ...... set tag=2;
if deleting then ...... set tag=3;