UPD_GROUP Procedure

If the provided table and group exist within the user's schema's table based User Interface Defaults, the group name, description and display sequence of the group are updated. If 'null%' is passed in for p_description or p_display_sequence, the value is set to null.

Syntax

APEX_UI_DEFAULT_UPDATE.UPD_GROUP (
    p_table_name            IN VARCHAR2,
    p_group_name            IN VARCHAR2,
    p_new_group_name        IN VARCHAR2 DEFAULT NULL,
    p_description           IN VARCHAR2 DEFAULT NULL,
    p_display_sequence      IN VARCHAR2 DEFAULT NULL);

Parameters

Table: UPD_GROUP Parameters describes the parameters available in the UPD_GROUP procedure.

UPD_GROUP Parameters

Parameter	Description
`p_table_name`	Name of table whose group is being updated
`p_group_name`	Group being updated
`p_new_group_name`	New name for group, if group is being renamed
`p_description`	Description of group
`p_display_sequence`	Display sequence of group.

Note:

If p_description or p_display_sequence are set to 'null%', the value will be nullified. If no value is passed in, that column will not be updated.

Example

The following example updates the description of the group AUDIT_INFO within the EMP table definition within the UI Defaults Table Dictionary within the current schema.

BEGIN
    apex_ui_default_update.upd_group (
       p_table_name  => 'EMP',
       p_group_name  => 'AUDIT_INFO',
       p_description => 'Audit columns' );
END;