Q. Write a PL/SQL block to check weather a given number is Prime or not.
Answer:
Prime number: It is a natural number greater than 1 and has no positive divisor other than 1 and itself.
For Example:
5 is prime number because, number 5 has 1 and 5 are only positive integer factors.
The following program will check weather a given number is prime or not.
Output:
Answer:
Prime number: It is a natural number greater than 1 and has no positive divisor other than 1 and itself.
For Example:
5 is prime number because, number 5 has 1 and 5 are only positive integer factors.
The following program will check weather a given number is prime or not.
declare
num number;
i number:=1;
c number:=0;
begin
num:=#
for i in 1..num
loop
if((mod(num,i))=0)
then
c:=c+1;
end if;
end loop;
if(c>2)
then
dbms_output.put_line(num||' not a prime');
else
dbms_output.put_line(num||' is prime');
end if;
end;
/
Output:
