업데이트 시 간단한 오라라클 트리거 만들기

CREATE OR REPLACE TRIGGER GWANAK.DEVICE_TRIGER
AFTER UPDATE
ON GWANAK.AA1
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
    IF INSERTING THEN
        -- when insert
        INSERT INTO AA1_T
        ( t1,no1, t2, t3, t4, t5)
        VALUES
        ('INSERT',:NEW.no1, :NEW.t2, :NEW.t3, :NEW.t4,:NEW.t5);
       
    ELSIF UPDATING THEN
        -- when update
        INSERT INTO AA1_T
      ( t1,no1, t2, t3, t4, t5)
        VALUES
        ('update',:NEW.no1, :NEW.t2, :NEW.t3, :NEW.t4,:NEW.t5);
       
    ELSIF DELETING THEN
        -- when delete
        INSERT INTO AA1_T
        ( t1,no1, t2, t3, t4, t5)
        VALUES
        ('DELETE',:NEW.no1, :NEW.t2, :NEW.t3, :NEW.t4,:NEW.t5);
    END IF;
END;
/