trigger

--트리거 생성

CREATE OR REPLACE TRIGGER ATEST_TRIGGER

BEFORE INSERT OR UPDATE OR DELETE ON ATEST

REFERENCING OLD AS O NEW AS N

FOR EACH ROW

DECLARE

BEGIN

    IF INSERTING THEN

        INSERT INTO ATEST_LOG

            (SEQ, TITLE, NOTE, USE_YN, REG_TS, MOD_TS, LOG_TS, LOG_TYPE)

        VALUES

            (:O.SEQ, :O.TITLE, :O.NOTE, :O.USE_YN, :O.REG_TS, :O.MOD_TS, SYSTIMESTAMP, 'I');

    END IF;

    IF UPDATING THEN

        INSERT INTO ATEST_LOG

            (SEQ, TITLE, NOTE, USE_YN, REG_TS, MOD_TS, LOG_TS, LOG_TYPE)

        VALUES

            (:O.SEQ, :O.TITLE, :O.NOTE, :O.USE_YN, :O.REG_TS, :O.MOD_TS, SYSTIMESTAMP, 'U');

    END IF;

    IF DELETING THEN

        INSERT INTO ATEST_LOG

            (SEQ, TITLE, NOTE, USE_YN, REG_TS, MOD_TS, LOG_TS, LOG_TYPE)

        VALUES

            (:O.SEQ, :O.TITLE, :O.NOTE, :O.USE_YN, :O.REG_TS, :O.MOD_TS, SYSTIMESTAMP, 'D');

    END IF;

END;

--트리거 삭제

DROP TRIGGER ATEST_TRIGGER;

--트리거 활성

ALTER TRIGGER ATEST_TRIGGER ENABLE;

--트리거 비활성

ALTER TRIGGER ATEST_TRIGGER DISABLE;