All pastes #767186 Raw Edit

trigger_problem

public text v1 · immutable
·published 2007-11-09 15:16 UTC
rendered paste body
Table 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;
/