43.18 UPD_ITEM_FORMAT_MASK Procedure
The UPD_ITEM_FORMAT_MASK
procedure sets the item format mask user interface default. This user interface default is used by wizards when you select to create a form based upon the table and include the specified column. Item format mask is typically used to format numbers and dates.
Syntax
APEX_UI_DEFAULT_UPDATE.UPD_ITEM_FORMAT_MASK (
p_table_name IN VARCHAR2,
p_column_name IN VARCHAR2,
p_format_mask IN VARCHAR2 DEFAULT NULL);
Parameters
Table 43-18 UPD_ITEM_FORMAT_MASK Parameters
Parameter | Description |
---|---|
|
Table name |
|
Column name |
|
Format mask to be associated with the column |
Example
In the following example, when creating a Form against the EMP table, the default item format mask on the HIREDATE column is set to 'DD-MON-YYYY'.
APEX_UI_DEFAULT_UPDATE.UPD_ITEM_FORMAT_MASK(
p_table_name => 'EMP',
p_column_name => 'HIREDATE',
p_format_mask=> 'DD-MON-YYYY');
Parent topic: APEX_UI_DEFAULT_UPDATE