TEXT_FROM_LOV Function

Use this function to display an item as text, deriving the display value of the named LOV.

Syntax

HTMLDB_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
`p_value`	Value of a field item.
`p_lov`	Text name of a shared list of values. This list of values must be defined in your application.
`p_null_text`	Value to be displayed when the value of the field item is null or a corresponding entry is not located for the value `p_value` in the list of values.

Example

The following example demonstrates how to derive the display value from a named LOV (EMPNO_ENAME_LOV).

SELECT HTMLDB_ITEM.TEXT_FROM_LOV(empno,'EMPNO_ENAME_LOV') c FROM emp