
Using Labels on Loops for Referencing
BEGIN
<<outer_loop>>
FOR i IN 1.. 3 LOOP -- assign the values 1,2,3 to i
<<inner_loop>>
FOR i IN 1.. 3 LOOP
IF outer_loop.i = 2 THEN
dbms_output.Put_line('outer: '
||To_char(outer_loop.i)
||' inner: '
||To_char(inner_loop.i));
END IF;
END LOOP inner_loop;
END LOOP outer_loop;
END;
/
and without IF condition , the result will be like that :-

0 comments:
Post a Comment