oracle for循环 计数,ORACLE-FOR循环

循环和过程配合,方便来生成测试数据:

例:

--创建表

create table t_test

(

test_id varchar2(100),

test_name varchar2(100)

);

--查询

select * from t_test;

truncate table t_test;

--声明过程--配合循环插入测试数据

declare

v_index number := 1;

begin

loop

if v_index < 100 then

insert into t_test values ('id'||v_index,'name'||v_index);

v_index := v_index + 1;

else exit;

end if;

end loop;

commit;

end;

-----------------------------------

转自:http://www.cnblogs.com/zheng8145/archive/2008/12/02/1345930.html

loop循环：

create or replace procedure pro_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 pro_test_loop;

while循环：

create or replace procedure pro_test_while is

i number;

begin

i:=0;

while i<5 loop

i:=i+1;

dbms_output.put_line(i);

end loop;

end pro_test_while;

for循环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循环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;