Print all odd numbers and their sum from 1 to n in PL/SQL
Prerequisite – PL/SQL introduction
In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare part, we declare variables and between begin and end part, we perform the operations.
Given a number N, the task is to display all the odd numbers from 1 to N and their sum.
Examples:
Input: 3
Output: 1, 3
Input: 5
Output: 1, 3, 5
Approach is to initialize a num with 1 and sum with 0 and keep incrementing num by 2 and sum by num until num <= N.
DECLARE
num NUMBER(3) := 1;
sum1 NUMBER(4) := 0;
BEGIN
WHILE num <= 5 LOOP
dbms_output.Put_line(num);
sum1 := sum1 + num;
num := num + 2;
END LOOP;
dbms_output.Put_line( 'Sum of all odd numbers is ' || sum1);
END ;
|
Output:
1
3
5
Sum of all odd numbers is 9
Last Updated :
02 Jul, 2018
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...