Introduction In Oracle APEX 24.2, Automation has become a key feature for integrating event-driven workflows directly into your low-code applications. This post introduces what Automation is, when to use it, and how it simplifies routine tasks like sending emails, synchronizing data, or executing business logic, without needing a full PL/SQL background. What is APEX Automation? [...]
Introduction In a world where applications must be increasingly connected and interoperable, Oracle APEX and ORDS offer a robust platform for building and consuming RESTful APIs quickly, securely, and scalable. This tutorial walks you through how to build and consume an Oracle APEX REST API using ORDS, OAuth2, and both declarative and programmatic approaches. Basic [...]
Introduction Advanced Dynamic Actions in Oracle APEX extend beyond basic user interactions like showing or hiding fields, enabling or disabling components, or submitting forms. They support executing custom JavaScript code, asynchronous server-side processing using AJAX Callbacks, and dynamic manipulation of the Document Object Model (DOM). These features enhance user experience, improve performance, and enable the [...]
Introduction In Oracle APEX, there are situations where we need to manage temporary data before deciding whether to store it permanently. APEX Collections provides an efficient way to handle this by offering an in-memory storage mechanism that remains active throughout a user's session. Rather than immediately writing data to a database table, collections allow us [...]
Introduction Oracle APEX provides built-in dynamic actions that allow developers to perform basic interactions without writing custom JavaScript. These actions can be triggered by events such as clicking a button, changing the value of a field, or selecting an option from a dropdown. While these built-in features cover many everyday use cases, more complex interactions [...]
Oracle Forms: Past, Present, and Future Oracle Forms remains a critical component of many companies' IT infrastructure. However, its technology is undeniably aging, and Oracle is gradually shifting focus toward modern alternatives. Instead, Oracle APEX (a free, low-code development platform) has emerged as the future-proof replacement. Challenges with Oracle Forms’ Support As of the end [...]
Introduction In my previous blog post (Oracle APEX Workflows Made Easy: Build & Automate your processes today), I introduced Oracle APEX Workflows and explained how to streamline business processes by automating task routing, approvals, and notifications with minimal coding, and setting up workflows using a simple, declarative approach. While Workflows aren’t hard to use, they [...]
Introduction Oracle APEX Workflow was officially introduced in Oracle APEX 23.1 (released in May 2023) to enable developers to automate business processes efficiently. It allows information, tasks, and documents to move between users according to predefined rules, simplifying operations and improving productivity. Some months later (October 2023) with APEX 23.2, Oracle introduced some improvements to [...]
