select obj_uid, gis_code, obj_detailgiscode from tmp_object
select obj_uid, gis_code, obj_detailgiscode from temp_object

--MSSQL
update temp_object set gis_code = t1.gis_code, obj_detailgiscode = t1.obj_detailgiscode
from tmp_object t1, temp_object t2
where t1.obj_uid = t2.obj_uid


--ORACLE
update temp_object t2 set (gis_code, obj_detailgiscode) = (select gis_code, obj_detailgiscode from tmp_object t1 where t1.obj_uid = t2.obj_uid)