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 [...]
SQL injection remains one of the most exploited vulnerabilities in web applications, and Oracle APEX is no exception. Despite APEX’s built-in protections, poor use of dynamic PL/SQL and configuration mistakes can expose your application to attacks. In this article, we explore advanced techniques to prevent SQL injection attacks in APEX, going beyond basic measures like [...]
Now we need to move on to the JavaScript portion, which forms the core of our proposal: replacing the item's default validation with a fully customized solution tailored to our specific requirements. This step is crucial, as it allows us to override Oracle APEX’s standard validation behavior and implement logic that aligns with the unique [...]
In our previous article, we briefly introduced custom attributes, but you might be wondering—what exactly are they and why do they matter? Custom attributes in Oracle APEX plugins are user-defined settings that empower developers to significantly extend and customize a plugin's behavior, appearance, and functionality. Defined explicitly when creating the plugin, these attributes become part [...]
Oracle APEX plugins are a powerful way to extend the platform’s functionality, allowing developers to create custom behaviors, components, and validations tailored to specific needs. In this post, we’ll guide you step by step through the process of building an Oracle APEX plugin. By the end, you’ll have a strong foundation for creating dynamic, reusable [...]
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 APEX is an incredibly powerful platform for building web applications, and one of its standout features is the ability to create custom plugins. This post explores an introductory example of implementing custom validation logic for text fields using an Oracle APEX plugin, combining both server-side and client-side logic to deliver flexibility and a seamless [...]
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 [...]
One of the most rewarding aspects of our industry is the continuous opportunity to learn and tackle new challenges with cutting-edge technologies throughout your career. These advancements often come swiftly, requiring us to stay prepared and adaptable. Oracle has accelerated its pace, possibly due to Oracle APEX, and is increasingly proactive in ensuring their innovations [...]
