The Oracle APEX Guide Oracle Apex Guide RSS Feed
*
Accessibility

Background

How to create an Oracle APEX Dynamic List of Values (LOV)

In Oracle Apex go to the Shared Component page and select List of Values.

Home>Application Builder>Application ###>Shared Components>Lists of Values

Enter your SQL as shown in Screen 1. Another example with conditions is shown in Screen 2.

In the form where the list needs to be displayed add an item with display as: Select List (Screen 3).

Select the relevant list as show in Screen 4.

*

Oracle Apex Simple SQL for Dynamic LOV
Screen 1
Page Top
*

Oracle Apex SQL for Dynamic LOV with Conditions
Screen 2
Page Top
*

Oracle Apex Simple SQL Form Item
Screen 3
Page Top
*

Oracle Apex Select Relevant List
Screen 4
Page Top

  *  
© RuleWorks - All Rights Reserved - Policy - - Sitemap