Statement of Oracle cyclic statements

There are many types of Oracle loop statements. The following describes how to write several common Oracle loop statements. If you are interested in Oracle loop statements, take a look.

Loop:

 
 

  
  
create or replace procedure pro_test_loop is  
  
  
i number;  
  
  
begin  
  
  
i:=0;  
  
  
loop  
  
  
  ii:=i+1;  
  
  
  dbms_output.put_line(i);  
  
  
  if i>5 then  
  
  
    exit;  
  
  
  end if;  
  
  
end loop;  
  
  
end pro_test_loop; 
 
 

While loop:

 
 

  
  
create or replace procedure pro_test_while is  
  
  
i number;  
  
  
begin  
  
  
i:=0;  
  
  
while i<5 loop  
  
  
  ii:=i+1;  
  
  
  dbms_output.put_line(i);  
  
  
end loop;  
  
  
end pro_test_while; 
 
 

For Loop 1:

 
 

  
  
create or replace procedure pro_test_for is  
  
  
i number;  
  
  
begin  
  
  
i:=0;  
  
  
for i in 1..5 loop  
  
  
  dbms_output.put_line(i);  
  
  
end loop;  
  
  
end pro_test_for; 
 
 

For Loop 2:

 
 

  
  
create or replace procedure pro_test_cursor is  
  
  
userRow t_user%rowtype;  
  
  
cursor userRows is  
  
  
select * from t_user;  
  
  
begin  
  
  
for userRow in userRows loop  
  
  
    dbms_output.put_line(userRow.Id||','||userRow.Name||','||userRows%rowcount);  
  
  
end loop;  
  
  
end pro_test_cursor;  
 
 

Oracle user syntax Modification

Solution to oracle user connection failure

Differences between oracle cursor and cursor variable

Show you the Oracle explicit cursor

Use instances of Oracle stored procedures