This content has been marked as final. Show 2 replies
Instead of using "Display extra values" make sure the extra value is part of the LOV by adding an or to the select.
Where pXX_lov is the name of the item the lov belongs to.
select emp.last_name , emp.employee_id from oehr_employees emp where emp.department_id = 10 or emp.employee_id = :pXX_lov
Nicolette's idea is good, I'll just illustrate it with a further example
Assuming we had a dept in emp which did not exist in dept, then we would just display the employees deptno.
select distinct nvl(dd.dname, ee.deptno) d, dd.deptno r from emp ee, dept dd where ee.deptno=dd.deptno(+)