语法:
[<<Label_Nme>>]
Loop
Continue [Label_Name] ....
Exit [Label_Name]...
--statement
End Loop [Label_Name];
[<<Label_Name>>]
For ... Loop
Continue [Label_Name] ....
Exit [Label_Name]...
--statement
End Loop [Label_Name];
[<<Label_Name>>]
While ..Loop
Continue [Label_Name] ....
Exit [Label_Name]...
--statement
End Loop [Label_Name];
例1:
SQL> Declare
2 i Number:=0;3 Begin
4 For i In 1..10 Loop
5 dbms_output.put_line(i);
6 End Loop For循环结束;
7 End;
8 /
1
2
3
4
5
6
7
8
9
10
PL/SQL procedure successfully completed
例2:
SQL> Declare
2 i Number:=0;
3 Begin
4 While i<10 Loop
5 i:=i+1;
6 dbms_output.put_line(i);
7 End Loop while循环结束;
8 End;
9 /
1
2
3
4
5
6
7
8
9
10
PL/SQL procedure successfully completed
例3:
SQL> Declare
2 i Number:=0;
3 Begin
4 Loop
5 i:=i+1;
6 dbms_output.put_line(i);
7 Exit When i>=10;
8 End Loop loop循环结束;
9 End;
10 /
1
2
3
4
5
6
7
8
9
10
PL/SQL procedure successfully completed