Hassan Raza

Home - Hassan Raza
Oracle APEX Banner to Instantly Avoid Dev vs Prod Mistakes

Oracle APEX Banner to Instantly Avoid Dev vs Prod Mistakes

Working across DEV, TEST, and PROD in Oracle APEX without clear visual indicators is a disaster waiting to happen. In this post I walk through building an environment-aware banner that sits on Page 0 and shows across your entire application, displaying live schema name, APEX version, database version, and current timestamp. It uses a PL/SQL Dynamic Content region, an authorization scheme to hide it in production, and animated CSS gradient styling to make it impossible to miss.

READ MORE
How I Built a Smart Task Tracker in Oracle APEX Without Opening Each Row

How I Built a Smart Task Tracker in Oracle APEX Without Opening Each Row

Opening a dialog for every single task update is painful when you have 20 tasks to process. In this post I walk through how I built a one-click task completion system directly inside an Oracle APEX Classic Report, no dialogs, no page refreshes. Using embedded HTML buttons with data attributes, a Dynamic Action with jQuery selector, and a clean UPSERT pattern in PL/SQL, users click once and the button turns green instantly. Here is exactly how it works.

READ MORE
Building a Premium Ramadan Calendar in Oracle APEX

Building a Premium Ramadan Calendar in Oracle APEX

Building something meaningful in Oracle APEX does not always mean a data table and a sidebar. This year I built a full interactive Ramadan Calendar inside Oracle APEX with no external plugins, no iframes, and no third-party libraries. Just CSS Grid, JavaScript date logic, and APEX dynamic actions. It supports multiple countries with different Ramadan start dates, a premium dark sidebar with Arabic Quranic verse, and auto-calculated Lailat-ul-Qadr and Eid al-Fitr. Here is exactly how I built it.

READ MORE
Call External HTTPS APIs with Oracle Wallet

Call External HTTPS APIs with Oracle Wallet

Calling external HTTPS APIs from Oracle APEX requires more than just writing a UTL_HTTP request. You need an Oracle wallet, the right SSL certificate imported, and network ACL access configured before anything works. This guide walks through the complete setup from creating the wallet directory and importing the certificate, to granting database network access, storing connection parameters properly, and testing the connection before wiring it into APEX.

READ MORE
Oracle Dev Gym

The Oracle Dev Gym

Oracle Dev Gym is a free learning platform built by Oracle with 2,400+ quizzes covering SQL, PL/SQL, database design, and Oracle APEX. In this post I share why I personally use it, what makes it different from just reading documentation, and how features like weekly tournaments, workouts, classes, and the SQuizL game actually make you a better Oracle developer through real practice.

READ MORE
A Centralized Error Logging Framework for Oracle APEX

A Centralized Error Logging Framework for Oracle APEX

Most Oracle APEX developers rely on APEX_DEBUG for troubleshooting, but it stops working the moment a session ends and has zero reach inside DBMS_SCHEDULER background jobs. In this article I walk through apex-error-logger, an open-source PL/SQL framework I built that captures errors, call stacks, and full APEX session context automatically using PRAGMA AUTONOMOUS_TRANSACTION, so your logs survive even when the main transaction rolls back. Includes real code, scheduler integration, and a ready-to-use APEX Interactive Report log viewer.

READ MORE