一个简单的Oracle触发器例子

一个简单的Oracle触发器例子

 

create or replace trigger TEST_TRIGGER
  BEFORE insert or update or delete on master 
 
  for each row
  
declare
  -- local variables here
begin
     case
     when inserting then

       
          INSERT INTO LOGS VALUES(SYSDATE,'INSERT:'||:new.id||','||:new.name);
       
     when DELETING THEN
       
          INSERT INTO LOGS VALUES(SYSDATE,'DELETE:'||:old.id);
       
     when updating THEN
        
           INSERT INTO LOGS VALUES(SYSDATE,'UPDATE:'||:old.id||'=>'||:new.id||','||:old.name||'=>'||:new.name);
        
     end case;
end TEST_TRIGGER;