oracle merge into using 实例

匹配有update，无insert

MERGE INTO vip_info AUSING(select cid, vip_level, create_time from vip_info_temp) BON (a.cid = b.cid)WHEN MATCHED THEN     UPDATE        SET a.vip_level = b.vip_level,        a.create_time = b.create_time WHEN NOT MATCHED THEN    INSERT (cid, vip_level, create_time)    VALUES (b.cid, b.vip_level, b.create_time);commit;