try:create or replace trigger trg_t2
before insert on t2
for each row
begin
insert into t3(n1,c1) select n1,c1 from t1 where c1=:new.c1;
end trg_t2;
/
before insert on t2
for each row
begin
insert into t3(n1,c1) select n1,c1 from t1 where c1=:new.c1;
end trg_t2;
/
create or replace trigger trg_t2
before insert on t2
for each row
begin
insert into t3(n1,c1) select n1-:new.n1,c1 from t1 where c1=:new.c1;
end trg_t2;
/
Before Insert On t2
For Each Row
Begin
insert into t3(n1,c1) select n1-:New.n1,c1 from t1 where c1=:new.c1;
End testinsert;
before insert on t2
for each row
begin
insert into t3(n1,c1) select n1-:new.n1,:new.c1 from t1 where c1=:new.c1;
end;
/
insert into t3(n1,c1) select n1-:new.n1,:new.c1 from t1 where c1=:new.c1;