cc

摘要： 转自：http://www.cnblogs.com/xy6521/articles/1310177.htmloracle merge into 的用法详解+实例作用：merge into 解决用B表跟新A表数据，如果A表中没有，则把B表的数据插入A表；语法：MERGE INTO[your table-name] [rename your table here]USING( [write your query here] )[rename your query-sql and using just like a table]ON([conditional expression here] AND 阅读全文