APEX

Visit my DEMO PAGE and see the new Device Geolocation feature in action. 🌐 Device Geolocation Get Current Position Dynamic Action The new Get Current Position dynamic action fetches the device current location and returns a JavaScript GeoJSON object or Latitude and Longitude to page items, or the full Geolocation … Continue reading A glimpse of the APEX 22.2 new features – Device Geolocation →

Learn how to accelerate the development process by using the new Session Overrides APEX feature and one of the Visual Studio Code extensions.

See how I combined the APEX Geocoded Address item, several map layers, GeoJSON, SDO_UTIL and SDO_GEOMETRY packages to find nearest stadiums around

Comparing the APEX built-in Geocoded Address item with third party APIs for getting the best search results.

Learn more about the different Layer Types and Geometry Data Types used in the Maps region and why it’s important to know them all Why do you need to read this post? Having knowledge of the different types that represent a geometry can give you the opportunity to visualise more … Continue reading Understanding better the APEX Map Region →

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