hi to all,
i am creating the trigger for insert and update in oracle. the query is


create trigger insertandupdate
after update
on testtable
for each row
begin
insert into testtable1 values(:new.name,:new.age,:new.mailid,:new.datetime)

end;


the problem in that query is , when i am inserting one row , it is getting all the rows in the table including the newly inserted row. i want to get only the newly inserted row only not all the rows. how can i get the value. and how can i solve the problem. plz anybody know , help me.
thank u

with thanks and regards
mmary