Saturday 30 April 2016

plsql code for sum of odd number using for loop

declare
        n number;
        sum1 number default 0;
        endvalue number;
begin
        endvalue:=&endvalue;
        n:=1;
        for n in 1.. endvalue
        loop
             if mod(n,2)=1
             then
                  sum1:=sum1+n;
             end if
        end loop;
        dbms_output.put_line('sum = ' || sum1);
end;

No comments:

Post a Comment