title: Oracle APEX - How to create popup LOV which contained multiple display values?
body: <p>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 :</p>
  
  <pre>
   select
       FIRST_NAME,LAST_NAME as display_value, 
       USER_ID as return_value 
   from ALL_USERS
   order by 1
  </pre>
  
  <p>This returns error : Wrong number of columns selected in the LOV SQL query. 
  Any help or guidance how to tackle this problem greatly appreciated.</p>