44.50 GET_GROUPS_USER_BELONGS_TO Function
This function returns a comma then a space separated list of group names to which the named user is a member.
Syntax
APEX_UTIL.GET_GROUPS_USER_BELONGS_TO(
p_username IN VARCHAR2)
RETURN VARCHAR2;
Parameters
Table 44-43 GET_GROUPS_USER_BELONGS_TO Parameters
Parameter | Description |
---|---|
|
Identifies the user name in the account. |
Example
The following example shows how to use the GET_GROUPS_USER_BELONGS_TO
to return the list of groups to which the user 'FRANK' is a member.
DECLARE
VAL VARCHAR2(32765);
BEGIN
VAL := APEX_UTIL.GET_GROUPS_USER_BELONGS_TO(p_username => 'FRANK');
END;
See Also:
Parent topic: APEX_UTIL