两个表数据的合并(涉及到大量的数据)

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;

适合大量数据的修改，很节省时间的操作