Use Exit or return in loop .... The end loop; can interrupt the loop, but there is a significant difference between them.
Let's look at the following two examples:
Example 1:
Create or replace package body cux_test is
Procedure main is
Rochelle count number;
Rochelle test number: = 6;
Begin
Dbms_output.put_line ('start looping ');
For l_count in 1 .. 10 Loop
If l_test = l_count then
Dbms_output.put_line ('condition satisfied, exit looping ');
Return;
Else
Dbms_output.put_line ('continue looping ');
End if;
End loop;
Dbms_output.put_line ('end Project ');
End;
End cux_test;
Example 2:
Create or replace package body cux_test is
Procedure main is
Rochelle count number;
Rochelle test number: = 6;
Begin
Dbms_output.put_line ('start looping ');
For l_count in 1 .. 10 Loop
If l_test = l_count then
Dbms_output.put_line ('condition satisfied, exit looping ');
Exit;
Else
Dbms_output.put_line ('continue looping ');
End if;
End loop;
Dbms_output.put_line ('end Project ');
End;
End cux_test;
The execution results of the above two examples are as follows:
Example 1:
Start cycle
Continue Loop
Continue Loop
Continue Loop
Continue Loop
Continue Loop
Exit the loop if conditions are met
Example 2:
Start cycle
Continue Loop
Continue Loop
Continue Loop
Continue Loop
Continue Loop
Exit the loop if conditions are met
End program
The above example illustrates a problem. Exit is just an end loop, but it will continue to execute other content in the package, while return is to directly interrupt the entire program.