create or replace trigger trg_dept
before insert or update or delete on dept
declare
v_now varchar2(30);
begin
v_now:=to_char(sysdate,'yyyy-mm-dd hh24:mi:ss');
case
when inserting then
dbms_output.putline(v_now||'对dept表进行了insert操作。');
when updating then
dbms_output.putline(v_now||'对dept表进行了update操作。');
when deleting then
dbms_output.putline(v_now||'对dept表进行了delete操作。');
end case;
end;
before insert or update or delete on dept
declare
v_now varchar2(30);
begin
v_now:=to_char(sysdate,'yyyy-mm-dd hh24:mi:ss');
case
when inserting then
dbms_output.putline(v_now||'对dept表进行了insert操作。');
when updating then
dbms_output.putline(v_now||'对dept表进行了update操作。');
when deleting then
dbms_output.putline(v_now||'对dept表进行了delete操作。');
end case;
end;
before insert or update or delete on dept
declare
v_now varchar2(30);
begin
v_now:=to_char(sysdate,'yyyy-mm-dd hh24:mi:ss');
if inserting then
dbms_output.putline(v_now||'对dept表进行了insert操作。');
elsif updating then
dbms_output.putline(v_now||'对dept表进行了update操作。');
elsif deleting then
dbms_output.putline(v_now||'对dept表进行了delete操作。');
end if;
end;