Oracle Apex - List of Value (LOV)

Card Puncher Data Processing

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





Discover More
Oracle Apex Items Type
Oracle Apex - (Form|Page) (Field|Item)

An item (also called a field) is a HTML form elements such as text fields, select lists, and check boxes. Every item has a session state value that can be referenced by a variable. Item names...
Card Puncher Data Processing
Oracle Apex - List

A list is shared collection of links. Lists is a navigation component. list of value (LOV) You add a list to a page by creating a list region. Deleting a list will cause referencing regions to be...
Oracle Apex Report Columns Metadata
Oracle Apex - Metadata

The metadata of Oracle Apex are stored in a schema prefixed with APEX. From this schema, you can query the whole application definition: from page to columns APEX_APPLICATION_ALL_AUTH APEX_APPLICATION_AUTH...



Share this page:
Follow us:
Task Runner