Related Articles

Related Articles

Print all odd numbers and their sum from 1 to n in PL/SQL
  • Last Updated : 02 Jul, 2018

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.

filter_none

edit
close

play_arrow

link
brightness_4
code

-- display all odd number from 1 to n
DECLARE
    -- declare variable num
    num NUMBER(3) := 1;
    sum1 NUMBER(4) := 0;
BEGIN
    WHILE num <= 5 LOOP
        -- display odd number
        dbms_output.Put_line(num);
  
        -- the sum of all odd numbers
         sum1 := sum1 + num;
  
        --next odd number
        num := num + 2;
  
    -- end  loop
    END LOOP;
dbms_output.Put_line('Sum of all odd numbers is '|| sum1);
END;  

chevron_right


Output:

1
3
5
Sum of all odd numbers is 9
My Personal Notes arrow_drop_up
Recommended Articles
Page :