by Nathan
MERGE INTO 구문
12345678910111213141516171819202122232425262728MERGE 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..
Programming/SQL
2018. 8. 20. 10:13