MERGE INTO 구문

MERGE INTO TB_ABCDE a
    USING ( SELECT   #{aaa}  AS AAA
                   , #{bbb}  AS BBB
              FROM DUAL
          ) indata  ON ( a.AAA = indata.AAA
                    AND  a.BBB = indata.BBB )
    WHEN NOT MATCHED THEN
         INSERT (   AAA
                  , BBB
                  , CCC
                  , DDD
                  , EEE
                  , REGDATE
                  , MODDATE )
         VALUES (   #{aaa}          
                  , #{bbb}
                  , #{ccc}
                  , #{ddd}
                  , #{eee}
                  , TO_CHAR(SYSTIMESTAMP,'yyyymmddhh24miss')
                  , TO_CHAR(SYSTIMESTAMP,'yyyymmddhh24miss') )
    WHEN MATCHED THEN
          UPDATE
             SET   BBB = #{bbb}
                  ,CCC = #{ccc}
                  ,DDD = #{ddd}
                  ,EEE = #{eee}
                  ,MODDATE = TO_CHAR(SYSTIMESTAMP,'yyyymmddhh24miss')