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
Speed up your APEX development using Session Overrides and VS Code
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
How to find nearest stadiums using Oracle APEX maps and geolocation
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
Getting the best address and location searches in Oracle APEX
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
Understanding better the APEX Map Region
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
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
APEX validations: Email address
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
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