# 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

Attention reader! Don’t stop learning now. Learn SQL for interviews using **SQL Course**** **by GeeksforGeeks.