Home/ Questions/Q 696
Next
In Process

SIKSHAPATH Latest Questions

Amina
  • 1
  • 1
Asked: 2021-10-19T00:20:49+05:30 In:

Write a program in PL/SQL to show the uses of nested loop.

  • 1
  • 1

Write a program in PL/SQL to show the uses of nested loop.

nested loop
Share

    1 Answer

    2. Amina
      This answer was edited. 
      DECLARE
      i number(3);
      j number(3);
      BEGIN
      i := 2;
      LOOP
      j:= 2;
      LOOP
      exit WHEN ((mod(i, j) = 0) or (j = i));
      j := j +1;
      END LOOP;
      IF (j = i ) THEN
      dbms_output.put_line(i || ' is prime ');
      END IF;
      i := i + 1;
      exit WHEN i = 40;
      END LOOP;
      END;
      /
      Attachment

    Leave an answer

    You must login to add an answer.

    Need An Account,