Forum Forums Members Recent Posts Forums PL SQL Interview Questions... PLSQL Program Sum o... Share: Notifications Clear all PLSQL Program Sum of number between 1 to 100 using SQL Last Post RSS 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 Leave a reply Author NameAuthor EmailTitle * Subscribe to this topic Preview 0 Revisions Save Draft Saved Author Name * Author Email * Subscribe to this topic Reply Cancel Preview 0 Revisions Save Draft Saved Share: