Oracle Apex - List of Value (LOV)

2 - Type

2.1 - Static

Syntax:


STATIC:DisplayValue1[;ReturnValue1],DisplayValue2[;ReturnValue2],...

Example:

  • Four Values Displayed in Alphabetical Order

STATIC:Cow,Dog,Cat,Lion

  • A List of Values that return the Display Value

STATIC2:10,15,20,25,50,100,200,500,1000,10000

  • A List of Values with Having Both a Return and Display Value

STATIC:Yes;Y,No;N

Creating a Static List of Values

2.2 - Cascade

  • Create a first “Select List” item and name it P1_FIRST:
  • Create a second “Select List” item named P1_SECOND:
    • From Cascading LOV Parent Item(s) - Select P1_FIRST.
    • In the LOV definition, use a bind variable that refers to the first item

SELECT name
  FROM table
 WHERE first = :P1_first
 ORDER BY name

Creating a Cascading List of Values


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap