PLIST_GET_KEY Function

55.17 PLIST_GET_KEY Function

Gets the first property list key that maps to a given value. Returns NULL if the value can not be found.

Syntax

APEX_STRING.PLIST_GET_KEY (
    p_table IN apex_t_varchar2,
    p_value IN VARCHAR2 )
    RETURN varchar2;

Parameters

Parameter	Description
`p_table`	The input table.
`p_value`	The input value.

Example

The following example gets key of property "bar."

DECLARE
    l_plist apex_t_varchar2 := apex_t_varchar2('key1','foo','key2','bar');
BEGIN
    sys.dbms_output.put_line(apex_string.plist_get_key(l_plist,'bar'));
END;
-> key2

Parent topic: APEX_STRING