Building apps with ❤️ using Oracle 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 object to a custom JavaScript … 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. What is Session Overrides Session Overrides are a convenient way for developers to quickly change values in the session that the APEX engine is typically responsible for, like File Paths, Additional Files … Continue reading Speed up your APEX development using Session Overrides and VS Code
See how I combined the APEX Geocoded Address item, several map layers, GeoJSON, SDO_UTIL and SDO_GEOMETRY packages to find nearest stadiums around The use case In this article, I will show you a solution for a situation that I often have while travelling abroad - finding the nearest stadium around me to watch some sports … Continue reading How to find nearest stadiums using Oracle APEX maps and geolocation
Comparing the APEX built-in Geocoded Address item with third party APIs for getting the best search results. Geocoding and Reverse Geocoding - what is that? Geocoding is the process of taking an address or location and converting it to latitude and longitude geographic coordinates. Reverse Geocoding is the opposite - the process that takes a … Continue reading Getting the best address and location searches in Oracle APEX
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 and highly complex geometries on … 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 Report, Interactive Report or Interactive … 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 license plate, personal id number … 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 just built-in components and a … 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 option available. Well, you can … 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 (like Javascript and CSS files), … Continue reading Create a custom offline page for your APEX PWA in 21.2
APEX App Lab 