oracle 利用标签退出外层循环

最基本的三种循环

declare
  -- Local variables here
  i integer;
begin
  -- Test statements here
  i:=0;
  dbms_output.put_line('first loop:');
  while i<=10
   loop
  dbms_output.put_line('this is :'||i);
  i:=i+1;
  end loop;
 
  i:=0;
  dbms_output.put_line('second loop');
  for j in i..10 loop
    dbms_output.put_line('this is :'||j);
  end loop;
 
 
  i:=0;
  dbms_output.put_line('third loop');
  loop
    dbms_output.put_line('this is :'||i);
    exit when i=10;
    i:=i+1;
  end loop;
end;

---continue 和continue when

---ommit

declare

x number :=10;
begin

<<out>>
 loop
 dbms_output.put_line(x);
 
 x:=x-1;
 exit out when x<5;
 end loop;

end;