Oracle Apex - List of Value (LOV)

Card Puncher Data Processing






  • Four Values Displayed in Alphabetical Order

  • A List of Values that return the Display Value

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

Creating a Static List of Values


  • 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
  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