All pastes #766879 Raw Edit

trigger_problem

public text v1 · immutable
·published 2007-11-09 06:58 UTC
rendered paste body
I want to write a trigger as if I insert into table then the values get inserted into duplicate table instead of inserting table.
note : The value sould be inserted only into duplicate table not the real table.

I have the code plz modify it:

table name :  test
duplicate table name : test_dup

fields : id | name | pin

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;
/