Oracle APEX - 如何创建包含多个显示值的弹出式 LOV？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/12280857/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle APEX - How to create popup LOV which contained multiple display values?
提问by Jestem_z_Kozanowa
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 :
我正在尝试在 Oracle Apex 4.1 中创建 LOV，该 LOV 将包含员工的姓名和姓氏，并且仅返回他/她的 ID。不起作用的语法如下所示：
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.
这将返回错误：LOV SQL 查询中选择的列数错误。非常感谢如何解决这个问题的任何帮助或指导。
回答by Vincent Malgrat
You could use :
你可以使用：
select
FIRST_NAME || ', ' || LAST_NAME as display_value,
USER_ID as return_value
from ALL_USERS
order by 1
回答by Tom
As an alternative to Vincent's solution, you can also look into this plugin:SkillBuilders Super LOV
It allows for multiple columns, multiple column return, and simply looks good.
The only downside is there is no tabular form option for this. (yet. It is a plugin limitation)
作为文森特解决方案的替代方案，你还可以看看这个插件：SkillBuilders Super LOV
它允许多列，多列返回，而且看起来不错。
唯一的缺点是没有表格选项。（然而。这是一个插件限制）
