Bubble Sorting Delimited Strings #JoelKallmanDay
In 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 require
Phil Grinham's Blog
Latest articles
Oracle APEX - Seeing Execution Chain History
There 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...
Dynamic Landing Pages in APEX
How 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 a
Virtual Columns No Longer Have to Be Virtual: Materialized Expression Columns in Oracle 23ai
Virtual 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...
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, ...
Mind the Gaps - Partitioned Outer Joins
There 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, ...
Just Passing Through
Database 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...