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: TEXT_FROM_LOV Parameters describes the parameters available in the TEXT_FROM_LOV function.

TEXT_FROM_LOV Parameters

Parameter Description

Parameter	Description
`p_value`	Value of a field item. Note that if `p_value` is not located in the list of values, `p_null_text` is value displayed.
`p_lov`	Text name of a shared list of values. This list of values must be defined in your application.
`p_null_text`	Value displayed when the value of the field item is NULL.

p_value

Value of a field item.

Note that if p_value is not located in the list of values, p_null_text is value displayed.

p_lov

Text name of a shared list of values. This list of values must be defined in your application.

p_null_text

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