PROCEDURE MERGE 문사용 법2

<procedure id="crdtorSttlAccNoSync" parameterClass="map">

BEGIN

MERGE INTO (

SELECT STTL_BK_CD,

STTL_ACC_NO

 FROM ACT_RESL_CRDTOR

WHERE RESL_NO = #RESL_NO#

) A

USING (

SELECT COMM_CD,

BK_CD,

BK_ACC_NO

 FROM ACT_STD_MGT

WHERE COMM_CD = '20-50'

) B

  ON (

1=1

)

WHEN MATCHED THEN

UPDATE

  SET A.STTL_BK_CD = B.BK_CD,

A.STTL_ACC_NO = B.BK_ACC_NO;

END;

</procedure>