PL/SQL Trigger to Insert Deleted Record in New Table

PL/SQL Trigger to Insert Deleted Record in New Table:


When any record gets deleted from STUDENT table the that RECORD directly get inserted into ST table.

create or replace trigger on_del
before delete
on student
for each row
begin
insert into st values(:old.id,:old.name,:old.salary,:old.city,:old.s_date);
end;

 

Leave a Reply

Your email address will not be published. Required fields are marked *

16 − nine =