스마트하게 일하기

같은듯 다른 MSSQL과 ORACLE의 MERGE 구문 비교 icki_base_tmp 테이블데이터를 icki_base 테이블에 merge 할 경우, 1) MSSQL merge into icki_base a using icki_base_tmp b on (a.c_no = b.c_no and a.cm_acct_no = b.cm_acct_no) when matched and a.cr_acid_no = '1' then update set ct_id_no = b.ct_id_no , cr_acid_no = b.cr_acid_no when matched and a.cr_acid_no = '2' then delete when not matched then insert (c_no, cm_acct_no, ct_id_no, ..