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
for i in e_cur(&dno) loop
dbms_output.put_line(i.empno||' '||i.sal||' '||i.deptno );
end loop;
end;
/
