select
'f?p=4600:7:'||:app_session||':::7:P7_EMPNO:'||e.empno edit_link,
'#IMAGE_PREFIX#menu/user_red_64.gif' icon,
e.EMPNO,
e.ENAME,
e.JOB,
e.MGR,
e.HIREDATE,
e.SAL,
e.COMM,
e.DEPTNO,
d.dname,
e.work_city city,
e.work_country country,
(select count(*) from wwv_demo_emp e2 where e2.mgr = e.empno) direct_reports
from WWV_DEMO_EMP e,
wwv_demo_dept d
where e.deptno = d.deptno