An application includes a form on the EMPLOYEES table. You must limit the P1_MANAGER page item so users can select a single employee name and ID from…

The requirement is to allow users to pick a single employee (name and ID) from a list tied to the

MANAGER_ID column in the EMPLOYEES table, implying a dynamic, searchable selection:

A . Popup LOV: This item type displays a popup window with a searchable list of values, sourced from

a SQL query (e.g., SELECT ename, empno FROM employees WHERE empno IN (SELECT DISTINCT

manager_id FROM employees)). It returns a single value (e.g., EMPNO) while displaying the name,

perfectly meeting the need for a single selection from a related dataset.

B . Switch: A toggle (Yes/No), unsuitable for selecting from a list of employees.

C . Checkbox: Allows multiple selections, conflicting with the "single employee" requirement.

Practical note: Popup LOVs enhance usability with filtering and pagination, ideal for large employee

lists, and support returning the ID while showing the name.

Reference: Oracle APEX 23.2 Documentation - "Managing Page Items" under Item Types.