merge¸¦ ÀÌ¿ëÇؼ Áߺ¹ µ¥ÀÌÅÍ°¡ ÀÖÀ¸¸é »èÁ¦, ¾øÀ»°æ¿ì insert¸¦ ÇÏ·Á°íÇÕ´Ï´Ù
¸¶Ä§ »ç¿ëÇÏ´Â row¿¡ use_yn °°Àº Å×À̺íÀÌ ÀÖ¾î¼
merge into table...
when matched then update set
use_yn = 'D'
delete where use_yn = 'D'
....
À§¿Í °°Àº Äõ¸®¹®À» »ç¿ëÇϴϱñ »èÁ¦°¡ ¾ÈµÇ´õ¶ó±¸¿ä....
°á°ú¸¦ º¸¸é row´Â ±×´ë·Î Á¸ÀçÇÏ¸é¼ use_yn Àº D·Î ¾÷µ¥ÀÌÆ®°¡ µÇ°í commitÀÌ µË´Ï´Ù
±×·¡¼ Å×½ºÆ® »ï¾Æ Äõ¸®¸¦ ¹Ù²ãº¸¾Ò´Âµ¥
merge into table...
when matched then update set
use_yn = 'D'
delete where use_yn = 'N' -- ±âÁ¸¿¡ NÀ¸·Î µÇ¾îÀÖ´Â°É D·Î º¯°æ ÇÑ µÚ »èÁ¦ÇÏ·Á°íÇß¾úÀ½..
....
±âÁ¸¿¡ ÀÖ´ø °ªÀÎ NÀ» Á¶°ÇÀ¸·Î Áִϱñ ¿øÇϴ°ªÀÌ »èÁ¦µÇ´õ¶ó±¸¿ä
merge¿¡¼ update ÈÄ delete ÇÒ¶§ ¼ø¼°¡... ¾î¶»°ÔµÇ´ÂÁö ±Ã±ÝÇÕ´Ï´Ù...¤Ð¤Ð ±¸±Û¸µÇصµ ¸øã°Ú¾î¿ä
Á¦°¡ Å×ÀÌºí ¸¸µé°í Å×½ºÆ®ÇÏ°í ±×·² »óȲÀÌ ¸øµÇ¼ OTL
merge¿¡¼ update delete¸¦ ó¸®ÇÒ¶§ delete Á¶°ÇÀ» updateµÇ±â Àü Á¶°ÇÀ» ¹Ù¶óº¸´Â°ÇÁö..
Äõ¸®Â¯³ª¿ä ÈåÈ僉¤¡È÷ÈæÈ÷ÆR±â¤Ð¤Ð¤Ð
Áú¹® | 1038¸íÀÌ Àоú¾î¿ä. 18.119.253.93