merge into component_cost t
using temp1 t1
on (t.component_code = t1.combine_code)
when matched then
update set component_cost.component_cost = temp1.combine_cost;
适合大量数据的修改,很节省时间的操作
merge into component_cost t
using temp1 t1
on (t.component_code = t1.combine_code)
when matched then
update set component_cost.component_cost = temp1.combine_cost;
适合大量数据的修改,很节省时间的操作