Oracle Apex - List of Value (LOV)

Articles Related

Type

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

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