GET_USERNAME Function

48.76 GET_USERNAME Function

This function returns the user name of a user account identified by a numeric ID.

Syntax

APEX_UTIL.GET_USERNAME(
    p_userid IN NUMBER)
RETURN VARCHAR2;

Parameters

Table 48-65 GET_USERNAME Parameters

Parameter	Description
`p_userid`	Identifies the numeric ID of a user account in the workspace.

Example

The following example uses GET_USERNAME to return the user name for the user with an ID of 228922003.

DECLARE
    val varchar2(100);
BEGIN
    val := apex_util.get_username(p_userid => 228922003);
END;