Question

ORACLE数据库有数据就更新没有就插入怎么做？

if 1>0
then
insert into TEST (ID,NAME) VALUES (1,'AA')
else
update TEST set NAME='BB' where ID=1
end if

这么写不可以吗？总是报错！用MERGER如何写？

Answer 1

1,
if 1>0
then
insert into TEST (ID,NAME) VALUES (1,'AA');
else
update TEST set NAME='BB' where ID=1;
end if

2.
begin
update TEST set NAME='BB' where ID=1;

if sql%notfound then
insert into TEST (ID,NAME) VALUES (1,'AA');
end if;
end;

3.MERGER into TEST a using (select * from TEST) b on (a.id = b.id) when matched then
update TEST set NAME='BB'
when not matched then
nsert into TEST (ID,NAME) VALUES (1,'AA');