1.普通循环方法
declare
i number;
begin
for i in A..B
loop
需要循环执行的语句
end loop;
end;
说明:i的起始值为A,最大值为B
2.Exit When循环使用方法
declare
i numer;
begin
i:=0;
loop
exit when (i>5)
Dbms_Output.put_line(i);
i:=i+1;
end loop;
end;
3. Loop循环
declare
i numer;
begin
i:=0;
loop
i:=i+1;
dbms_output.put_line(i);
if i>5 then
exit;
end if;
end loop;
end;
4.While循环
declare
i numer;
Begin
i:=0;
while i<5 loop
i:=i+1;
dbms_output.put_line(i);
end loop;
end;
5.游标循环(重点)
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;
declare
i number;
begin
for i in A..B
loop
需要循环执行的语句
end loop;
end;
说明:i的起始值为A,最大值为B
2.Exit When循环使用方法
declare
i numer;
begin
i:=0;
loop
exit when (i>5)
Dbms_Output.put_line(i);
i:=i+1;
end loop;
end;
3. Loop循环
declare
i numer;
begin
i:=0;
loop
i:=i+1;
dbms_output.put_line(i);
if i>5 then
exit;
end if;
end loop;
end;
4.While循环
declare
i numer;
Begin
i:=0;
while i<5 loop
i:=i+1;
dbms_output.put_line(i);
end loop;
end;
5.游标循环(重点)
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;