ORACLE之触发器（trigger）

触发器(trigger)
------------>>>>>末尾一定要加分号<<<<<--------------
------------>>>>>字符串用单引号<<<<<<<--------------
------------>>>>>每个语句之后都要加上分号<<<<<------
-----------------------触发器实例-------------------
CREATE OR REPLACE TRIGGER TRIGGER_TEST
AFTER INSERT OR DELETE OR UPDATE OF ID ON TEMP_YXX_1129_1
FOR EACH ROW
  BEGIN
    IF INSERTING THEN  --插入宝座
      INSERT INTO TEMP_YXX_1129_2
      VALUES(:new.id,:new.name,100);
      DBMS_OUTPUT.put_line('插入成功');
    ELSIF UPDATING THEN   --更新操作
      UPDATE TEMP_YXX_1129_2
      SET ID = :NEW.ID
      WHERE ID = :OLD.ID;
      DBMS_OUTPUT.PUT_LINE('更新成功');
    ELSIF DELETING THEN  --删除操作
      DELETE TEMP_YXX_1129_2
      WHERE ID = :OLD.ID;
      DBMS_OUTPUT.PUT_LINE('删除成功');
    END IF;
  END;
 
--DROP TRIGGER TRIGGER_TEST