For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
SELECT employee_id, first_name, last_name, salary, department_id FROM employees WHERE department_id = :P1_DEPT_ID;