Print all the prime numbers between 'm' and 'n' in PL/SQL

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:

SQL

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

Print all the prime numbers between 'm' and 'n' in PL/SQL

V

vt_m

Improve

Article Tags :

Practice Tags :

Misc

Similar Reads

Print all odd numbers and their sum from 1 to 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. Given a number N, the task is to display all the odd nu

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

How to Print Prime Numbers in MS SQL Server?

In this article, we are going to print Prime numbers using MS SQL. Here we will be using 2 while loops statement for printing prime numbers. Steps 1: First we will DECLARE a variable I with initial value 2. Query: DECLARE @I INT=2Step 2: Then we will DECLARE a variable PRIME with an initial value of

Prime number in PL/SQL

Prerequisite â€“ PL/SQL introductionA prime number is a whole number greater than 1, which is only divisible by 1 and itself. First few prime numbers are : 2 3 5 7 11 13 17 19 23 â€¦..In PL/SQL code groups of commands are arranged within a block. A block group-related declarations or statements.Â In decl

Greatest number among three given 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.Given three numbers and the task is to find greatest amon

Program for Fibonacci numbers in PL/SQL

The Fibonacci numbers are the numbers in the following integer sequence. 0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, â€¦â€¦.. In mathematical terms, the sequence Fn of Fibonacci numbers is defined by the recurrence relation Fn = Fn-1 + Fn-1 with seed values F0= 0 and F1 = 1. Given a number n, print n-

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

Convert the given numbers into words 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 task is to convert each digit of the

SQL Query to Get Only Numbers From a String

As we know in an SQL database we can insert any type of data. Sometimes in the productions server, the data gets corrupted by two or more rows being merged and being saved in a column. In that case, we can extract the numeric part from that string and save it again. So in this article, we will learn

Kth smallest even number in range L to R

Given two variables L and R, indicating a range of integers from L to R inclusive, and a number K, the task is to find Kth smallest even number. If K is greater than a number of even numbers in the range L to R then return -1. LLONG_MIN <= L <= R <= LLONG_MAX. Examples: Input: L = 3, R = 9,