update 批量修改优化示例
Update语句优化:(需要进行大批量的Update操作时可能会导致等待操作超时)*注意最后需分号
MERGE INTO table_name alias1 //执行update的表名 USING (table|view|sub_query) alias2 //插入的数据 ON (join condition) //插入的条件 WHEN MATCHED THEN UPDATE SET col1 = col1_val1, //设置数据 col2 = col2_val2 WHEN NOT MATCHED THEN INSERT (column_list) VALUES (column_values); //新增数据
例: MERGE INTO PPVTracker PPV1 USING (select * from PPVTrackerBudget) PPV2 ON (PPV1.NO=PPV2.NO) WHEN MATCHED THEN UPDATE SET PPV1.JanQty_B=PPV2.JanQty_B, ... ,PPV1.AllSaving_B=PPV2.AllSaving_B;