Print all even numbers from 1 to n in PL/SQL
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:
-- Display all even number from 1 to n DECLARE -- Declare variable num num NUMBER(3) := 2; sum1 NUMBER(4) := 0; BEGIN WHILE num <= 5 LOOP -- Display even number dbms_output.Put_line(num); -- Sum of even numbers sum1 := sum1 + num; -- Next even number num := num + 2; -- End loop END LOOP; -- Display even number dbms_output.Put_line( 'Sum of even numbers is ' || sum1); END ; |
Output:
2 4 Sum of even numbers is 6