Question: Look at the following code: DECLARE v _ blue NUMBER ( 3 ) : = 0 ; v _ red NUMBER ( 3 ) :

Look at the following code:
DECLARE
v_blue NUMBER(3) :=0;
v_red NUMBER(3) :=0;
BEGIN
<< blue >> LOOP
v_blue := v_blue +1;
EXIT WHEN v_blue >10;
<< red >> LOOP
v_red := v_red +1;
EXIT WHEN v_red >10;
-- Line A
END LOOP red;
END LOOP blue;
END;
What should you code at Line A to exit from the outer loop using PL/SQL?
EXIT;
EXIT red;
EXIT blue;
EXIT << blue>>

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!