Farhaj Lodhi's :: Ilm Sub Ke Liye

  Introduction When building data-driven dashboards and reports in Oracle APEX, displaying descriptive region headings improves the user interface. By default, Oracle APEX renders the region title as a plain header. However, developers often need more control over how that title looks, especially when working with Interactive Grid or Classic Report regions embedded in complex page layouts. Without this control, headings can appear duplicated or unstyled, which looks unprofessional. This article provides a step-by-step approach to displaying a custom styled heading such as "Service Request Master" above a report region in Oracle APEX. Prerequisite ·          An Oracle APEX page containing:   One Interactive Grid region named Service Request Master   One Detail region named Service Request Detail ·          Basic familiarity with APEX Page Designer Objective When you want to show a sty...

  Introduction When building data-driven dashboards in Oracle APEX, it is common to need more than one data series on a single bar chart. In our scenario we want to compare ordered quantity against receipt quantity for each supplier, side by side, in the same chart. This article guides how to add a second series to an existing bar chart in Oracle APEX, configure its data source, and customize the color of each series for clarity. Prerequisites A page in Oracle Apex Application containing a Bar Chart region At least one series already configured on the chart (in our example Ordered Qty. mapped to the Order Qty. column. How to Add a Second Series to a Bar Chart   Step 1: Open Page Designer Navigate to your application in Oracle APEX and open the relevant page in Page Designer. Step 2:   Locate and Expand the Chart Region In the left-hand rendering tree, find your existing Chart region and click the arrow next to it to expand it. You wil...

    Introduction Oracle Application Express (APEX) is one of the most widely adopted low-code development platforms in the Oracle ecosystem. As organizations scale their APEX deployments, the need for robust monitoring and troubleshooting capabilities becomes critical. This article provides SQL queries that DBAs and developers can use to monitor, diagnose, and optimize their APEX environments.   What makes monitoring APEX unique is the three-tier architecture it operates on: the Oracle Database at the data layer, APEX at the application layer, and Oracle REST Data Services (ORDS) as the middleware. Understanding how sessions flow through these three layers is the key to effective monitoring.     Architecture Overview   Layer Component Version Role Database Oracle DB 19.28 Stores data, executes SQL, manages sessions Application Oracle AP...