declare
eno emp.EMPNO%type;
dnum emp.deptno%type;
salary emp.sal%type;
cursor e_cur (dno number) is
select empno,deptno,sal from emp where deptno=dno;
begin
open e_cur(20);
loop
fetch e_cur into eno,dnum,salary;
exit when e_cur%notfound;
dbms_output.put_line(eno||' '||salary||' '||dnum );
end loop;
close e_cur;
end;
/
