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');
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024