--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
--oracle
declare
cursor cc is select wh,product,erpcost from aes_calist;
begin
for my in cc loop
update stockm
set stockm.current_cost=my.erpcost
where TRIM(stockm.WAREHOUSE)=TRIM(my.wh)
and TRIM(stockm.product)=TRIM(my.product);
end loop;
end ;