为什么会出现 Warning: Trigger created with compilation errors
梧桐化雨° 2018-11-18 11:06:38 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;