|
|
[ÀϹÝ] multi join update |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 121.¢½.39.7 |
ÀÐÀ½:3244 |
|
|
bypass_ujvc(bypass update join view constraints) ÈùÆ®¸¦ »ç¿ëÇÏ¸é µË´Ï´Ù.
update /*+ bypass_ujvc */
(select a.edu_code as a_edu_code, a.st_code as a_st_code, b.edu_code as b_edu_code, b.st_code as b_st_code from tgcodemapptt a, temp_kedi_code b where a.sch_code=b.sch_code and a.school_name = b.school_name)
set a_edu_code = b_edu_code, a_st_code = b_st_code
;
´Ü, ½ÇÇà¿¡ ¾Õ¼ ¹Ì¸® ¾Ë°í ÀÖ¾î¾ß ÇÒ ³»¿ëÀÌ ÀÖ½À´Ï´Ù.
¸¸¾à A¿Í B Å×À̺íÀÌ 1:M ȤÀº N:MÀÇ °ü°è¶ó¸é A Å×À̺íÀº ù¹ø° ³ªÅ¸³ ROW¸¦ ±âÁØÀ¸·Î °»½ÅµË´Ï´Ù.
ÀÌ ºÎºÐÀ» »ç¿ëÀÚ°¡ ¿øÇϴ´ë·Î ÁöÁ¤ÇÏ·Á¸é Á¶°ÇÀ» º¯°æÇϰųª, DISTINCT, MAX µîÀÇ ÇÔ¼ö¸¦ ÀÌ¿ëÇØ
Á¶È¸°ªÀÇ ´ëÇ¥¼ºÀ» È®º¸ÇØ ÁÖ¾î¾ß ÇÕ´Ï´Ù.
¼ö°íÇϼ¼¿ä~~
|
|
|
|