PL/SQL Program for Prime Number

Here you will get a pl/sql program for prime number.

A number is a prime number if it is divisible by 1 or itself. For example 2, 3, 5, 7, etc are prime numbers.

While numbers like 4, 6, 8, etc are not prime.

 

PL/SQL Program for Prime Number

 

Output

Enter value for n: 12
old 9: n:=&n;
new 9: n:=12;
not prime

12 thoughts on “PL/SQL Program for Prime Number

  1. Sairam

    Hii …we want full pl/SQL programme’s if don’t mine it will we send to my site.

    Reply
    1. Gunjan

      if half of the values of n does not give remainder 0 then the higher values preceding n/2 will also not give reminder zero and it also improves performance of the code as you are executing the condition for half of the length.
      hope u got it.

      Reply
  2. Venkat

    Wont work if input is 2 . For input 2 it will show not a prime.

    Reply
  3. nitu

    i need a program to print sum of first 10 prime numbers in pl/sql.

    Reply
  4. amarnath .d

    hai Neeraj Mishra you are doing a grate job i like your programming .but i have one doubt in prime number program by plsql .why we take n/2 to in mod function could you please explain this.except this i have understood all you programs. please reply to me .

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *