Report Practical - Parameter Report

PARAMETER REPORT :

SELECT EMPLOYEE_ID,FIRST_NAME||' '||LAST_NAME NAME, EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY FROM EMPLOYEES where DEPARTMENT_ID=:P_DEPARTMENT_ID;

-- ADD PARAMETER :P_DEPARTMENT_ID
-- ADD LIST-OF-VALUES(LOV) IN :P_DEPARTMENT_ID PARAMETER.
-- ADD COLUMN : MANAGER_ID IN THE QUERY. LIKE THIS :

SELECT EMPLOYEE_ID,FIRST_NAME||' '||LAST_NAME NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,MANAGER_ID FROM EMPLOYEES where DEPARTMENT_ID=:P_DEPARTMENT_ID;

--ADD FUNCTION IN THE MANAGER_ID COLUMN.