MERGE
MERGE INTO TEDUM300 TT USING (SELECT UNIV_ID , MNG_NO , UNIV_CD , KOR_UNIV_NM , AEA_CD , PRDNT_NM , ZIP_CODE , ADDR , TEL_NO , FAX_NO , UNIV_SET FROM TEDUM301) ST ON (TT.UNIV_ID = ST.UNIV_ID AND TT.UNIV_CD = ST.UNIV_CD) WHEN MATCHED THEN -- 존재하면 UPDATE UPDATE SET TT.MNG_NO = ST.MNG_NO , TT.KOR_UNIV_NM = ST.KOR_UNIV_NM , TT.AEA_CD = ST.AEA_CD , TT.PRDNT_NM = ST.PRDNT_NM , TT.ZIP_CODE = ST.ZIP_COD..
더보기