create table sale(a varchar2(5),b int); create table store(a varchar2(5),b int);insert into store values ('a',10); insert into store values ('b',20);08:41:38 SQL> create or replace trigger sale_trig 08:41:49 2 after insert on sale 08:41:49 3 for each row 08:41:49 4 begin 08:41:49 5 update store set b=b-:new.b where a=:new.a; 08:41:49 6 end; 08:41:49 7 /触发器已创建已用时间: 00: 00: 00.21 08:41:50 SQL> insert into sale values ('a',5);已创建 1 行。已用时间: 00: 00: 00.10 08:42:03 SQL> insert into sale values ('b',6);已创建 1 行。已用时间: 00: 00: 00.10 08:42:07 SQL> select * from store;A B ----- ---------- a 5 b 14已用时间: 00: 00: 00.10
create table store(a varchar2(5),b int);insert into store values ('a',10);
insert into store values ('b',20);08:41:38 SQL> create or replace trigger sale_trig
08:41:49 2 after insert on sale
08:41:49 3 for each row
08:41:49 4 begin
08:41:49 5 update store set b=b-:new.b where a=:new.a;
08:41:49 6 end;
08:41:49 7 /触发器已创建已用时间: 00: 00: 00.21
08:41:50 SQL> insert into sale values ('a',5);已创建 1 行。已用时间: 00: 00: 00.10
08:42:03 SQL> insert into sale values ('b',6);已创建 1 行。已用时间: 00: 00: 00.10
08:42:07 SQL> select * from store;A B
----- ----------
a 5
b 14已用时间: 00: 00: 00.10