create trigger student_tri before delete on student for each row begin insert into student_delete values(:old.name,:old.age,:old.sex,:old.join_time,sysdate); end; /
create trigger tri_delstudent after delete on student for each now begin insert into student_delete values(:old.name,:old.age,:old.sex,:old.join_time,sysdate); end; /
before delete on student
for each row
begin
insert into student_delete values(:old.name,:old.age,:old.sex,:old.join_time,sysdate);
end;
/
after delete on student
for each now
begin
insert into student_delete values(:old.name,:old.age,:old.sex,:old.join_time,sysdate);
end;
/