Phil Grinham's Blog
Mind the Gaps - Partitioned Outer Joins

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

Phil Grinham
Phil Grinham
4 min read
Just Passing Through

Just Passing Through

Phil Grinham
Phil Grinham
6 min read
Oracle APEX Template Directives - Directing More Than Just Templates

Oracle APEX Template Directives - Directing More Than Just Templates

Phil Grinham
Phil Grinham
2 min read
Phil Grinham

Phil Grinham

21 followers

I am a Certified Senior Oracle Developer and Data Architect with a passion for Oracle APEX and have several decades of experience crossing multiple industries such as Finance and Energy.

Oracle APEX Theme Update Left Me Spinning.

Oracle APEX Theme Update Left Me Spinning.

Phil Grinham
3 min read
Leaping into action to resolve a date error

Leaping into action to resolve a date error

Phil Grinham
1 min read
APEX_COLLECTIONS - are you getting invalid datatype errors?

APEX_COLLECTIONS - are you getting invalid datatype errors?

Phil Grinham
6 min read
SQL Macros - Pipelined Function killers?

SQL Macros - Pipelined Function killers?

Phil Grinham
4 min read
Exploring Progressive Web Applications with Oracle APEX

Exploring Progressive Web Applications with Oracle APEX

Phil Grinham
5 min read
Re-purposing Inline Help in Oracle APEX

Re-purposing Inline Help in Oracle APEX

Phil Grinham
3 min read
Recursive CTE's

Recursive CTE's

Phil Grinham
4 min read
Querying view definitions in Oracle and those pesky LONG datatypes

Querying view definitions in Oracle and those pesky LONG datatypes

Phil Grinham
6 min read