martin

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

Read More Read more about Using FORMAT_ERROR_BACKTRACE for Better Exception Handling

• Oracle APEX

Substitution Strings, Bind Variables, and Application Items: The Differences That Matter

martin March 2, 2026

Three Ways to Reference Values in APEX APEX provides multiple syntaxes for referencing page items, application items,...

Read More Read more about Substitution Strings, Bind Variables, and Application Items: The Differences That Matter

• Oracle APEX

Building a Reusable Confirm Before Submit Pattern With Dynamic Actions

martin March 2, 2026

Why Confirmation Dialogs Matter Destructive operations like deleting records, approving financial transactions, or submitting irreversible workflows should...

Read More Read more about Building a Reusable Confirm Before Submit Pattern With Dynamic Actions

• PL/SQL Gems

FORALL and SAVE EXCEPTIONS: Bulk DML That Does Not Stop on First Error

martin March 2, 2026

The Power and the Problem With FORALL The FORALL statement is the counterpart to BULK COLLECT on...

Read More Read more about FORALL and SAVE EXCEPTIONS: Bulk DML That Does Not Stop on First Error

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

Read More Read more about Reusable Error Logging Packages With Autonomous Transactions

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

Read More Read more about Polymorphic Table Functions in Oracle 18c and Beyond

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

Read More Read more about Pattern Matching in SQL With MATCH_RECOGNIZE

• PL/SQL Gems

Implicit Statement Results: Returning Result Sets Without Ref Cursors

martin March 2, 2026

The Old Way: Ref Cursors Everywhere For years, the standard approach to returning query results from a...

Read More Read more about Implicit Statement Results: Returning Result Sets Without Ref Cursors

• PL/SQL Gems

Using RESULT_CACHE on Functions: Effortless Performance and Its Gotchas

martin March 2, 2026

Cross Session Caching With Zero Application Code The PL/SQL function result cache, introduced in Oracle 11g, allows...

Read More Read more about Using RESULT_CACHE on Functions: Effortless Performance and Its Gotchas

• PL/SQL Gems

Writing Deterministic Functions and How the Optimizer Rewards You

martin March 2, 2026 0

What Does Deterministic Mean? A function is deterministic if it always returns the same output for the...

Read More Read more about Writing Deterministic Functions and How the Optimizer Rewards You