create?table?delemp(name?varchar(20)?,?deldate?date)
create?or?replace?trigger?delemp_tri
after?delete?on?emp
for?each?row
beagin
????insert?into?delemp?values(:old.ename,?select?sysdate?from?dual);
end;
/

create table del_table(delname varchar(20) , deldate date)

create or replace trigger del_tri

after delete

on emp

for each row

beagin

????insert into del_table values(select user from dual , select sysdate from dual);

end;

create table dele(dname varchar2(20),dtime date)

create or replace trigger beigen
after delete
on emp
for each row
begin
? insert into dele values(:old.ename,sysdate);
end;

添加開除時(shí)間和開除人比較好實(shí)現(xiàn)，sql語(yǔ)句就行了?，F(xiàn)在是想想你的觸發(fā)條件，員工被開除是哪個(gè)表受影響，是否符合觸發(fā)器的觸發(fā)條件。