CREATE TABLE aa(ID NUMBER, NAME VARCHAR2(20)); CREATE TABLE mm (ID NUMBER, NAME VARCHAR2(20));INSERT INTO mm VALUES (1, 'A');
INSERT INTO mm VALUES (1, 'B');
INSERT INTO mm VALUES (1, 'A');
INSERT INTO mm VALUES (1, 'B');
MERGE INTO aa A
USING mm B
ON(A.ID=B.ID)
WHEN MATCHED THEN
UPDATE SET A.NAME = B.NAME
WHEN NOT MATCHED THEN
INSERT VALUES(B.ID, B.NAME); 如不可以用merge,求多条数据插入或更新另一个表的办法
高手来!~~~
INSERT INTO mm VALUES (1, 'B');
INSERT INTO mm VALUES (1, 'A');
INSERT INTO mm VALUES (1, 'B');
MERGE INTO aa A
USING mm B
ON(A.ID=B.ID)
WHEN MATCHED THEN
UPDATE SET A.NAME = B.NAME
WHEN NOT MATCHED THEN
INSERT VALUES(B.ID, B.NAME); 如不可以用merge,求多条数据插入或更新另一个表的办法
高手来!~~~
using (select id, name from mm group by id,name) b
using (select id, max(name) as name from mm group by id) b
或者
using (select id, min(name) as name from mm group by id) b只取一个值