GET_EMAIL Function

This function returns the email address associated with the named user.

Syntax

HTMLDB_UTIL.GET_EMAIL(
   p_username IN VARCHAR2);
RETURN VARCHAR2;

Parameters

Table: GET_EMAIL Parameters describes the parameters available in GET_EMAIL function.

GET_EMAIL Parameters

Parameter	Description
`p_username`	The user name in the account

Example

DECLARE VAL VARCHAR2;
BEGIN
  VAL := HTMLDB_UTIL.GET_EMAIL(p_username => 'SCOTT');
END;