How to set the column width of classic report in Oracle Apex

  • Click the classic report column
  • Now go to HTML expression filed under column formatting and type

<span style=”display:block; width:200px”>#COLUMN_NAME_OF_REPORT#</span>

Apply changes and you are done.

This will increase the column width.. use the different width for other columns.

 

Advertisements

Find Missing Page numbers in oracle

This code will return the missing page no between 1801 to 2000


select min_a - 1 + level
     from ( 
        SELECT 1801 min_a,
          2000 max_a
        FROM APEX_APPLICATION_PAGES
        WHERE application_id= :app_id
        and page_id between 1801 and 2000
          )
  connect by level <= max_a - min_a + 1
    minus
 select page_id from APEX_APPLICATION_PAGES where application_id =:app_id
and page_id between 1801 and 2000

Oracle Apex Backend View list

select *
from apex_dictionary
where column_id = 0

or

select distinct apex_view_name
from apex_dictionary

  • apex_application_bc_entries
  • apex_application_list_entries
  • apex_application_page_ir_cgrps
  • apex_application_page_ir_comp
  • apex_application_page_rpt_cols
  • apex_application_temp_label
  • apex_application_trees
  • apex_application_web_services
  • apex_appl_developer_comments
  • apex_appl_page_ig_columns
  • apex_appl_page_ig_col_groups
  • apex_appl_plugin_attr_values
  • apex_rest_resource_modules
  • apex_team_bugs
  • apex_workspace_apex_users
  • apex_workspace_log_summary
  • apex_ws_data_grid
  • apex_application_breadcrumbs
  • apex_application_pages
  • apex_application_page_branches
  • apex_application_page_chart_s
  • apex_application_page_groups
  • apex_application_page_ir
  • apex_application_page_map
  • apex_application_supp_objects
  • apex_application_temp_list
  • apex_application_temp_report
  • apex_application_translations
  • apex_appl_load_table_rules
  • apex_appl_page_igs
  • apex_appl_page_ig_rpt_views
  • apex_team_features
  • apex_ui_defaults_tables
  • apex_workspace_group_users
  • apex_ws_data_grid_col
  • apex_applications
  • apex_application_nav_bar
  • apex_application_page_db_items
  • apex_application_page_ir_col
  • apex_application_page_ir_cond
  • apex_application_page_ir_pivot
  • apex_application_processes
  • apex_application_substitutions
  • apex_application_theme_styles
  • apex_appl_page_ig_rpt_aggs
  • apex_appl_page_ig_rpt_highlts
  • apex_appl_plugin_std_attrs
  • apex_appl_template_options
  • apex_ui_defaults_columns
  • apex_workspace_files
  • apex_workspace_groups
  • apex_ws_app_pages
  • apex_application_computations
  • apex_application_lovs
  • apex_application_page_charts
  • apex_application_page_ir_rpt
  • apex_application_page_val
  • apex_application_parent_tabs
  • apex_application_static_files
  • apex_application_supp_obj_chck
  • apex_application_supp_obj_scr
  • apex_application_temp_bc
  • apex_application_temp_page
  • apex_application_temp_popuplov
  • apex_appl_page_ig_rpt_computes
  • apex_appl_plugins
  • apex_appl_plugin_settings
  • apex_team_milestones
  • apex_workspaces
  • apex_workspace_access_log
  • apex_workspace_group_groups
  • apex_workspace_sessions
  • apex_workspace_session_groups
  • apex_ws_applications
  • apex_application_groups
  • apex_application_lists
  • apex_application_locked_pages
  • apex_application_page_chart_a
  • apex_application_page_flash5_s
  • apex_application_page_ir_pvagg
  • apex_application_shortcuts
  • apex_application_templates
  • apex_application_theme_files
  • apex_application_trans_map
  • apex_appl_load_table_lookups
  • apex_appl_page_calendars
  • apex_appl_page_ig_rpt_columns
  • apex_appl_template_opt_groups
  • apex_appl_temp_region_dp
  • apex_team_feedback_followup
  • apex_team_todos
  • apex_themes
  • apex_ui_defaults_groups
  • apex_ui_defaults_lov_data
  • apex_workspace_activity_log
  • apex_workspace_clicks
  • apex_workspace_log_archive
  • apex_application_all_auth
  • apex_application_caching
  • apex_application_items
  • apex_application_lov_entries
  • apex_application_page_ir_cat
  • apex_application_page_ir_grpby
  • apex_application_page_ir_sub
  • apex_application_temp_button
  • apex_application_trans_repos
  • apex_appl_concatenated_files
  • apex_appl_load_tables
  • apex_appl_page_ig_rpts
  • apex_appl_page_ig_rpt_filters
  • apex_appl_temp_page_dp
  • apex_appl_theme_display_points
  • apex_rest_resource_handlers
  • apex_rest_resource_templates
  • apex_team_feedback
  • apex_workspace_log_summary_usr
  • apex_workspace_static_files
  • apex_workspace_ui_types
  • apex_application_build_options
  • apex_application_page_buttons
  • apex_application_page_comp
  • apex_application_page_da
  • apex_application_page_flash5
  • apex_application_page_ir_pvsrt
  • apex_application_page_proc
  • apex_application_page_trees
  • apex_application_supp_obj_bopt
  • apex_application_tabs
  • apex_application_temp_calendar
  • apex_application_temp_region
  • apex_appl_page_ig_rpt_cht_cols
  • apex_appl_plugin_files
  • apex_appl_user_interfaces
  • apex_workspace_developers
  • apex_workspace_sql_scripts
  • apex_application_auth
  • apex_application_authorization
  • apex_application_page_da_acts
  • apex_application_page_items
  • apex_application_page_regions
  • apex_application_page_reg_cols
  • apex_application_page_rpt
  • apex_application_themes
  • apex_application_trans_dynamic
  • apex_appl_plugin_attributes
  • apex_appl_plugin_events
  • apex_rest_resource_parameters
  • apex_ui_defaults_attr_dict
  • apex_workspace_schemas

