Styling APEX Report cells conditionally

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 Report, Interactive Report or Interactive … Continue reading Styling APEX Report cells conditionally

Creating a Chat region in Oracle APEX

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 just built-in components and a … Continue reading Creating a Chat region in Oracle APEX

Customizing Application Icons  in APEX 22.1

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 option available. Well, you can … Continue reading Customizing Application Icons  in APEX 22.1

Create a custom offline page for your APEX PWA in 21.2

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 (like Javascript and CSS files), … Continue reading Create a custom offline page for your APEX PWA in 21.2

Generating Documentation out of your PL/SQL packages

One of the things, often overlooked and missed in projects is good documentation. Benefits of having such are obvious, but many times developers simply skip it, because of the lack of time or managing multiple projects at a time. That's why I think that documenting should go along with the development and be a continuous … Continue reading Generating Documentation out of your PL/SQL packages

SQL Developer fix for MacBook with macOS Monterey

This article is aimed at people, using MacBook (with M1 ARM chips and macOS Monterey). The new 2021 MacBooks come with this macOS – Monterey, already pre-installed. The problem is probably affecting those machines using Intel processors (and macOS Monterey) too, but I can't confirm, since my setup is on a machine with M1 Pro … Continue reading SQL Developer fix for MacBook with macOS Monterey

5 tips to help you build better APEX user interfaces

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 that the majority of us … Continue reading 5 tips to help you build better APEX user interfaces

ORDS, APEX and secure REST APIs (Part 2 – call the API)

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 implementations and different tools in … Continue reading ORDS, APEX and secure REST APIs (Part 2 – call the API)

ORDS, APEX and secure REST APIs (Part 1 – secure 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 APEX. You could take a … Continue reading ORDS, APEX and secure REST APIs (Part 1 – secure the API)