Learn how to set up Oracle APEX on Oracle Cloud Free Tier step by step. From creating your account to building your first app, this guide covers everything a beginner needs.
I built a free, open source Oracle APEX plug-in that adds coordinate-aware zooming, panning, and fullscreen support to any image region. No JavaScript knowledge needed. Just import and use.
Most enterprise Oracle APEX applications manage data well but stay completely silent when it comes to communicating with users outside the system. In this tutorial I walk through integrating WhatsApp directly into Oracle APEX using WAAPI, n8n, and ORDS. We cover the full stack: Oracle Wallet SSL configuration with orapki, network ACL setup, PL/SQL messaging package, ORDS REST endpoint creation, n8n webhook workflow, and the APEX chat UI. Everything from the first certificate import to a live two-way WhatsApp conversation inside your APEX application.
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.
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.
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.
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.
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.
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.