oracle如何判断奇数偶数_plsql实现1..100累加、奇数之和、偶数之和

--1..100累加

create or replace procedure jj

(

v_result out number

)

as

i number:=1;

begin

v_result:=0;

while i <101

loop

v_result:=v_result+i;

i:=i+1;

end loop;

end jj;

--1..100奇数之和

create or replace procedure jj

(

v_result out number

)

as

i number:=1;

begin

v_result:=0;

while i <101

loop

v_result:=v_result+i;

i:=i+2;

end loop;

end jj;

--1..100偶数之和

create or replace procedure jj

(

v_result out number

)

as

i number:=0;

begin

v_result:=0;

while i <101

loop

v_result:=v_result+i;

i:=i+2;

end loop;

end jj;