http://www.cnblogs.com/dongsheng/p/4384754.html
--增量数据变化,利用merge into--如果防止某天的同步失败,应该控制 lastmodifiedtime是2天,这样可以覆盖一部分的重复,以防止某种-
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);