关于触发器(删除表)的问题

[caral525]

现有一张存储学生信息student(name,age,sex,join_time)的表单,要求每删除一条记录时,将记录存入另一张表student_delete中,并记录下删除的时间.(student与student_delete结构类似,后者仅比前者多一个删除时间的字段.)
请问该如何创建该触发器?
(希望程序尽量详细一点,最后有注释!)

[beckhambobo]

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;
/

[kerisyml]

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;
/