Oracle Apex - Optional List of Values (LOV)

oracle oracle-apex lov
Mark3308 picture Mark3308 · Jan 23, 2010 · Viewed 7.5k times · Source

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?

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

Answer

Jeffrey Kemp picture Jeffrey Kemp · Jan 25, 2010

Yes:

  1. 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.

  2. you could use a Select List, and set Display Null = Yes; but then the user cannot enter their own values.

Related questions

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

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_…

Read More
Is it possible to output a SELECT statement from a PL/SQL block?

How can I get a PL/SQL block to output the results of a SELECT statement the same way as if I had done a plain SELECT? For example how to do a SELECT like: SELECT foo, bar FROM foobar; …

Read More
Get started link does not work in oracle 11g server

I have started using Oracle database server on Windows 7 64 bit OS and I have encountered the following error. "Error- Windows cannot find 'http://127.0.01:%HTTPPORT%/apex/f?p=4950'. Make sure you typed the name correctly, and then try again" I …

Read More