APEX

I hate it when I can’t remember how I did certain thing in the past. And I have to spend precious time “reinventing the wheel” as the famous saying states. One of those things is conditionally change the text colour or background colour of certain cells in APEX Reports (Classic … Continue reading Styling APEX Report cells conditionally →

In this (and the next) blog posts I will demonstrate different techniques for validating user input in Oracle APEX. I bet you needed to validate an item – for example if the user has entered a valid e-mail address, a valid number, a valid name or phone number, a valid … Continue reading APEX validations: Email address →

Did you ever needed a chat region for your Oracle APEX application? There is actually a Classic Report Comments template that produces almost that. With few simple steps you can turn Comments template into a real chat. Follow the steps below to create an excellent Chat region in APEX using … Continue reading Creating a Chat region in Oracle APEX →

With version 22.1 of APEX, along with the many more top features, comes the ability to upload and modify your Application icon. If you have read my blog post Quick Tips: Add favicon and custom Application icon in APEX, I described the way I do it prior to having this new … Continue reading Customizing Application Icons  in APEX 22.1 →

With the new version (21.2) of APEX, came the built-in PWA support for your APEX applications. PWA stands for Progressive Web App and is a concept that allows your Web Application (an APEX app) to look like a Native App (an iOS or Android app). This includes local resources caching … Continue reading Create a custom offline page for your APEX PWA in 21.2 →

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 →