merge 문 문법

 

MERGE INTO 테이블명 target
USING DUAL ON (
            컬럼01 = 변수
    AND 컬럼02 = 변수
)
WHEN MATCHED THEN
UPDATE SET
~~
WHEN NOT MATCHED THEN
INSERT (
~~
) VALUES (
~~
)

 

 

 

Merge into table_t target_alias

using

(

  select

        .....

  from ....

  ....

) source_alias

on          --조건 기술절

(

     target_alias.c = source_alias.c

and .....

)

when Matched Then

Update Set target_alias.c1 = source_alias.c1,

   .....

When Not Matched Then

Insert ( c1,c2,c3.....) values ( source_alias.c1,source_alias.c2,source_alias.c3......)