top of page
Search

This week at RADAPEX - Country Select List and A Real World Problem Solved

Richard Dacre

Last week we blogged about some new small features within APEX 24.2 that are a massive help in our day to day jobs.


We thought it might be fun to share some of the cool things we’ve done this week. It could be anything from little time-saving hacks to interesting discoveries. We won’t post every week, but we’ll try to share a couple of things that might pique your interest.


One of them was the country selection list shown above which we implemented into one of how apps this week.


Country Select List:

Whilst this is in-built APEX functionality, we had a couple of "How did you do that?" questions... well heres how:


If you have a list of countries you can use your tables (as long as you have the two letter ISO code), alternatively install the Countries sample dataset below.


Within your application, create a new LOV as so:

Now within a page create a Select One or Select Many item type and point the LOV to the new shared component.


Running in the page, this is the output:

Simple as that!


Real World Problem Solved:


On site for a project, we were working through an existing application with reports of slowness. We were unaware of how long this had been "slow" or whether it was always slow.... it looks like it was always slow!


The query was a large SQL statement, with many database function calls, and a pivot, so I won't post it all here. The query was looking up country name.


Obviously, we looked at the explain plan etc, but one thing sprung to mind... Scaler Subquery caching.


Lots more information here that I will not recreate now but wrapping the first function in a (select ... from dual) reduced load time for many seconds to < 0.5 seconds (I still think it could be faster).


Again, a simple change has made a big impact.


Thats it for now.


A couple of other things worked on this week are LLMs with APEX and APEX Working Copies, but we will leave them for their own blogs in the coming weeks.

83 views

Recent Posts

See All
bottom of page