日期:2014-05-16  浏览次数:20473 次

oracle 循环例子
declare  
temp_emp test_tw%rowtype;   
cursor cur2 is select * from test_tw;   
begin  
if cur2%isopen = false then  
open cur2;   
end if;   
for i in 0..5 loop   
fetch cur2 into temp_emp;   
exit when cur2%notfound;   
dbms_output.put_line('编号:'||temp_emp.id||','||'名字:'||temp_emp.xm);
end loop;   
close cur2;   
end;  

?