create or replace trigger t_name
before insert on tbname
for each row
declare
v_dm tbname.dm%type;
begin
v_dm :=:new.dm;
select c2 into 变量 from tbname2 where v_dm.....
....
end;
before insert on tbname
for each row
declare
v_dm tbname.dm%type;
begin
v_dm :=:new.dm;
select c2 into 变量 from tbname2 where v_dm.....
....
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货