CREATE TABLE shop ( people char(1), goods char(4), count NUMBER );CREATE TABLE shop_temp ( people char(1), goods char(4), count NUMBER );create or replace trigger temp_tri after insert or delete on shop for each row begin if deleting then delete from shop_temp where people=:old.people; elsif inserting then insert into shop_temp values(:new.people, :new.goods, :new.count); else null; end if; end; /
(
people char(1),
goods char(4),
count NUMBER
);CREATE TABLE shop_temp
(
people char(1),
goods char(4),
count NUMBER
);create or replace trigger temp_tri
after insert or delete on shop for each row
begin
if deleting then
delete from shop_temp where people=:old.people;
elsif inserting then
insert into shop_temp values(:new.people, :new.goods, :new.count);
else
null;
end if;
end;
/