SQL Window Functions: The Patterns Worth Knowing in Oracle
The seven window-function patterns I actually use in production Oracle SQL — running totals, ranking, top-N-per-group, period comparisons, and more.
Read post →
Category
SQL & PL/SQL
2 posts in this category.
PL/SQL Patterns That Pay Off in Real Projects
Eight practical PL/SQL patterns that consistently make production code faster, safer, and easier to maintain — with examples.
Read post →