存储过程
create or replace procedure upbuslocation(mindex number,longitude number,latitude number,angle
number,speed number,time date) is
begin
declare num number;
begin
select count(*) into num from d_buslocation where Mindex=mindex;
if num>0 then
update d_buslocation set Longitude=longitude,Latitude=latitude,Speed=speed,
Angle=angle,Time=time where Mindex=mindex;
else
insert into d_buslocation(mindex,longitude,latitude,speed,angle,time) values(mindex,longitude,latitude,speed,angle,time);
end if;
insert into d_buslocation_his(mindex,longitude,latitude,speed,angle,time) values(mindex,longitude,latitude,speed,angle,time);
end;
end upbuslocation;调用语句
exec upbuslocation (19247,6765506,1705205,13,2,to_date('2010-1-28 12:59:56','yyyy/mm/dd hh24:mi:ss'))
create or replace procedure upbuslocation(mindex number,longitude number,latitude number,angle
number,speed number,time date) is
begin
declare num number;
begin
select count(*) into num from d_buslocation where Mindex=mindex;
if num>0 then
update d_buslocation set Longitude=longitude,Latitude=latitude,Speed=speed,
Angle=angle,Time=time where Mindex=mindex;
else
insert into d_buslocation(mindex,longitude,latitude,speed,angle,time) values(mindex,longitude,latitude,speed,angle,time);
end if;
insert into d_buslocation_his(mindex,longitude,latitude,speed,angle,time) values(mindex,longitude,latitude,speed,angle,time);
end;
end upbuslocation;调用语句
exec upbuslocation (19247,6765506,1705205,13,2,to_date('2010-1-28 12:59:56','yyyy/mm/dd hh24:mi:ss'))
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货