In the last few weeks, Oracle ACEs from all around the globe have written or published over 550 blog posts and podcasts on various topics. Starting now, we will bring you top picks every week, focusing on various themes. This week’s focus is APEX – so here are our nine recommendations from the Oracle ACE Program members.
One authorization scheme for APEX interactive grids
In a previous article I showed you a way how you can manage the whole application security through user defined roles (and I mean defined by business users not by developers). Today I will show you how you can achieve the same with interactive grids. How you can use the same IS_USER role to manage which DML actions will be allowed on the grid for specific application role. I will be using the Tasks application and demonstrating it there.
Call PL/SQL APIs Declaratively from APEX Using the Invoke API Process
Until APEX 22.2, the primary method for calling code in a PL/SQL package from an APEX page process was to use the Execute Code page process type. In this post, I will describe the Invoke API process type, which allows you to call PL/SQL procedures and functions declaratively.
Low code development is in fashion, and there’s many offerings in the market that allow the power of low code development to be unlocked by the enterprise. The allure of low code is the time to market, where solutions, particularly web apps, can be quickly created by following a wizard, and can really be done by non-developers or “citizen” developers. Due to its benefits, many companies have adopted a low code strategy to supplement their existing software engineering offerings, where possible, specially where subject matter experts in the business could leverage low code in a self-service capacity, if the requirements aren’t too complex.
Last week, apex.oracle.com has been upgraded to Oracle APEX 23.1 letting us play with the new features built with ❤ by the APEX team. One of them is new Execution Chain process type that allows us to group page processes and choose between foreground or background execution. It’s a pretty interesting feature as it allows us to easily switch long processes to run in the background and monitor the execution using the new built-in apex_page_bg_proc_status view and apex_background_process package.
Oracle APEX CI/CD: Step-by-step guide aligned to the APEX Application Lifecycle Technical Paper
This blog will get you started with APEX CI/CD aligned to the APEX Technical Paper. If you have not already read the Oracle APEX Application Development Lifecycle Technical Paper I suggest you read it now (start at page 17) to become familiar with the approach. In this blog, we’re going to set this all up on Oracle Cloud as it’s the most convenient place to deploy a generic solution.
SSO – Single Sign-on in Oracle APEX | Switch between applications in Oracle APEX
SSO stands for Single Sign-On. It is an authentication mechanism that allows users to access multiple applications or services with a single set of login credentials. Instead of requiring users to enter a separate username and password for each application or service, SSO enables them to authenticate once and gain access to all the resources they are authorized to use. In Oracle APEX within a workspace when users have to work in multiple applications it is better to have this SSO option to avoid entering username and password everytime need to switch application.
APEX 23.1 Push Notifications – an exciting new PWA addition
As soon as I heard that version 23.1 of APEX is now available at apex.oracle.com, I knew it will be a good one. One of the most intriguing features is of course Declarative PWA Push Notifications – a new feature in the PWA feature set, started several releases ago. I have now added Push notifications to one of my personal apps on apex.oracle.com. Setup is very quick and straightforward and it works wonderfully.
APEX Dictionary Views: You Didn’t Know You Needed!
Dictionary views in APEX are similar to dictionary views in Oracle Database. They provide a way to access metadata about the application without having to query the underlying tables directly. Dictionary views are read-only views that can be used by developers, administrators, and other users to gather information about the application.
Quick and Easy APEX and ORDS Installation for Oracle Database 23c Developer Release on OCI
Are you ready to take your Oracle Database 23c experience to the next level? In this article, we’ll guide you through the simple steps to install APEX and ORDS for Oracle Database 23c on Oracle Linux 8 in the Oracle Cloud Infrastructure (OCI). With these powerful tools, you’ll be able to unlock the full potential of your database and explore the amazing world of APEX and SQL-Developer Web. So let’s get started!