Merge Into 语句代替Insert/Update在Oracle中的应用实战
MERGE INTO T T1
USING (SELECT '1001' AS a,2 AS b FROM dual) T2
ON ( T1.a=T2.a)
WHEN MATCHED THEN
UPDATE SET T1.b = T2.b
WHEN NOT MATCHED THEN
INSERT (a,b) VALUES(T2.a,T2.b);
引用:http://blog.csdn.net/bruesz/archive/2007/11/20/1894836.aspx
千人.NET交流群:18362376,因为有你,代码变得更简单,加群请输入cnblogs