UPD_DISPLAY_IN_FORM Procedure

The UPD_DISPLAY_IN_FORM procedure sets the display in form user interface defaults. This user interface default will be used by wizards when you select to create a form based upon the table. It controls whether the column is included by default or not.

Syntax

APEX_UI_DEFAULT_UPDATE.UPD_DISPLAY_IN_FORM (
    p_table_name            IN VARCHAR2,
    p_column_name           IN VARCHAR2,
    p_display_in_form       IN VARCHAR2);

Parameters

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

UPD_DISPLAY_IN_FORM Parameters

Parameter	Description
`p_table_name`	Table name
`p_column_name`	Column name
`p_display_in_form`	Determines whether or not to display in the form by default, valid values are `Y` and `N`

Example

In the following example, when creating a Form against the DEPT table, the display option on the DEPTNO column defaults to 'No'.

APEX_UI_DEFAULT_UPDATE.UPD_DISPLAY_IN_FORM(
    p_table_name => 'DEPT',
    p_column_name => 'DEPTNO',
    p_display_in_form => 'N');