/* countinue 和 countinue when*/
<<continue_for>>
DECLARE
BEGIN
FOR v_id IN REVERSE 1 .. 10
LOOP
IF v_id = id_test01.CURRVAL
THEN
continue;
END IF;
DBMS_OUTPUT.put_line (v_id);
END LOOP;
END continue_for;
/*continue_when_for */
<<continue_when_for>>
DECLARE
BEGIN
FOR v_id IN REVERSE 1 .. 10
LOOP
CONTINUE WHEN v_id = id_test01.CURRVAL;
DBMS_OUTPUT.put_line (v_id);
END LOOP;
END continue_for;
--嵌套循环
/* nested_loop */
<<nested_loop>>
declare
v_y number :=1;
BEGIN
FOR x IN 1 .. 9
LOOP
FOR y IN v_y .. 9
LOOP
DBMS_OUTPUT.put_line (x || '*' || y || '=' || x * y);
END LOOP;
v_y:=v_y+1;
END LOOP;
END nested_loop;
本公众号是个人学习工作笔记，希望大家发现问题能及时和我本人沟通，希望你与我共同成长。个人微信zgjt12306。
欢迎关注“自学Oracle”
