31.14 SELECT_LIST_FROM_LOV Function
This function dynamically generates select lists from a shared list of values (LOV).
Similar to other functions available in the APEX_ITEM
package,
these select list functions are designed to generate forms with F01
to F50
form array elements. This function is the same as
SELECT_LIST_FROM_LOV
, but its return value is
VARCHAR2
. Use this function in SQL queries where you need to
handle a column value longer than 4000 characters.
Syntax
APEX_ITEM.SELECT_LIST_FROM_LOV(
p_idx IN NUMBER,
p_value IN VARCHAR2 DEFAULT NULL,
p_lov IN VARCHAR2,
p_attributes IN VARCHAR2 DEFAULT NULL,
p_show_null IN VARCHAR2 DEFAULT 'YES',
p_null_value IN VARCHAR2 DEFAULT '%NULL%',
p_null_text IN VARCHAR2 DEFAULT '%',
p_item_id IN VARCHAR2 DEFAULT NULL,
p_item_label IN VARCHAR2 DEFAULT NULL,
p_show_extra IN VARCHAR2 DEFAULT 'YES')
RETURN VARCHAR2;
Parameters
Table 31-14 SELECT_LIST_FROM_LOV Parameters
Parameter | Description |
---|---|
|
Form element name. For example, |
|
Current value. This value should be a value in the |
|
Text name of an application list of values. This list of values must be defined in your application. This parameter is used only by the |
|
Extra HTML parameters you want to add. |
|
Extra select option to enable the NULL selection. Range of values is |
|
Value to be returned when a user selects the NULL option. Only relevant when |
|
Value to be displayed when a user selects the NULL option. Only relevant when |
|
HTML attribute ID for the |
|
Invisible label created for the item. |
|
Shows the current value even if the value of |
Example
The following example demonstrates a select list based on an LOV defined in the application.
SELECT APEX_ITEM.SELECT_LIST_FROM_LOV(2,job,'JOB_FLOW_LOV')job
FROM emp
Parent topic: APEX_ITEM (Legacy)