1. API Reference
  2. APEX_UTIL
  3. GET_USER_ID Function

59.77 GET_USER_ID Function

This function returns the numeric ID of a named user in the workspace.

Note:

This function operates on the native Oracle APEX user accounts repository and is only applicable to applications configured with Oracle APEX Accounts authentication.

Syntax

APEX_UTIL.GET_USER_ID (
    p_username   IN VARCHAR2 )
RETURN NUMBER;

Parameters

Parameter Description
p_username Identifies the name of a user in the workspace.

Example

The following example shows how to use the GET_USER_ID function to return the ID for the user named 'FRANK'. 

DECLARE
    VAL NUMBER;
BEGIN
    VAL := APEX_UTIL.GET_USER_ID(p_username => 'FRANK');
END;

Parent topic: APEX_UTIL