Oracle APEX - How to create popup LOV which contained multiple display values?

Question

I am trying to create LOV in Oracle Apex 4.1 which would contain name and surname of employees and would return only his/hers id. The syntax which does not work looks like this :

 select
     FIRST_NAME,LAST_NAME as display_value, 
     USER_ID as return_value 
 from ALL_USERS
 order by 1

This returns error : Wrong number of columns selected in the LOV SQL query. Any help or guidance how to tackle this problem greatly appreciated.

Answer 1

You could use :

select
     FIRST_NAME || ', ' || LAST_NAME as display_value, 
     USER_ID as return_value 
 from ALL_USERS
 order by 1