Skip to content
Related Articles

Related Articles

Prime number in PL/SQL
  • Last Updated : 15 May, 2018


Prerequisite – PL/SQL introduction

A 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 declare part, we declare variables and between begin and end part, we perform the operations.

Examples:

Input :  5
Output : true

Input : 10
Output : false

Below is the required implementation:




declare
    
-- declare variable n, i 
-- and temp of datatype number
n number;             
i number;            
temp number;        
    
begin
    
-- Here we Assigning 10 into n
n := 13;                 
    
-- Assigning 2 to i
i := 2; 
   
-- Assigning 1 to temp
temp := 1; 
   
-- loop from i = 2 to n/2
  for i in 2..n/2
    loop
        if mod(n, i) = 0
        then
            temp := 0;
            exit;
        end if;
    end loop;
    
    if temp = 1
    then
        dbms_output.put_line('true');
    else
        dbms_output.put_line('false');
    end if;
end;          
  
-- Program End

Output:

true

Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up
Recommended Articles
Page :