Print all even numbers from 1 to n in PL/SQL
Last Updated :
29 Jun, 2018
Prerequisite- PL/SQL Introduction
In PL/SQL code groups of commands are arranged within a block. It groups together 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 even numbers and their sum from 1 to N.
Examples:
Input: N = 3
Output: 2
Sum = 2
Input: N = 5
Output: 2, 4
Sum = 6
Approach is to initialize a number num with 2 and keep incrementing it by 2 until num is <= N.
Below is its implementation:
DECLARE
num NUMBER(3) := 2;
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 even numbers is ' || sum1);
END ;
|
Output:
2
4
Sum of even numbers is 6
Share your thoughts in the comments
Please Login to comment...