代码如下
create table tbo(
id number(10),
name VARCHAR2(20) NOT NULL
)
MERGE INTO tbo t
USING (SELECT id FROM tbo WHERE id=1) hs
ON (t.id = hs.id)
WHEN MATCHED THEN UPDATE SET t.name='anne'
WHEN NOT MATCHED THEN INSERT VALUES(1,'anne');
代码如下
create table tbo(
id number(10),
name VARCHAR2(20) NOT NULL
)
MERGE INTO tbo t
USING (SELECT id FROM tbo WHERE id=1) hs
ON (t.id = hs.id)
WHEN MATCHED THEN UPDATE SET t.name='anne'
WHEN NOT MATCHED THEN INSERT VALUES(1,'anne');