Hi all,
I want to transfer only updated data to another temp table. so i have created following trigger. but it's not working. so can some send me the working trigger with correct syntex. thanks a lot.
create trigger Test_copy after insert on
DBA.test_org
referencing new as inserted
for each row
begin
insert into DBA.test_back (ID, data) Select ID,data from inserted
end
Regards, krish