What Does Deterministic Mean? A function is deterministic if it always returns the same output for the...
PL/SQL Gems
The Mutating Table Problem Explained If you have worked with Oracle row level triggers, you have likely...
Stop Processing One Row at a Time If you have been writing Oracle PL/SQL for any length...
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...
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...