How to jump out of loops in Oracle stored procedures

How to jump out of loops in Oracle stored procedures Blog Category:

• Oracle

Oracle records the use of exit and return
Exit to jump out of the loop
Loop
IF V_KBP is NULL then
EXIT;
END IF;
End Loop;

Return jump out of stored procedure
Loop
IF V_KBP is NULL then
Return
END IF;
End Loop;

Jump out of Loop once
Oracle 11g has provided continue;
Oracle 10g and below, use Goto instead, for example

Sql> set serveroutput on;
Sql> Declare
2 begin
3 for I in 1..10 loop
4 if mod (i,2) =0 Then
5 goto Next;
6 End If;
7 Dbms_output.put_line (i);
8 <<next>>
9 null;
Ten end Loop;
one end;
12/
Note the null after the:<<next>> tag, but the statement must be followed by an execution statement after the Goto label

How to jump out of loops in Oracle stored procedures