Pipelined Table Functions: When and Why to Use Them

PL/SQL Gems

Pipelined Table Functions: When and Why to Use Them

martin March 2, 2026

What Are Pipelined Table Functions? A pipelined table function is a PL/SQL function that returns a collection...

PL/SQL Gems

The Hidden Power of NOCOPY for OUT and IN OUT Parameters

martin March 2, 2026

Understanding How PL/SQL Passes Parameters When you call a PL/SQL procedure or function, the runtime engine must...

PL/SQL Gems

Edition Based Redefinition for Zero Downtime PL/SQL Deployments

martin March 2, 2026

The Challenge of Deploying PL/SQL Changes In a traditional Oracle deployment, updating a PL/SQL package body invalidates...

PL/SQL Gems

Using FORMAT_ERROR_BACKTRACE for Better Exception Handling

martin March 2, 2026

The Problem With Traditional Exception Handling Every PL/SQL developer has encountered this frustration: an exception fires, you...

PL/SQL Gems

Pattern Matching in SQL With MATCH_RECOGNIZE

martin March 2, 2026

Beyond Regular Expressions: Row Pattern Matching Most developers are familiar with regular expressions for matching patterns in...

PL/SQL Gems

Polymorphic Table Functions in Oracle 18c and Beyond

martin March 2, 2026

Functions That Adapt to Their Input Traditional table functions have a fixed return type. You define the...

PL/SQL Gems

Reusable Error Logging Packages With Autonomous Transactions

martin March 2, 2026

Why You Need a Centralized Error Logger Every production PL/SQL application needs a robust error logging mechanism....

PL/SQL Gems