写法一 for cur in (select ID,age,Name,salay from studentInfo) loop dbms_out.put_line('id:'||cur.id); dbms_out.put_line('name:'||cur.name); dbms_out.put_line('age:'||cur.age); end loop;写法二: declare cursor cur is select * from studentInfo; v_temp studentInfo%rowtype; begin open cur; loop fetch cur into v_temp exit when cur%notfound; dbms_out.put_line('id:'||cur.id); dbms_out.put_line('name:'||cur.name); dbms_out.put_line('age:'||cur.age); end loop; close cur; end;
http://blog.csdn.net/justdo2008/archive/2009/04/29/4137779.aspx
for cur in (select ID,age,Name,salay from studentInfo) loop
dbms_out.put_line('id:'||cur.id);
dbms_out.put_line('name:'||cur.name);
dbms_out.put_line('age:'||cur.age);
end loop;写法二:
declare
cursor cur is select * from studentInfo;
v_temp studentInfo%rowtype;
begin
open cur;
loop
fetch cur into v_temp
exit when cur%notfound;
dbms_out.put_line('id:'||cur.id);
dbms_out.put_line('name:'||cur.name);
dbms_out.put_line('age:'||cur.age);
end loop;
close cur;
end;
你急啥,看你就不是做技术的料,瞎扯淡,你到哪凉快也别来CSDN,