CREATE OR REPLACE TRIGGER TR_MC_MEMBER
AFTER UPDATE ON MC_MEMBER
FOR EACH ROW
DECLARE conts VARCHAR(500) := '';
BEGIN
IF NVL(:OLD.EMAIL, 'x') != NVL(:NEW.EMAIL, 'x') THEN
conts := conts || '<p>이메일 : ' || :NEW.EMAIL || '</p>';
END IF;
IF NVL(:OLD.MEMBER_PW, 'x') != NVL(:NEW.MEMBER_PW, 'x') THEN
conts := conts || '<p>패스워드 변경</p>';
END IF;
IF length(conts) > 1 THEN
INSERT INTO MC_MEMBER_HISTORY(
SEQ, MEMBER_ID, MEMBER_NM, CONTS, MOD_ID, MOD_NM, MOD_DT, MOD_IP
) VALUES(
SEQ_MC_MEMBER_HISTORY.NEXTVAL, :NEW.MEMBER_ID, :NEW.MEMBER_NM, conts, :NEW.MOD_ID, :NEW.MOD_NM, :NEW.MOD_DT, :NEW.MOD_IP
);
END IF;
END TR_MC_MEMBER;
이와같은 오라클 트리거를
큐브리드에서 어떻게 변경해야할까요?