create or replace trigger tri_operation 2 before 3 insert or delete or update of sal 4 on emp 5 for each row 6 begin 7 if updating then 8 insert into operation_log values(operationid.nextval,user,sysdate,'update','scott.emp',:old.empno,:old.sal,:new.sal);9 elsif inserting then 10 insert into operation_log values(operationid.nextval,user,sysdate,'insert','scott.emp',:new.empno,null,:new.sal); 11 else 12 insert into operation_log values(operationid.nextval,user,sysdate,'delete','scott.emp',:old.empno,:old.sal,null); 13 end if; 14 end; 15 /
Warning: Trigger created with compilation errors.
sql语句 格式化一下贴出来