I am new APEX, i don't know what ":P2_REPORT_ SEARCH" is doing in the below query. Why it is used and when to use?
(select count(*)from oehr_employees where department_id = d.department_id)
"Number of Employees",
substr(e.first_name,1,1)||'.'||e.last_name "Manager Name",
FROM OEHR_DEPARTMENTS d,