Search for a command to run...
Articles tagged with #oracle
As part of my ongoing preparation for an upcoming presentation on APEX items, I’m continuing the blog series that explores the fundamental, often underused capabilities of Oracle APEX. In the first post, we looked at the Server-side Condition attribu...
Preparing for a presentation on APEX items, I’m starting a new series of blog posts exploring the basic capabilities of APEX. The goal is to gain a deeper understanding of how things work behind the scenes and how we can make the most of them. This f...
Glad to see that the helper classes I missed in previous APEX versions—and had been discussing theoretically with the APEX Universal Theme team—have now been natively integrated into the latest version, 24.2. Sounds like a great opportunity to share ...
In a current project, I needed to calculate the date offset while excluding weekends. Initially, this was solved using a loop in PL/SQL, which I consider a less efficient approach. To optimize it, I created a straightforward SQL query that handles th...
As you might know, the map region feature was introduced in APEX 21.1 and further enhanced in 23.2, when custom map backgrounds were added to the supported feature list. While the MapLibre APEX implementation offers a robust set of declarative featur...
When working with Oracle APEX, one of the joys (and occasional challenges) is finding simple, elegant solutions to unique client requirements. Recently, I came across an interesting use case that I thought would be worth sharing. The Challenge The re...