단단이아빠의 세상

본문

update  /*+  bypass_ujvc  */
(
select
addr.ADDRCODE1  addrADDRCODE1,
addr.ADDRCODE2  addrADDRCODE2,
addr.ADDRCITY  addrADDRCITY,
kd.ADDRCODE1  kdADDRCODE1,
kd.ADDRCODE2  kdADDRCODE2,
kd.ADDRCITY  kdADDRCITY

from KAPA_APPR_DATA kd,ADDRESS_INFO addr
where
kd.ADDRGU=addr.ADDRGU and kd.ADDRDONG=addr.ADDRDONG and kd.ADDRRI is null and addr.ADDRRI is null

)
set
kdADDRCODE1=addrADDRCODE1,
kdADDRCODE2=addrADDRCODE2,
kdADDRCITY=addrADDRCITY