[Oracle] Trigger 생성

CREATE OR REPLACE TRIGGER TG_ATEST_B_UD

BEFORE UPDATE OR DELETE ON ATEST

REFERENCING OLD AS O NEW AS N

FOR EACH ROW

DECLARE

    V_LOG_TYPE CHAR(1);

BEGIN

    IF UPDATING THEN V_LOG_TYPE := 'U'; END IF;

    IF DELETING THEN V_LOG_TYPE := 'D'; END IF;

    INSERT INTO ATEST_HIST

    (

          SEQ

        , TITLE

        , CONTENT

        , LOG_TS

        , LOG_TYPE

    )

    VALUES

    (

          :O.SEQ

        , :O.TITLE

        , :O.CONTENT

        , SYSTIMESTAMP

        , V_LOG_TYPE

    );

END;