declare
emprow emp%rowtype;
cursor e_cur (dno number) is select * from emp where deptno=dno;
begin
open e_cur(&dno);
loop
fetch e_cur into emprow;
exit when e_cur%notfound;
dbms_output.put_line(emprow.empno||emprow.ename||emprow.job||emprow.mgr||emprow.sal||emprow.hiredate||emprow.comm||emprow.deptno);
end loop;
close e_cur;
end;
/
