merge into 사용법

신규데이터는 입력하고 조건에 맞는 데이터가 있으면 업데이트 하는 구문

MERGE INTO 테이블명  별칭

USING 대상테이블/뷰  별칭

ON 조인조건

WHEN MATCHED THEN

  UPDATE SET

   컬럼1=값1

   컬럼2=값2

WHEN NOT MATCHED THEN

  INSERT (컬럼1,컬럼2,...)

       VALUES(값1,값2,...);

MERGE INTO G_PERSON USING DUAL ON

(

ORGANIZATION_IDENTIFIER = #{organization_identifier} AND

NAME = #{name} AND

PHONE_NUMBER = #{phone_number} AND

BIRTH_DATE = #{birth_date} AND

GENDER = #{gender} AND

GROUP_KIND = #{group_kind} AND

CHECKUP_DATE = #{checkup_date}

)

WHEN NOT MATCHED THEN

INSERT

(

ORGANIZATION_IDENTIFIER,

NAME,

PHONE_NUMBER,

BIRTH_DATE,

GENDER,

GROUP_KIND,

CHECKUP_DATE

)

VALUES

(

#{organization_identifier},

#{name},

#{phone_number},

#{birth_date},

#{gender},

#{group_kind},

#{checkup_date}

)