Assuming you are using Application Express authentication, this procedure deletes a user group by providing the name of the group. To execute this procedure, the current user must have administrative privileges in the workspace.
APEX_UTIL.DELETE_USER_GROUP( p_group_name IN VARCHAR2);
Table 35-16 DELETE_USER_GROUP Procedure Signature 2 Parameters
Name of group
The following example demonstrates how to use the
DELETE_USER_GROUP procedure signature 2 to remove the user group called 'Managers', by providing the name of the user group.
BEGIN APEX_UTIL.DELETE_USER_GROUP ( p_group_name => 'Managers'); END;