oracle 二表做差,oracle二表更新

–oracle

update stockm

set stockm.current_cost=(select erpcost from aes_calist where TRIM(aes_calist.wh)=TRIM(stockm.WAREHOUSE) and TRIM(aes_calist.product)=TRIM(stockm.product))

where trim(stockm.product) in (select aes_calist.product from aes_calist)

and trim(stockm.WAREHOUSE) in (select aes_calist.wh from aes_calist)

–sqlserver

update lwj_temp_card

set 新售价=b.rtlprc

from lwj_temp_card a,goods b

where a.商品编号=b.code

–oracledeclare cursor cc is select wh,product,erpcost from aes_calist;begin for my in cc loopupdate stockmset stockm.current_cost=my.erpcostwhere  TRIM(stockm.WAREHOUSE)=TRIM(my.wh)and TRIM(stockm.product)=TRIM(my.product);end loop;end ;