请高手来帮我解答!!(游标使用问题)

[wangbo19]

declare
myrow emp%rowtype;
cursor mycur is select * from emp;
begin
open mycur;
loop
exit when mycur%notfound;
fetch mycur into myrow;
dbms_output.put_line('empno:'|| myrow.empno || 'ename:'|| myrow.ename);
end loop;
close mycur;
end;
程序运行后最后一行的数据是重复的，请问如何让其显示没有重复的数据

[precipitant]

http://blog.csdn.net/precipitant/archive/2007/04/14/1564321.aspx

[DragonBill]

把exit那一句放在fetch子句的后面