oracle sql 基本操作

1 基本sql文

select  t.longitude into longitudeTemp from b_n_maplonglat t where t.sortno=i and t.maprouteid='5cd76cb9-7658-4d82-b47b-fff10148f84c';

2  赋值，循环

declare
i int;
j int;
longitudeTemp number;
latitudeTemp number;
begin 
i:=1;
j:=1078;
while i<=441 loop
select  t.longitude into longitudeTemp from b_n_maplonglat t where t.sortno=i and t.maprouteid='5cd76cb9-7658-4d82-b47b-fff10148f84c';
select  t.latitude into latitudeTemp from b_n_maplonglat t where t.sortno=i and t.maprouteid='5cd76cb9-7658-4d82-b47b-fff10148f84c';
insert into b_n_maplonglat t values (i,'5c4d76a8-92f6-4bf2-858f-9d4ee4130447',longitudeTemp,latitudeTemp,'002',j);
i:=i+1;
j:=j+1;
end loop;
end;