Sign Up

Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

You must login to ask a question.

Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

SIKSHAPATH

SIKSHAPATH Navigation

  • Home
  • Questions
  • Blog
    • Computer Science(CSE)
    • NPTEL
    • Startup
  • Contact
  • Delivery Policy for Sikshapath
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Questions
  • Blog
    • Computer Science(CSE)
    • NPTEL
    • Startup
  • Contact
  • Delivery Policy for Sikshapath
Home/Questions/Q 710
Next
Answered
Amina
  • 2
Amina
Asked: October 19, 20212021-10-19T00:30:03+05:30 2021-10-19T00:30:03+05:30In: DBMS

Write a program in PL/SQL to check whether a number is prime or not using goto statement with for loop.

  • 2

Write a program in PL/SQL to check whether a number is prime or not using goto statement with for loop.

check whether a number is prime or not in pl/sqlgoto statementprime number in pl sqlwrite a pl/sql program to check whether the given number is prime or not
  • 1 1 Answer
  • 2k Views
  • 0 Followers
  • 0
Answer
Share
  • Facebook

    1 Answer

    • Voted
    • Oldest
    • Recent
    1. Best Answer
      Amina
      2021-10-19T00:34:14+05:30Added an answer on October 19, 2021 at 12:34 am

      declare
      n number;
      i number;
      flag number;

      begin
      i:=2;
      flag:=1;
      n:=7;

      for i in 2..n/2
      loop
      if mod(n,i)=0
      then
      flag:=0;
      exit;
      end if;
      end loop;

      if flag=1
      then
      dbms_output.put_line(‘prime’);
      else
      dbms_output.put_line(‘not prime’);
      end if;
      end;
      /

       

      Output is attached below:

      Attachment

      • -1
      • Reply
      • Share
        Share
        • Share on WhatsApp
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn

    Leave an answer
    Cancel reply

    You must login to add an answer.

    Forgot Password?

    Need An Account, Sign Up Here

    Sidebar

    Stats

    • Questions 1k
    • Answers 1k
    • Posts 138
    • Best Answers 65
    • Solution Revealed: NPTEL Programming in Java Week 1 Assignment 2023
    • NPTEL Joy of Computing Using Python Assignment Answers Week 1 2023
    • NPTEL Cloud Computing Assignment 1 Answers 2023
    • NPTEL An Introduction to Artificial Intelligence Week 1 Assignment Answers 2023
    • Ethical Hacking NPTEL Assignment 1 Answers 2023

    Popular Questions

    • I'M ADMIN

      Internshala ethical hacking final test answers: Question sequence differs but ...

      • 6 Answers
    • AK

      You have a green lottery ticket, with ints a, b, ...

      • 4 Answers
    • mj

      Solve by Gauss Elimination Method 5x+y+z+w=4 ,x+7y+z+w=12 , x+y+6z+w=-5, x+y+z+4w=-6

      • 3 Answers

    Explore

    • Recent Questions
    • Questions For You
    • Answers With Time
    • Most Visited
    • New Questions
    • Recent Questions With Time

    Footer

    Helpful Links

    • Disclaimer
    • Privacy Policy Notice
    • TERMS OF USE
    • FAQs
    • Refund/Cancellation Policy

    Follow

    © 2021-2022 Sikshapath. All Rights Reserved

    Insert/edit link

    Enter the destination URL

    Or link to existing content

      No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.