58.47 GET_EMAIL Function
This function returns the email address associated with the named user.
Syntax
APEX_UTIL.GET_EMAIL(
p_username IN VARCHAR2);
RETURN VARCHAR2;
Parameters
Table 58-37 GET_EMAIL Parameters
Parameter | Description |
---|---|
|
The user name in the account. |
Example
The following example shows how to use the GET_EMAIL
function to return the email address of the user 'FRANK'.
DECLARE
VAL VARCHAR2(240);
BEGIN
VAL := APEX_UTIL.GET_EMAIL(p_username => 'FRANK');
END;
See Also:
Parent topic: APEX_UTIL