17,377
社区成员
发帖
与我相关
我的任务
分享
select count(*) into v_number form 表B
where id=v_id --用的游标来取表A的值
and name=v_name
and newtime between v_newtime - interval '10' minute and v_newtime;
if v_number=0 then
insert into 表B values(v_id,v_name,v_newtime,v_newtime);--情况一
else
update 表B set newtime=v_newtime
where id=v_id
and name=v_name
and newtime between v_newtime - interval '10' minute and v_newtime;--情况二