---
title: "Phil Grinham (@PhilGrinham) | Hashnode"
description: "Certified Oracle Developer. Read the latest articles by Phil Grinham on Hashnode."
url: "https://hashnode.com/@PhilGrinham"
---

@PhilGrinham

# Phil Grinham

@PhilGrinham · Joined July 2023

Certified Oracle Developer

[Website](https://www.philgrinham.com/)

### [Bubble Sorting Delimited Strings #JoelKallmanDay](https://philgrinham.hashnode.dev/bubble-sorting-delimited-strings-joelkallmanday?utm_source=hashnode&utm_medium=feed)

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

7 min read · [philgrinham.hashnode.dev](https://philgrinham.hashnode.dev/bubble-sorting-delimited-strings-joelkallmanday?utm_source=hashnode&utm_medium=feed)

[Oct 14](https://hashnode.com/posts/bubble-sorting-delimited-strings-joelkallmanday/6acf434447cc217465c77993)

### [Polymorphic Table Functions](https://philgrinham.hashnode.dev/polymorphic-table-functions?utm_source=hashnode&utm_medium=feed)

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

13 min read · [philgrinham.hashnode.dev](https://philgrinham.hashnode.dev/polymorphic-table-functions?utm_source=hashnode&utm_medium=feed)

[Jul 20](https://hashnode.com/posts/polymorphic-table-functions/6a5e6ac4eed13bc7725034d7)

### [Materialized Views: The Sweet Spot](https://philgrinham.hashnode.dev/materialized-views-the-sweet-spot?utm_source=hashnode&utm_medium=feed)

The Inspiration I recently read an article from the always excellent Connor McDonald that I highly recommend where he provided a solution on how to maintain a materialized view that needs to be "up to

9 min read · [philgrinham.hashnode.dev](https://philgrinham.hashnode.dev/materialized-views-the-sweet-spot?utm_source=hashnode&utm_medium=feed)

[Jun 30](https://hashnode.com/posts/materialized-views-the-sweet-spot/6a453454fbfc9f1ee09e7f17)

### [Stop using APEX\_ITEM.CHECKBOX2](https://philgrinham.hashnode.dev/stop-using-apex-item-checkbox2?utm_source=hashnode&utm_medium=feed)

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

3 min read · [philgrinham.hashnode.dev](https://philgrinham.hashnode.dev/stop-using-apex-item-checkbox2?utm_source=hashnode&utm_medium=feed)

[Apr 22](https://hashnode.com/posts/stop-using-apex-item-checkbox2/69e94bf999e680f3de2518ae)

### [Reverse Engineering Interactive Reports/Grids using APEX\_REGION and APEX\_EXEC](https://philgrinham.hashnode.dev/reverse-engineering-interactive-reports-grids-using-apex-region-and-apex-exec?utm_source=hashnode&utm_medium=feed)

Using APEX\_EXEC to see exactly what the user sees in their Interactive Report or Grid.

6 min read · [philgrinham.hashnode.dev](https://philgrinham.hashnode.dev/reverse-engineering-interactive-reports-grids-using-apex-region-and-apex-exec?utm_source=hashnode&utm_medium=feed)

[Mar 16](https://hashnode.com/posts/reverse-engineering-interactive-reports-grids-using-apex-region-and-apex-exec/69b7b19a9df8c8edfcd85548)
