Previous
Previous
 
Next
Next


GET_USER_ID Function

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

Syntax

APEX_UTIL.GET_USER_ID(
    p_username   IN VARCHAR2)
RETURN NUMBER;

Parameters

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

GET_USER_ID 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;