GET_FIRST_NAME Function

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

Syntax

HTMLDB_UTIL.GET_FIRST_NAME
   p_username IN VARCHAR2);
RETURN VARCHAR2;

Parameters

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

GET_FIRST_NAME Parameters

Parameter	Description
`p_username`	Identifies the user name in the account

Example

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