BEGIN INSERT INTO B(N1,N2) SELECT A.N1,A.N2 FROM A WHERE A.N1 IS NOT NULL END; 首次写,不知道对不对,请大伙指教
用merge into来做,简单高效
http://www.eygle.com/digest/2009/01/merge_into_insertupdate.html merge into 用法~
MERGE INTO TABLE_B A USING TABLE_A B ON (A.N1 = B.N1 AND A.N2 = B.N2) WHEN MATCHED THEN UPDATE SET A.N1 = B.N1, A.N2 = B.N2 WHEN NOT MATCHED THEN INSERT (N1, N2) VALUES (B.N1, B.N2)
INSERT INTO B(N1,N2) SELECT A.N1,A.N2 FROM A WHERE A.N1 IS NOT NULL
END;
首次写,不知道对不对,请大伙指教
merge into 用法~
USING TABLE_A B
ON (A.N1 = B.N1 AND A.N2 = B.N2)
WHEN MATCHED THEN
UPDATE SET A.N1 = B.N1, A.N2 = B.N2
WHEN NOT MATCHED THEN
INSERT (N1, N2) VALUES (B.N1, B.N2)