Large Objects Are Different CLOBs (Character Large Objects) and BLOBs (Binary Large Objects) can store up to...
PL/SQL Gems
What Is an Autonomous Transaction An autonomous transaction is an independent transaction started within the context of...
Every Table Needs a Key Strategy Generating unique primary key values is a fundamental requirement for every...
SQL’s Most Underused Power Feature Analytic functions let you perform calculations across related rows without collapsing the...
Writing Code That Adapts to the Database Version If you maintain PL/SQL code that runs on multiple...
When You Need Dynamic SQL Most PL/SQL code uses static SQL, where the complete SQL statement is...
Exception Handling Gone Wrong PL/SQL’s exception handling mechanism is straightforward, but several common anti-patterns lead to bugs...
Three Collection Types, Three Use Cases PL/SQL provides three collection types. Choosing the right one affects both...
Large Objects Are Different CLOBs and BLOBs can store up to 128 terabytes per column value. While...
Beyond Simple Date Subtraction Oracle’s INTERVAL data types let you express and compute time durations precisely. While...