Print all even numbers from 1 to n in PL/SQL

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.

SQL

 -- 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;

Output:

1
3
5
Sum of all odd numbers is 9

Print all even numbers from 1 to n in PL/SQL

V

vt_m

Improve

Article Tags :

Practice Tags :

Misc

Similar Reads

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 ev

Print all the prime numbers between 'm' and '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. Problem : Write a script in PL/SQL to display all the p

Sum and average of three numbers 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 three numbers and the task is to find out the sum

Sum of the first and last digit of a number 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 find the sum of its fi

Sum of digits equal to a given number 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 and range and the task is to display all

Sum of range in a series of first odd then even natural numbers

The sequence first consists of all the odd numbers starting from 1 to n and then remaining even numbers starting 2 up to n. Let's suppose we have n as 1000. Then the sequence becomes 1 3 5 7....999 2 4 6....1000We are given a range (L, R), we need to find sum of numbers of this sequence in a given r

Sum Of Two Numbers in PL/SQL

Prerequisite - PL/SQL introductionIn 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. Here, first, we take three variables x, y, and z and ass

Find the factorial of a number in pl/sql

Given a number, your task to print the factorial of that number using pl/sql. Examples: Input : 5 Output : 120 Explanation: 5! = 5 * 4 * 3 * 2 * 1 = 120 Input : 4 Output : 24 Basic structure of pl/sql block declare -- declare all the variables begin -- for start block -- make a program here end -- f

Reduce a given number to form a key by the given operations

Given an integer N, the task is to reduce the number and form a key by following the operations given below: Extract the Most Significant Digit of the number:If the digit is even: Add the consecutive digits until the sum of digits is odd.If the digit is odd: Add the consecutive digits until the sum

Finding sum of first n natural numbers 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 positive integer n and the task is to find the