Loop ____oracle in Oracle

There are five main loops: Exit when, loop, while, for (normal loop), for (cursor loop), and below for example one by one (all stored procedures).

1, Exit when cycle:
Create or replace procedure Proc_test_exit_when is
I number;
Begin
i:=0;
LOOP
Exit when (i>5);
Dbms_output.put_line (i);
i:=i+1;
End LOOP;
End Proc_test_exit_when;
—————————————————— – I'm a split-line —————————————————————

2. Loop loop:
Create or replace procedure Proc_test_loop is
I number;
Begin
i:=0;
Loop
i:=i+1;
Dbms_output.put_line (i);
If I>5 Then
Exit
End If;
End Loop;
End Proc_test_loop;
—————————————————— – I'm a split-line —————————————————————

3, while loop:
Create or replace procedure Proc_test_while is
I number;
Begin
i:=0;
While I<5 loop
i:=i+1;
Dbms_output.put_line (i);
End Loop;
End Proc_test_while;
—————————————————— – I'm a split-line —————————————————————

4. For general circulation:
Create or replace procedure Proc_test_for is
I number;
Begin
i:=0;
For I in 1..5 loop
Dbms_output.put_line (i);
End Loop;
End Proc_test_for;
—————————————————— – I'm a split-line —————————————————————

5. For cursor loops:
Create or replace procedure Proc_test_cursor is
Userrow Test%rowtype;
Cursor Userrows is
SELECT * from Test;
Begin
For Userrow in Userrows loop
Dbms_output.put_line (userrow.id| | ', ' | | userrow.name| | ', ' | | Userrows%rowcount);
End Loop;
End Proc_test_cursor;
—————————————————— – I'm a split-line —————————————————————

As the corresponding code for the stored procedure is shown above, you can test it in the following ways:

Enter Pl/sql, execute file-> new-> program window-> blank, copy the above paragraph code, to Pl/sql blank window, Ann F8 perform compilation.

Re-execute File-> the new-> Command window goes to the command window to execute the set serveroutput on this code, and then enter the exec corresponding stored procedure, OK.

The 5th loop requires that you create a new table field ID named Test, name, and insert a few data to test.

This article is from the "Gjhgkh" blog, please be sure to keep this source http://77857.blog.51cto.com/67857/419594