Answer to Question #258555 in Databases | SQL | Oracle | MS Access for Tarurendra Kushwah

Question

Write a program in PL/SQL to print the value of a variable inside and outside a loop using LOOPEXIT statement.

Answer 1

DECLARE
  n NUMBER := 0;
BEGIN
  LOOP
    DBMS_OUTPUT.PUT_LINE ('The value of n inside the loop is:  ' || TO_CHAR(n));
    n := n + 1;
    IF n > 5 THEN
      EXIT;
    END IF;
  END LOOP;
  DBMS_OUTPUT.PUT_LINE('The value of n outside the loop is: ' || TO_CHAR(n));
END;
/