declare
cursor cur_aa --定义游标
is select * from scott.emp;--默认的菜鸟表
emp scott.emp%rowtype;
begin
open cur_aa;
loop
fetch cur_aa into gongzi;
DBMS_OUTPUT.PUT_LINE(emp .empno||gongzi.ename||gongzi.job);
exit when cur_aa%NOTFOUND;
end loop;
close cur_aa;
cursor cur_aa --定义游标
is select * from scott.emp;--默认的菜鸟表
emp scott.emp%rowtype;
begin
open cur_aa;
loop
fetch cur_aa into gongzi;
DBMS_OUTPUT.PUT_LINE(emp .empno||gongzi.ename||gongzi.job);
exit when cur_aa%NOTFOUND;
end loop;
close cur_aa;
end;
2018-04-08 18.04