plsql
Pages
Home
Web Development
c programming
java programming
minor projects
Python Programming
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment