The name of all employees in this department is identified by using a cursor with parameters to pass to the specified department.

--Query the names of employees in a department
--set
Serveroutput
on declare--Define cursors with parameters
cursor Cemp (DNO number) is select ename from EMP where Deptno=dno;
Pename Emp.ename%type;
Begin
  --Opens the cursor open
  cemp (10);--Unit 10th Loop--Take
    out each employee's name and
    fetch cemp into pename;
    Exit when Cemp%notfound;
    
    
    Dbms_output.put_line (pename);
    End Loop;
    
    --Turn off the cursor, q in fact the cursor is a result set close
    cemp;
  End