APEX

Metric Card in Oracle APEX 26.1

Introduction Oracle APEX 26.1 brought in a new template component called the Metric Card, purpose built for KPI style dashboards. Until this release, if you wanted a clean tile showing a single important number, you had to either write custom HTML or…

Read More

Validate SQL Queries using PL/SQL Package

Introduction We built a dynamic reporting solution that allows end users to store and execute SQL queries with bind variables in Oracle APEX. While this approach provides great flexibility, it…

Read More

Python-Powered API cost anomaly Guardrail with Oracle APEX PDF Engine

Introduction / Issue In cloud computing and serverless systems, there may be unexpected bursts of use, causing hidden cost overheads which are untracked. Guardrails are put in place to run…

Read More

Oracle APEX – Dynamic Reporting

Introduction Users can store multiple SQL queries in a database table, and these queries may include bind variables. When an end user selects a query, the application automatically identifies the…

Read More

Map Region Enhancements In Oracle APEX: Vector Tiles & Bounding Box

Introduction / Issue Think of a delivery company trying to show ten thousand stops on a map, or a utility company mapping every pipeline in a city. It works fine…

Read More

Adding Multi-Level Column Headers to an Oracle APEX Classic Report Using JavaScript

Introduction:  Oracle APEX Classic Reports provide a single row of column headers by default. However, in some business scenarios, it is necessary to group related columns under a common heading to…

Read More

Implementing Mouse-Centered Screen Zoom Using the Shift Key with JavaScript in Oracle APEX

Introduction Oracle APEX applications often display large amounts of data in Interactive Reports, Interactive Grids, dashboards, and forms. When users need to inspect small text or closely packed information, increasing…

Read More

Highlight Important Dates in Oracle APEX Modal Dialog Date Picker Using JavaScript

Highlight Important Dates in Oracle APEX Modal Dialog Date Picker Using JavaScript Introduction Oracle APEX provides a built-in Date Picker component that makes date selection simple and user-friendly. In many…

Read More

Excel-Like Auto-Increment Fill in Oracle APEX Interactive Grid

Introduction:   Oracle APEX Interactive Grid allows users to drag and fill values across rows. However, by default, dragging a numeric value simply copies the same value to all selected rows…

Read More

Building a Screen and Webcam Recorder Inside Oracle APEX

Introduction / Issue  Oracle APEX applications often need a way to capture a tutorial, a support issue, or a walkthrough directly from the browser, with the presenter’s webcam visible alongside…

Read More