5 PL/SQL Mistakes I Made as a Junior Oracle Developer (And How to Fix Them)
Learn the common PL/SQL mistakes made by junior developers and how to fix them. Improve your Oracle database skills with these practical, real-world coding tips.
BioSig Pro: The Oracle APEX Signature Plugin I Built Because Nothing Else Worked
I searched for an Oracle APEX signature plugin and found broken 9-year-old code. So I built BioSig Pro from scratch. Free, open source, and actually works on mobile.
How to Set Up Oracle APEX on Oracle Cloud Free Tier (And Actually Build Something with It)
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 an Image Zoom Plug-in for Oracle APEX and I’m Making It Free
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.
Integrating WhatsApp into Oracle APEX Using WAAPI, n8n, and ORDS: A Complete End-to-End Tutorial
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.
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.
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.
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.
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.
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.