This function returns the FIRST_NAME
field stored in the named user account record.
Syntax
APEX_UTIL.GET_FIRST_NAME p_username IN VARCHAR2) RETURN VARCHAR2;
Parameters
Table 21-41 describes the parameters available in GET_FIRST_NAME
function.
Table 21-41 GET_FIRST_NAME Parameters
Parameter | Description |
---|---|
|
Identifies the user name in the account |
Example
The following example shows how to use the GET_FIRST_NAME
function to return the FIRST_NAME
of the user 'FRANK'.
DECLARE VAL VARCHAR2(255); BEGIN VAL := APEX_UTIL.GET_FIRST_NAME(p_username => 'FRANK'); END;