@PhilGrinham
About
I am a Certified Senior Oracle Developer/Data Architect with a passion for all things data and an advocate for the Oracle APEX low code platform that I have seen mature to become a fully-fledged enterprise level solution. I have several decades of experience in multiple industries such as Finance, Energy and the Public Sector and hope that I can impart some of that experience in my blog posts.
Available for
Nothing here yet.
Phil Grinham's blogs
Recently published
Reverse Engineering Interactive Reports/Grids using APEX_REGION and APEX_EXEC
Mar 16 · 6 min read · Have you ever needed to see exactly what the user is seeing in an interactive report (IR) or grid (IG) in their current session? You obviously know what query/view/table you used to create the IR or I
Join discussion
Oracle APEX - Seeing Execution Chain History
Nov 8, 2025 · 4 min read · 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...
Join discussion
Dynamic Landing Pages in APEX
Jul 2, 2025 · 4 min read · 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 as a stand-alone article on LinkedIn but decided it...
Join discussion
Virtual Columns No Longer Have to Be Virtual: Materialized Expression Columns in Oracle 23ai
Jun 19, 2025 · 3 min read · 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...
Join discussion