APEX08.SQL01: SQL coding for a dynamic list of values (LOV) in Shared Components.
If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files used in this video series. https://sites.google.com/view/db-krei...
This video reviews the syntax for SQL code used by in a list of values (LOV) in APEX’s Shared Components. It also uses existing data in the tables to illustrate what we see in a drop-down list in a form versus the data that is actually stored in a table.
The scripts are at: http://db.kreie.net