Prime number in PL/SQL
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:
SQL
declare -- declare variable n, i -- and temp of datatype number n number; i number; temp number; begin -- Here we Assigning 13 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