업데이트 시 간단한 오라라클 트리거 만들기
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..
더보기