-
Capturing Lat/Long Address Info Without a Map
The new APEX 21.2 Geocoded Address page item makes it easy to translate user-entered address information into a point you (or your user) can see on a map. After the user-entered address information has been geocoded and the user has confirmed which matching address is correct, the value of the Geocoded Address page item is the text of a GeoJSON document representing the point on the map for that address. Your application can decide whether the end-user will provide their address input in one of two ways: In either case, the country can be fixed by your application, or can…
-
Enhancing Existing APEX App with PWA, Nav Bar Items & Smart Filters
I was excited to try three powerful new no-code-required APEX 21.2 features in my art tracker application, and I finally had an hour to spare after work this week to give it a go. This article documents my successful attempt to evolve the showcase page from my existing app to leverage the space-saving Smart Filters search region, leaving more room for the cards that visualize the main application content. In the process I regained even more screen real estate by positioning items in the navigation bar using the new layout positions available in 21.2’s Universal Theme. And last but not…
-
Finding & Fixing Unindexed Foreign Keys
A colleague Martin showed me a cool feature of Oracle APEX this week to find missing foreign key indexes. Under SQL Workshop ⟶ Utilities ⟶ Object Reports, a number of helpful reports offer insights about your application’s database objects. As shown by the arrow in the figure below, one of these is the Unindexed Foreign Keys exception report. Clicking on this report type shows a list of any foreign keys missing an index. This useful result highlighted a number of opportunities to potentially improve the performance of my application. However, as I continue to find, Oracle APEX has an ace…
-
Create an ORDS REST Service with Custom JSON In and Out
As I’ve been getting up to speed with ORDS REST services over the last couple weeks, Tim Hall’s Oracle-Base tutorial about REST services basics proved very helpful. I started by experimenting with ORDS’ support for automatic handling of different built-in datatypes to and from JSON. In many cases, this lets you focus on your core PL/SQL logic without having to work directly with JSON. However, to make sure I was understanding all the moving parts, I set myself the task of creating a service that could process an arbitrary JSON document as the request and return back an arbitrary JSON…
-
Mixing Positional & Named Params Can Lead to Trouble
Mixing positional and named parameters can lead to trouble.
Skip to content
Dive Into APEX 