数据库:TEST
CREATE TABLE TEST(
ID NUMBER NOT NULL,
NAME VARCHAR2(30) NOT NULL,
SEX VARCHAR2(2) DEFAULT '男'
)
插入两条数据:
INSERT INTO TEST VALUES(1,'SUNZHENXING','男')
INSERT INTO TEST VALUES(2,'SUNHAILONG','女')
MERGE语句:
MERGE INTO TEST A USING TEST B
ON (A.NAME=B.NAME)
WHEN MATCHED THEN
UPDATE SET A.SEX='女'WHERE A.NAME='SUNZHENXING'
WHEN NOT MATCHED THEN
INSERT VALUES (3,'SUNZHENXING','女')
需要注意的是:MERGE语句中的UPDATE语句和INSERT语句和一般的SQL语句格式有点不同