update RMS_TRANSCIR_USER usr
set usr.SOURCE_NE=
(
select ne.OLD_NAME from RMS_TRANSNE ne
where usr.remark=substr(ne.OLD_NAME,1,instr(ne.OLD_NAME,'-',1)-1)
and rownum=1
)
where exists
(
select 1 from RMS_TRANSNE ne
where usr.remark=substr(ne.OLD_NAME,1,instr(ne.OLD_NAME,'-',1)-1)
)
usr中的source_ne 根据remark中同Ne表中进行对比,因为ne的old_name 并不唯一,所以要加rownum=1
可否在赋值select ne.OLD_NAME from RMS_TRANSNE ne里面直接用 distinct取单一?数据太多了,如果truncate后再来又得半天