创建一张表:
CREATE TABLE tbl_1 (col1 number(10),col2 number(10));
实现判断有就更新,没有就插入方法:
merge INTO tbl_1 t1
USING (SELECT :col1 col1,:col2 col2 FROM dual ) t2
ON (t1.col1 = t2.col1)
when matched THEN
UPDATE SET t1.col2 = t2.col2
when NOT matched THEN
INSERT (t1.col1,t1.col2) VALUES(t2.col1,t2.col2);
应用举例:
merge INTO tbl_1 t1
USING (SELECT 1 col1,2 col2 FROM dual ) t2
ON (t1.col1 = t2.col1)
when matched THEN
UPDATE SET t1.col2 = t2.col2
when NOT matched THEN
INSERT (t1.col1,t1.col2) VALUES(t2.col1,t2.col2);
CREATE TABLE tbl_1 (col1 number(10),col2 number(10));
实现判断有就更新,没有就插入方法:
merge INTO tbl_1 t1
USING (SELECT :col1 col1,:col2 col2 FROM dual ) t2
ON (t1.col1 = t2.col1)
when matched THEN
UPDATE SET t1.col2 = t2.col2
when NOT matched THEN
INSERT (t1.col1,t1.col2) VALUES(t2.col1,t2.col2);
应用举例:
merge INTO tbl_1 t1
USING (SELECT 1 col1,2 col2 FROM dual ) t2
ON (t1.col1 = t2.col1)
when matched THEN
UPDATE SET t1.col2 = t2.col2
when NOT matched THEN
INSERT (t1.col1,t1.col2) VALUES(t2.col1,t2.col2);