Select DEPT.DEPTNO as DEPTID,
DEPT.DNAME as DNAME,
DEPT.LOC as LOC
from OE.DEPT DEPT
Select EMP.EMPNO as EMPNO,
EMP.ENAME as ENAME,
EMP.JOB as JOB,
EMP.MGR as MGR,
EMP.HIREDATE as HIREDATE,
EMP.SAL as SAL,
EMP.COMM as COMM,
EMP.DEPTNO as DEPTNO
from OE.EMP EMP
where DEPTNO=:DEPTID