Update table1 A Set je1=(select je2 from table table2 where bm2=A.bm1 and rownum=1)
或者
Update table1 A Set je1=Nvl((select je2 from table table2 where bm2=A.bm1 and rownum=1),je1)数据量在十万级以下比较快.
或者
Update table1 A Set je1=Nvl((select je2 from table table2 where bm2=A.bm1 and rownum=1),je1)数据量在十万级以下比较快.
commit ;
set je1 = (select je2 from table2 where bm1 = bm2)
where exists ( select 1 from b where a.a_id=b.a_id);
commit ;
用 w_tsinghua() 的不成功