oracle+账号+及权限oracle嵌套循环跳出内部循环体

  oracle嵌套循环跳出内部循环体

PROCEDURE test(P_MSG out VARCHAR2) is
  begin
    <<illoop>>
    for i in 1 .. 10 loop
      <<jloop>>
      for j in 1 .. 5 loop
        dbms_output.put_line('i:' || i || ' j :' || j);
        EXIT jloop when j = 3;
      end loop jloop;
    end loop illoop;
  end;

本文来oracle账号自于 CSDN社区“mikemoon的专栏”