<pre><code class="lang-plaintext">CREATE OR REPLACE procedure 
dept_emp(dno NUMBER)
IS cursor c1 is select * from emp where 
deptno=dno;
BEGIN
 for i in c1 loop
 dbms_output.put_line(i.empno||' ' || 
i.ename ||' ' || i.deptno);
END loop;
end;
//for output
begin
dept_emp(10);
end;
</code></pre>


```plaintext
CREATE OR REPLACE procedure 
dept_emp(dno NUMBER)
IS cursor c1 is select * from emp where 
deptno=dno;
BEGIN
 for i in c1 loop
 dbms_output.put_line(i.empno||' ' || 
i.ename ||' ' || i.deptno);
END loop;
end;
//for output
begin
dept_emp(10);
end;
```

WAp a procedure to display dept no emp data