APEX

To me, the way an APEX application looks, could be the key to making people use it. There are many examples where a great app with great features is unpopular, simply because it doesn’t bring the best user experience. A simple fact about APEX and the developers using it is … Continue reading 5 tips to help you build better APEX user interfaces →

Part 2: Accessing your secure REST API In Part 1 of the “ORDS, APEX and secure REST APIs” blog post, we looked at the ways you can secure your REST modules. Now that we have secured the API, let’s look at the ways you could access it. There are different … Continue reading ORDS, APEX and secure REST APIs (Part 2 – call the API) →

Part 1: Securing your REST API Some time ago we created a simple REST API using APEX RESTful Services to serve us for some reports. I wouldn’t go into details on how to create such, as there are many sources out there describing how to create a REST service in … Continue reading ORDS, APEX and secure REST APIs (Part 1 – secure the API) →

Social Sign-in has been around since APEX version 18. And with small differences, the main concepts regarding Single Sign On in APEX using Facebook, Google, Microsoft, OKTA or any other 3rd party authentication provider have been the same. There are numerous blog post I have read and videos watched during … Continue reading OKTA authentication for APEX in 5 minutes →

Redwood theme Redwood background textures and APEX CDN Background textures integration Link to DEMO

Adding favicon for your application *Note that the filenames should match the ones you have uploaded into Application Static Files earlier. Adding custom application icon in APEX Builder Bonus icon

Introduction & helpful links Modifying APEX charts colours Modifying APEX charts bar width, donut radius, etc. Other chart attributes

Present and future of Markdown in APEX https://www.markdownguide.org/getting-started/https://blog.bit.ai/what-is-markdown/ Several ways you can utilise Markdown in APEX version 20.2 What’s new in the latest version of APEX – 21.1 Add Markdown support to all your regions Markdown in APEX 20.2 vs 21.1

Switching your application theme is getting more and more popular in recent years. APEX apps and their users are no exception. Most of our devices support this feature, APEX itself introduced dark and light mode for the Application Builder too. I am going to show you a quick way of … Continue reading Auto switch Dark & Light modes of your APEX app →

It happens that you forget your master ADMIN password for the apex_admin page. Here are the two widely user methods to change it and unlock the Admin account: Use @apxchpwd.sql script in your APEX directory. To run it, navigate to the directory through bash or Command prompt. Connect to your … Continue reading Unlock APEX Admin account →

It happens relatively rarely to have an error PLS-00907 (PLS-00907: Can not load library unit). We have encountered it few times in our APEX applications. Here is the way to resolve it (performed by a SYS user). Solution : Ask your DB admin to flush the shared pool 🙂

By default, if you use embedded PL/SQL gateway to run your APEX, PDF printing is not possible. There are several ways to make it possible. By configuring ORDS and running it in either Standalone mode or into Apache Tomcat / Glassfish / or other web server. This option is completely … Continue reading Print PDF reports with APEX 5.1 + ORDS →