oracle 游标的使用

二、declare

cursor cf1 is select * from student

begin

for curcf1 in cf1

loop

DBMS_OUTPUT.PUT_LINE ('ID :'|| curcf1.ID|| '姓名：'|| curcf1.Name);

END loop;

END;