merge into t_product tp using(select t.IMAA017,t.IMAA001 from t100_product_weight t ) s on(tp.PROD_CODE = s.IMAA001) when matched then update set tp.weight = s.IMAA017;
oracle批量更新表数据(效率方法)
原文：https://www.cnblogs.com/cxw-cm/p/11755786.html
