Rise with APEX

Real Time Collaborative Editing in Oracle APEX Interactive Grid How I got two users editing the same IG at the same time without breaking anything I have been working with Oracle APEX for a while now, mostly building internal tools for my team. One request that kept coming back was simple to say but hard to build. My users wanted to open the same Interactive Grid page from two different systems and see each other's changes without hitting refresh every time. This blog is basically my notes from that whole journey, including the parts where I got stuck. Why I started this In my office we have a shared planning grid where two or three people update rows almost at the same time. Earlier if one person saved a row, the other person had no idea unless they manually refreshed the page. Sometimes this caused both of them to overwrite each other's work. I wanted a small demo where changes made by one user in the Interactive Grid show up for another user almost instantl...

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...