UPD_ITEM_LABEL Procedure

The UPD_ITEM_LABEL procedure sets the label used for items. 'This user interface default will be used when you create a form based on the specified table and include a specific column.

Syntax

APEX_UI_DEFAULT_UPDATE.UPD_ITEM_LABEL (
    p_table_name            IN VARCHAR2,
    p_column_name           IN VARCHAR2,
    p_label                 IN VARCHAR2 DEFAULT NULL
   );

Parameters

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

UPD_ITEM_LABEL Parameters

Parameter	Description
`p_table_name`	Table name
`p_column_name`	Column name
`p_label`	Desired item label

Example

APEX_UI_DEFAULT_UPDATE.UPD_ITEM_LABEL(
   p_table_name => 'DEPT',
   p_column_name => 'DEPTNO',
   p_label => 'Department Number');