Tuesday 10 May 2016

YOU HAVE 2 TABLES WITH THE SAME STRUCTURE. IF U DELETE A RECORD FROM ONE TABLE , IT WILL BE INSERTED IN 2ND TABLE ED TRIGGERNAME

Create or replace trigger backup 
after delete on emp fro each row begin 
insert into emp values (:old.ename,:old.job,:old.sal); 
end; 

No comments:

Post a Comment