Download Oracle Database Application Express User's Guide

Creating Lists of Values
3.
Click the Shared Components icon.
4.
Under User Interface, select Lists of Values.
The Lists of Values page appears.
5.
To create a new LOV, click Create.
6.
Follow the on-screen instructions.
New named LOVs are added to the List of Values repository. Note to add the LOV
to a page you must edit the appropriate item or column and select the named LOV.
See Also:
"Defining a Column as a List of Values" on page 5-37
About the List of Values Page
Once you create an LOV, it appears on the List of Values page.
Use the Navigation bar at the top of the page to search for a LOV by name or change
the page display. For example, you can change the default display by making a
selection from View list. Available options include:
■
■
Icons (the default) displays each LOV as a large icon. To edit an LOV, click the
appropriate icon.
Details displays each LOV as a line in a report. To edit an LOV, click the name.
About Static LOVs
Static LOVs are based on a static list of display values and return values you specify
when you run the Create LOV Wizard. To create a static LOV, run the Create LOV
Wizard and select the LOV type Static. Oracle Application Express stores the display
values, return values, and sort sequence you specify in the List of Values repository.
Once you add a static LOV to the repository, you can create an item and display it as a
check box, radio group, select list, or popup list based on this definition.
Editing an Existing LOV
To edit an existing LOV, select the LOV on the Lists of Values page.
To edit an LOV:
1.
On the Workspace home page, click the Application Builder icon.
2.
Select an application.
3.
Click Shared Components.
4.
Under User Interface, select Lists of Values.
Building an Application 5-103