摘要:
转自: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 阅读全文