31.21 TEXT_FROM_LOV Function
Use this function to display an item as text, deriving the display value of the named LOV.
Syntax
APEX_ITEM.TEXT_FROM_LOV (
p_value IN VARCHAR2 DEFAULT NULL,
p_lov IN VARCHAR2,
p_null_text IN VARCHAR2 DEFAULT '%')
RETURN VARCHAR2;
Parameters
Table 31-21 TEXT_FROM_LOV Parameters
Parameter | Description |
---|---|
|
Value of a field item. Note that if |
|
Text name of a shared list of values. This list of values must be defined in your application. |
|
Value displayed when the value of the field item is NULL. |
Example
The following example demonstrates how to derive the display value from a named LOV (EMPNO_ENAME_LOV
).
SELECT APEX_ITEM.TEXT_FROM_LOV(empno,'EMPNO_ENAME_LOV') c FROM emp
Parent topic: APEX_ITEM (Legacy)