Stop Processing One Row at a Time If you have been writing Oracle PL/SQL for any length...
PL/SQL Gems
The Null Handling Landscape NULL handling is one of the most frequent sources of subtle bugs in...
The Context Switch Tax When you call a PL/SQL function from a SQL statement, Oracle must switch...
What Does Deterministic Mean? A function is deterministic if it always returns the same output for the...
The Mutating Table Problem Explained If you have worked with Oracle row level triggers, you have likely...
Taming Complex SQL The WITH clause, also known as Common Table Expressions (CTEs), lets you define named...
Finding the Real Bottleneck When a PL/SQL procedure runs slowly, developers often guess at the bottleneck and...
Powerful Pattern Matching in SQL Oracle’s regular expression functions, available since 10g, provide POSIX-compliant pattern matching directly...
When You Need Dynamic SQL Most PL/SQL uses static SQL where the statement is known at compile...
SQL’s Most Underused Power Feature Analytic functions (also called window functions) let you perform calculations across a...