GET_USERNAME Function

59.79 GET_USERNAME Function

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

Note:

This function operates on the native Oracle APEX user accounts repository and is only applicable to applications configured with Oracle APEX Accounts authentication.

Syntax

APEX_UTIL.GET_USERNAME (
    p_userid    IN NUMBER )
RETURN VARCHAR2;

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;