UPD_TABLE Procedure

If the provided table exists within the user's schema's table based User Interface Defaults, the form region title and report region title are updated to match those provided. If 'null%' is passed in for p_form_region_title or p_report_region_title, the value is set to null.

Syntax

APEX_UI_DEFAULT_UPDATE.UPD_TABLE (
    p_table_name            IN VARCHAR2,
    p_form_region_title     IN VARCHAR2 DEFAULT NULL,
    p_report_region_title   IN VARCHAR2 DEFAULT NULL);

Parameters

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

UPD_TABLE Parameters

Parameter	Description
`p_table_name`	Name of table being updated.
`p_form_region_title`	Region title used for forms.
p_report_region_title	Region title used for reports and tabular forms.

Note:

if 'null%' is passed in for p_form_region_title or p_report_region_title, the value is set to null. If no value is passed in, that column will not be updated.

Example

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

begin
    apex_ui_default_update.upd_table (
       p_table_name          => 'EMP',
       p_form_region_title   => 'Employee Details',
       p_report_region_title => 'Employees' );
end;
/