UPD_ITEM_FORMAT_MASK Procedure

'The UPD_ITEM_FORMAT_MASK procedure sets the item format mask user interface default. This user interface default will be 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: UPD_ITEM_FORMAT_MASK Parameters describes the parameters available in the UPD_ITEM_FORMAT_MASK procedure.

UPD_ITEM_FORMAT_MASK Parameters

Parameter	Description
`p_table_name`	Table name
`p_column_name`	Column name
`p_format_mask`	Format mask to be associated with the column

Example

APEX_UI_DEFAULT_UPDATE.UPD_ITEM_FORMAT_MASK(
   p_table_name => 'EMP',
   p_column_name => 'HIREDATE',
   p_format_mask=> 'DD-MON-YYYY');