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 34-15 UPD_GROUP Parameters
| Parameter | Description |
|---|---|
|
|
Name of table whose group is being updated |
|
|
Group being updated |
|
|
New name for group, if group is being renamed |
|
|
Description of group |
|
|
Display sequence of group. |
Note:
If p_description or p_display_sequence are set to 'null%', the value is nullified. If no value is passed in, that column is not 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;
Parent topic: APEX_UI_DEFAULT_UPDATE