--for循环遍历游标读取数据
create or replace procedure test_for
as
Cursor tempcursor is select userName from temUser01;
name varchar2(20);
begin
for name in tempcursor LOOP
begin
dbms_output.put_line(name.userName);
end;
end LOOP;
end ;
--调用
call test_for();