Phil Grinham

@PhilGrinham

Certified Oracle Developer

Joined July 2023

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

Phil Grinham's Blogphilgrinham.hashnode.dev17 posts

Articles Comments

Recently published

PGPhil Grinhamphilgrinham.hashnode.devApr 22 · 3 min read

Stop using APEX_ITEM.CHECKBOX2

Introduction This is a quick tip if you are still using the APEX_ITEM.CHECKBOX2 function embedded in your reports' SQL. SELECT APEX_ITEM.CHECKBOX2(P_IDX => 10, P_VALUE => ID) AS CHKBOX, ...... FROM

0

PGPhil Grinhamphilgrinham.hashnode.devMar 16 · 6 min read

Reverse Engineering Interactive Reports/Grids using APEX_REGION and APEX_EXEC

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

0

PGPhil Grinhamphilgrinham.hashnode.devNov 8, 2025 · 4 min read

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...

0

PGPhil Grinhamphilgrinham.hashnode.devJul 2, 2025 · 4 min read

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 as a stand-alone article on LinkedIn but decided it...

0

PGPhil Grinhamphilgrinham.hashnode.devJun 19, 2025 · 3 min read

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...

0

Phil Grinham

About

Available for

Phil Grinham's blogs

Recently published

Stop using APEX_ITEM.CHECKBOX2

Reverse Engineering Interactive Reports/Grids using APEX_REGION and APEX_EXEC

Oracle APEX - Seeing Execution Chain History

Dynamic Landing Pages in APEX

Virtual Columns No Longer Have to Be Virtual: Materialized Expression Columns in Oracle 23ai

Search Hashnode

Phil Grinham

About

Available for

Phil Grinham's blogs

Recently published

Stop using APEX_ITEM.CHECKBOX2

Reverse Engineering Interactive Reports/Grids using APEX_REGION and APEX_EXEC

Oracle APEX - Seeing Execution Chain History

Dynamic Landing Pages in APEX

Virtual Columns No Longer Have to Be Virtual: Materialized Expression Columns in Oracle 23ai