trigger

CREATE OR REPLACE TRIGGER APLUSORA.NEWYN_UPDATE_TRG01 AFTER UPDATE OF CONFIRM5 ON APLUSORA.CUSTOMER FOR EACH ROW BEGIN if :NEW.CONFIRM5 = 'N' then -- CONFIRM5 ='N'일 경우만 UPDATE APLUSORA.NEWS_CUST SET NEWS_YN = 'N' WHERE EMAIL = :NEW.EMAIL AND NEWS_YN = 'Y'; UPDATE APLUSORA.FAIR_CUSTOMER SET NEWS_YN = 'N' WHERE FC_EMAIL = :NEW.EMAIL AND NEWS_YN = 'Y'; INSERT INTO NEWYN_UPDATE_TRG01_LOG (EMAIL, CON..

CREATE OR REPLACE TRIGGER EMS_MAILQUEUE_DELETE_TRIGGER BEFORE DELETE ON EMS_MAILQUEUE FOR EACH ROW BEGIN INSERT INTO EMS_MAILQUEUE_BACK ( MASTER_SEQ, CIS_TF_KEY, MAIL_CODE, TO_ID, TO_NAME, TO_EMAIL, FROM_NAME, FROM_EMAIL, REPLY_EMAIL, SUBJECT, REQ_DATE, TARGET_FLAG, TARGET_DATE, REG_DATE, MAP1, MAP2, MAP3, MAP4, MAP5, MAP6, MAP7, MAP8, MAP9, MAP10, SECURE_PWD, FILE_SEQ, CIS_SEND_FLAG, CIS_FLAG) ..

이번 *****증권 업체를 맡아서 TRIGGER를 한번 해봤다. - 고객테이블에 데이터 변경이 일어나면 무조건, -- 바뀌기전 데이터와 바뀐후 데이터를, 기록테이블에 저장하는 트리거 CREATE TRIGGER SMSAUTO_LIST_03_INSERT_TRIGGER ON SMSAUTO_LIST_03 AFTER INSERT AS -- SMSAUTO_LIST_03 테이블에 INSERT가 일어나면 -- 이를 NVECARESENDLOG 테이블에 같은 값을 삽입한다. INSERT INTO NVECARESENDLOG(RESULT_SEQ, CUSTOMER_KEY, CUSTOMER_NM, CUSTOMER_EMAIL, ERROR_CD) SELECT RESULT_SEQ, MEMBER_ID AS CUSTOMER_KEY, TO..