Oracle Apex - 可选值列表 (LOV)
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2123018/
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 - Optional List of Values (LOV)
提问by Mark3308
Is there a way in Oracle APEX to use a list of values or select list but do not force the user to select an item and allow them to enter different items?
Oracle APEX 中有没有办法使用值列表或选择列表但不强制用户选择一个项目并允许他们输入不同的项目？
The basic functionality which I require is similar to a combo box where you can optionally select an item from the list or enter a completely new.
我需要的基本功能类似于组合框，您可以在其中选择从列表中选择一个项目或输入一个全新的项目。
Thanks Mark
谢谢马克
回答by Jeffrey Kemp
Yes:
是的：
you could use a Popup LOV item type, where the user can type anything they want, and the LOV is only used to give them suggestions if they click the LOV button.
you could use a Select List, and set Display Null = Yes; but then the user cannot enter their own values.
您可以使用 Popup LOV 项目类型，用户可以在其中输入他们想要的任何内容，并且 LOV 仅用于在他们单击 LOV 按钮时向他们提供建议。
您可以使用选择列表，并设置 Display Null = Yes; 但是用户无法输入自己的值。
回答by Chris phillips
You could use a Popup LOV and UNION it with the values already entered into the target table. It would be slower and ordering would be more constrained.
For large tables you could have a process that compared the distinct set of values in the target table with those in the lookup table and entered new ones into the lookups table.
您可以使用 Popup LOV 和 UNION 它与已经输入到目标表中的值。它会更慢，订购会受到更多限制。
对于大型表，您可以有一个过程，将目标表中的不同值集与查找表中的值进行比较，并将新值输入到查找表中。
