Packages Are the Foundation of Good PL/SQL Architecture Standalone procedures and functions have their place, but packages...
PL/SQL Gems
Common SQL Mistakes That Kill Performance These ten SQL antipatterns appear frequently in APEX applications and cause...
When the Optimizer Needs Guidance Oracle’s cost-based optimizer (CBO) does an excellent job choosing execution plans for...
Three Collection Types, Three Use Cases PL/SQL provides three collection types, and choosing the right one for...
What Are REF CURSORs A REF CURSOR is a PL/SQL variable that holds a pointer to a...