PLSQL Program Sum of number between 1 to 100 using SQL

Last Post

Posts: 18

jeevan 123

Topic starter

Apr 16, 2022 10:38 am

(@jeevan303500)

Active Member

Joined: 2 years ago

How to get sum of number between 1 to 100

Here you go..

Declare

a number;

sum_of number :=0;

Begin

a:=1;

loop

sum_of:=sum_of+a;

exit when (a=100);

a:=a+1;

end loop;

dbms_output.put_line('Sum between 1 to 100 is '||sum_of);

End;

This topic was modified 1 year ago 2 times by SQL Admin