Bubble Sorting Delimited Strings #JoelKallmanDayIn honor Joel and all he did for the Oracle community, this is a quick blog post on a solution to the problem of sorting a delimited string. The basic premise is a common headache where we are requireOct 14, 2026·7 min read
Oracle APEX - Seeing Execution Chain HistoryThere are many excellent blogs already out there that explain what execution chains are and how to use them in Oracle APEX and I encourage those unfamiliar with the concept to read them. What I will say is that, in my opinion, their biggest advantage...Nov 8, 2025·4 min read
Dynamic Landing Pages in APEXHow to make a common "landing page" in Oracle APEX that presents child navigation menu options as a card region that updates automatically as entries are added or removed. I initially published this aJul 2, 2025·4 min read
Virtual Columns No Longer Have to Be Virtual: Materialized Expression Columns in Oracle 23aiVirtual columns were introduced in Oracle 11g to conveniently include computed logic directly in a table, appearing just like any other column. The expression used must be deterministic, meaning it must always produce the same result given the same i...Jun 19, 2025·3 min read
Leveraging one of 23ai's new features - the VECTOR datatype.There are many fantastic blogs about using Oracle 23ai as a powerful tool to take advantage of the growing interest in artificial intelligence. For example, the excellent Oracle ACE Jonathan Dixon has a website that collects blogs related to Oracle, ...Mar 3, 2025·10 min read
Mind the Gaps - Partitioned Outer JoinsThere are many ways developers can write code to handle sparsely populated data and fill the gaps. One method that is sometimes overlooked is the Partitioned Outer Join. The name might suggest it only works on data physically partitioned in a table, ...Aug 30, 2024·4 min read
Just Passing ThroughDatabase links have been a key feature of the Oracle database for a long time, allowing one database instance to interact with another. These "remote" databases do not have to be Oracle databases; the heterogeneous gateway allows for ODBC connectivit...Jul 22, 2024·6 min read
