UPD_DISPLAY_IN_REPORT Procedure

The UPD_DISPLAY_IN_REPORT procedure sets the display in report user interface default. This user interface default will be used by wizards when you select to create a report based upon the table and controls whether the column will be included by default or not.

Syntax

APEX_UI_DEFAULT_UPDATE.UPD_DISPLAY_IN_REPORT (
    p_table_name            IN VARCHAR2,
    p_column_name           IN VARCHAR2,
    p_display_in_report     IN VARCHAR2
   );

Parameters

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

UPD_DISPLAY_IN_REPORT Parameters

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

Example

APEX_UI_DEFAULT_UPDATE.UPD_DISPLAY_IN_REPORT(
   p_table_name => 'DEPT',
   p_column_name => 'DEPTNO',
   p_display_in_report => 'N');