Q:

Write a program in PL/SQL to print the value of a variable inside and outside a loop using LOOP WHEN EXIT statement

0

Write a program in PL/SQL to print the value of a variable inside and outside a loop using LOOP WHEN EXIT 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('The value of n inside the loop is: ' || TO_CHAR(n));
    n := n + 1; 
    EXIT WHEN n > 5;
  END LOOP;
    DBMS_OUTPUT.PUT_LINE('The value of n after exit from the loop is: ' || 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