oracle merge的用法

weiruan85

下边是脚本：
drop table inventory;drop table shipment;create table inventory (part_no int,part_count int);insert into inventory values(1,5);create table shipment (part_no int,part_count int);insert into shipment values(1,2);select * from inventory;select * from shipment;MERGE INTO inventory    USING shipment    ON (inventory.part_no = shipment.part_no)WHEN MATCHED THEN   UPDATE SET inventory.part_count = inventory.part_count + shipment.part_countWHEN NOT MATCHED THEN   INSERT VALUES (shipment.part_no,shipment.part_count);

注意在update set后边的列如果不加表名称限制，则默认是：using 后边的表

<div class="quote_title">引用