Q:

Write a program in PL/SQL using loop with CONTINUE statement

0

Write a program in PL/SQL using loop with CONTINUE statement.

All Answers

need an explanation for this answer? contact us directly to get an explanation for this answer

PL/SQL Code:

DECLARE
  n NUMBER := 0;
BEGIN
  LOOP 
    DBMS_OUTPUT.PUT_LINE ('Inside the loop:  n = ' || TO_CHAR(n));
    n := n + 1;
    IF n < 5 THEN
      CONTINUE;
    END IF;
    DBMS_OUTPUT.PUT_LINE
      ('Inside the loop, after CONTINUE:  n = ' || TO_CHAR(n));
    EXIT WHEN n = 7;
  END LOOP;
 
  DBMS_OUTPUT.PUT_LINE ('When out from the loop:  n = ' || TO_CHAR(n));
END;
/

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Similar questions


need a help?


find thousands of online teachers now