create or replace trigger trg_name
before insert on A
for each row
declare
v_num number;
begin
select count(*) into v_num from b where b.caller=:new.caller;
if v_num>0 then
insert into temp(...,b_cnt) values(:new.caller,:new.callee,:new.send-:new.date,1);
else
insert into temp ...(...,a_cnt) values(:new.caller,:new.callee,:new.send-:new.date,1);
end if;
end trg_name;
/
before insert on A
for each row
declare
v_num number;
begin
select count(*) into v_num from b where b.caller=:new.caller;
if v_num>0 then
insert into temp(...,b_cnt) values(:new.caller,:new.callee,:new.send-:new.date,1);
else
insert into temp ...(...,a_cnt) values(:new.caller,:new.callee,:new.send-:new.date,1);
end if;
end trg_name;
/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货