Oracle apex Classic report CSV download to Restrict the columns

Use the below code to restrict what are the columns download the csv download in Oracle apex Classic report.

1. if one column is hidden column, if you download the csv you want the hidden column
NVL(:REQUEST, 'MY_REQ') LIKE 'FLOW_EXCEL_OUTPUT%'
NVL(:REQUEST, 'MY_REQ') NOT LIKE 'FLOW_EXCEL_OUTPUT%'

Check the below example

https://apex.oracle.com/pls/apex/f?p=44666:2:104537404919649::NO:::

Oracle Apex 5.1 Error handling procedure with example

Apex error handling procedure.. we are commonly using raise application error only.. when system will through the oracle error code like ORA-20001. it will come before message.. so if we use the below code we will avoid the error code.


apex_error.add_error (
    p_message          => 'This custom account is not active!',
    p_display_location => apex_error.c_inline_in_notification );
	
	
 apex_error.add_error (
    p_error_code       => 'INVALID_CUSTOMER_ID',
    p0                 => l_customer_id,
    p_display_location => apex_error.c_inline_with_field_and_notif,
    p_page_item_name   => 'P5_CUSTOMER_ID' );
	
APEX_ERROR.ADD_ERROR (
    p_message          in varchar2,
    p_additional_info  in varchar2 default null,
    p_display_location in varchar2,
    p_region_id        in number,
    p_column_alias     in varchar2 default null,
    p_row_num          in number );
	
apex_error.add_error (
    p_message          => 'Invalid Customer ID!',
    p_display_location => apex_error.c_inline_with_field_and_notif,
    p_region_id        => l_region_id,
    p_column_alias     => 'CUSTOMER_ID',
    p_row_num          => l_row_num );