17,377
社区成员
发帖
与我相关
我的任务
分享
select count(1) INTO l_n from NAMESTU where id=222
if l_n>0 then
update NAMESTU set NAGE=0 where id=222
else
insert into NAMESTU (....) values(....)
end if
merge into namestu a
using dual
on (a.id = 222)
when matched then
update set a.nage = 0
when not matched then
insert values(222,value2......)