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;
程序运行后最后一行的数据是重复的,请问如何让其显示没有重复的数据
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;
程序运行后最后一行的数据是重复的,请问如何让其显示没有重复的数据
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货