How a cursor scroll to first row

[Jame_hua]

declare cursor c is select col from table ;
ls_part varchar2(100);
begin
open c ;
loop
fetch c into ls_part;
exit when c%notfound
end loop ;
fetch c first into ls_part ;//How a cursor scroll to first row
close c;
end ;

Thanks in advance

[beckhambobo]

declare
cursor c is select col from table;
ls_part varchar2(100);
begin
open c;
loop
fetch c into ls_part;
exit when c%notfound;
end loop ;
close c;
end ;
/

[jiezhi]

when you first fetch value

[Jame_hua]

你们理解错了。
我是想让游标指针重新指向第一行

[yxzhjm]

FETCH FIRST就是让游标指针重新指向第一行。

declare cursor c is select col from table ;
ls_part varchar2(100);
begin
open c ;
loop
fetch c into ls_part;
exit when c%notfound
end loop ;
fetch first into ls_part
close c;
end ;

[daydayupliq]

楼上的语句可以吗？
我想大不了关闭游标，再重新打开就是了！
declare cursor c is select col from table ;
ls_part varchar2(100);
begin
open c ;
loop
fetch c into ls_part;
exit when c%notfound
end loop ;
close c;
open c ;
loop
fetch c into ls_part;
exit when c%notfound
end loop ;
close c;
end ;

[beckhambobo]

游标不能循环，关闲游标重新fetch c into ls_part;