trigger_problem
public text v1 · immutableTable name : test
Duplicate table name : test_dup
fields : id | name | pin
I want to insert into test table but the values should be inserted into test_dup instead of on test table.All value sould be inserted into test_dup table not into test table.
I have the code plz modify it:
create or replace trigger a_trigger after insert on test for each row
begin
insert into test_dup values(:new.id,:new.name,:new.pin);
end;
/