很简单的呀。create or replace trigger tri_temp
before insert on tab1
for each row
p3 number(3);
begin
p3 :=:new.col1*2 + :new.col2*5;
proc1(:new.col1,:new.col2,p3);
:new.col3 := p3;
end;
/
before insert on tab1
for each row
p3 number(3);
begin
p3 :=:new.col1*2 + :new.col2*5;
proc1(:new.col1,:new.col2,p3);
:new.col3 := p3;
end;
/
before insert on tab1
for each row
p3 number(3);
begin
p3 :=:new.col1*2 + :new.col2*5;
proc1(:new.col1,:new.col2,p3);
:new.col3 := p3;
end;
/