8.4.1 Use Nested LoopsIn this exercise, you will use nested numeric FOR loops. Create the following PL/SQL script: -- ch08_6a.sql, version 1.0 SET SERVEROUTPUT ON DECLARE v_test NUMBER := 0; BEGIN <<outer_loop>> FOR i IN 1..3 LOOP DBMS_OUTPUT.PUT_LINE('Outer Loop'); DBMS_OUTPUT.PUT_LINE('i = 'i); DBMS_OUTPUT.PUT_LINE('v_test = 'v_test); v_test := v_test + 1; <<inner_loop>> FOR j IN 1..2 LOOP DBMS_OUTPUT.PUT_LINE('Inner Loop'); DBMS_OUTPUT.PUT_LINE('j = 'j); DBMS_OUTPUT.PUT_LINE('i = 'i); DBMS_OUTPUT.PUT_LINE('v_test = 'v_test); END LOOP inner_loop; END LOOP outer_loop; END; Execute the script, and then answer the following questions:
|