개발새발

이미 존재하는 값은 update 신규로 입력된 값은 insert 일명 upsert 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 MERGE INTO CUSTOMER C USING ( SELECT USERNO , USERNAME , ADDRESS , PHONE FROM NEW_JOIN WHERE INPUT_DATE = '20170724' ) N ON ( C.USERNO = N.USERNO) WHEN MATCHED THEN UPDATE SET C.USERNAME = N.USERNAME , C.ADDRESS = N.ADDRESS , C.PHONE = N.PHONE WHEN NOT MATCHED THEN INSERT ( US..