GET_LAST_NAME Function

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

Syntax

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

Parameters

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

GET_LAST_NAME Parameters

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

Example

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