摘要： Oracle的merge into 语法 MERGE INTO t1 USING (SELECT id,name FROM t2) t2 ON ( t1.id=t2.id) //主键 WHEN MATCHED THEN //匹配则更新 UPDATE SET T1.name= t2.name WHEN 阅读全文