Oracle APEX: Reusable Queries Using SQL Macros only
Parameterized views, shared predicates and one report for many tables, without a single line of PL/SQL
Latest articles
Adding Voice-to-Text to your Oracle APEX AI Agents #JoelKallmanDay
Introduction Oracle APEX 26.1 comes with a brand new AI Assistant region, and I have been playing with it a lot lately. It works great, but there is one thing that annoyed me quickly: I don't like typ
Oracle APEX: Apply Conditional Styling to Reports Using CSS only #JoelKallmanDay
Introduction One year without blogging 😳, that’s what I realized when I started writing this blog post for Joel Kallman Day… It has been another incredible year. I started speaking at Oracle conferences, co-launched a French-speaking podcast with my...
How to Use Server-Side JavaScript in Oracle APEX with Oracle 23ai #JoelKallmanDay
#JoelKallmanDay Every year in October, the Oracle Community shares technical (or non-technical) content to gain some attention. I began participating in 2021 with my (almost) first post on this blog. I remember feeling like I was part of something. A...
How to Synchronize Oracle Identity Column Sequences
Introduction Many customers are moving data from production environments to lower environments like development or testing. During this process, they often overlook the primary key and simply import the records. Consequently, when they try to add new...
How to Easily Download Files in Oracle APEX 24.1
Introduction As you may know, Oracle APEX 24.1 is now generally available, and I started to spot the new features. One of them is the improvement in file downloads with a brand new dynamic action, page process type and a PL/SQL API! Let's take a look...
Oracle APEX 23.2 - Calendar region enhancements
FullCalendar library upgraded to 6.1.8
Oracle APEX 23.2 - Store Static Resources in Object Storage
Introduction A few days ago, I was looking at the What's New page again for 23.2 and I noticed something that I totally missed, the ability to store Static Resources in Object Storage instead of the traditional Shared Component location The main adv...
Oracle APEX 23.2 - Mastering QR Codes and Barcodes
Introduction With Oracle APEX 23.2, the Oracle APEX team introduces the new QR Code item type and the new apex_barcode PL/SQL API. Previously, it was possible to generate QR codes in Oracle APEX, but it was necessary to use a third-party library. Now...
