Rise with APEX

Oracle APEX 26.1 new in this release Oracle APEX Data Reporter: A Smarter Approach to Dynamic Reporting I tried the new reporting module for a few days. Here is what it actually is, in plain words. Report requests in one week 4 open MON Sales by branch for the last 6 months MON Same report, but remove the test data WED Can you group it by region instead? FRI Actually we need it every week now Four requests. One report. And I did not open Page Designer once. Posted on 18 September 2026 Read time 4 minutes Topic Oracle APEX reporting In every APEX project I have worked on, the report request list keeps growing. It never really gets shorter. Someone asks for a small report, it takes days to reach them because of tickets and reviews, and by the time it is ready they have already moved on to a different question. APEX 26.1 has a new module called Data R...

Oracle APEX Beyond the Grid: Export Selected Rows to Excel and PDF in Oracle APEX A little while back I got a task that sounded simple on paper: let the user tick a few rows in an Interactive Grid and export only those rows, not the whole report. It took longer than expected, and I learned a few things the hard way. Writing this down for future reference — sharing it here in case it saves someone a few hours. ROW_01 — THE REQUIREMENT The Requirement The ask was straightforward: an Interactive Grid showing employee data, the user checks the rows they care about, clicks Export Excel or Export PDF, and only the checked rows end up in the file. No full grid dump, no separate export page. My first thought was that this must already exist in APEX. Interactive Reports and Interactive Grids both ship a built-in export — but both export whatever is currently visible or filtered, never just the checked rows. There's no native "export selection only...

How I built my own captcha in Oracle APEX without using any third party service Posted by Jefith For a long time I was using a normal third party captcha in my APEX app just like everyone does. It worked fine but I never liked depending on an outside service for something this small. One day I thought why not just build my own small captcha inside APEX itself using PL/SQL. So I started trying it and it took me a good few days of testing and fixing errors before it finally worked properly. In this post I am writing down the whole process, the mistakes I made and how I solved them, so if you are trying the same thing you will not waste as much time as I did. Why I did not want a normal image captcha First I thought I will generate a distorted image captcha like the usual ones with random letters. But PL/SQL does not have any proper way to draw text on an image directly, there is no built in font rendering. I tried searching if the...

I built a Before / After Image Slider in Oracle APEX and here is how it actually went Oracle APEX JavaScript UI Component Why I even tried this I had a page in my APEX app where I wanted to show a before and after image, the kind you see on design and photo editing sites where you drag a handle in the middle and the picture changes. APEX does not give you this out of the box, so I had to build it myself using a plain static content region. This post is basically my notes while I was building it, including the parts that failed. The first problem I ran into My first idea was simple. Put two images on top of each other, absolute position both of them, and just change the width of the top one using a range input. Sounds easy right. I tried this and the slider itself worked, but the image quality looked broken while dragging. The "before" image was getting squashed and stretched because when I reduced the width of its wrapper di...

Rise With Apex · Oracle APEX 26.1 Beyond Pins: Live Clustered Maps in Oracle APEX A build log, written while actually building it 01 Base data 02 REST feed 03 Clustering 04 Custom pins 05 Live refresh 06 Dark mode bug 07 Takeaways I started this because the normal APEX Map Region was giving me a plain page with dots on it and nothing else. No clustering, no live updates, no custom colors for different asset status. Just a map with pins sitting there. I needed something that actually looked alive, showing trucks, stores and sensors moving and updating on their own without me refreshing the page every few seconds. So I decided to skip the built in Map Region completely and build the whole thing with Leaflet.js on top of an ORDS REST endpoint instead. This post is basically my notes from that process, the parts that worked, and a good number of parts that did not work on the f...