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