Polymorphic Table FunctionsIntroduced in Oracle 18c, the wonderfully named Polymorphic Table Function (PTF) feature took pipelined functions to a new level of abstraction. You may have heard the term Polymorphic used in object-Jul 20, 2026·13 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
Oracle APEX Template Directives - Directing More Than Just TemplatesThis is a quick blog post to show an easy way to use Template Directives in Oracle APEX as an alternative to common implementations of a specific problem. What problem is that? I have a report with a column that has a small set of distinct values, su...May 31, 2024·2 min read
