GET_LAST_NAME Function

This function returns the LAST_NAME field stored in the named user account record.

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_LAST_NAME (
    p_username IN VARCHAR2 )
RETURN VARCHAR2;

Parameters

Parameter	Description
p_username	The user name in the user account record.

Example

The following example shows how to use the function to return the LAST_NAME for the user ‘FRANK’.

DECLARE
    VAL VARCHAR2(255);
BEGIN
    VAL := APEX_UTIL.GET_LAST_NAME(p_username => 'FRANK');
END;

See Also: SET_LAST_NAME Procedure