Oracle PLSQL by Example (The Oracle Press Database and Data Science)

Step by step, you'll walk through every key task, mastering today's most valuable Oracle 21c PL/SQL programming techniques on your own. Start by downloading the supporting schema and exercises from informit.com/title/9780138062835. Once you've done an exercise, the author doesn't just present the answer: She offers an in-depth discussion introducing deeper insights and modern best practices.
This book's approach fully reflects the author's award-winning experience teaching PL/SQL to professionals at Columbia University in New York City. New database developers and DBAs can use it to get productive fast; experienced PL/SQL programmers will find it to be a superb Oracle Database 21c solutions reference.
New in This Edition
Updated code examples throughout
New iteration controls for the FOR LOOP statement, such as stepped range, multiple iterations, collection, and cursor iterations
Enhancements for PL/SQL qualified expressions
Performance enhancements for PL/SQL functions, such as SQL macro, and better control of the result cache
Other Topics Covered
Mastering basic PL/SQL concepts and language fundamentals, and understanding SQL's role in PL/SQL
Using conditional and iterative program controls
Efficiently handling errors and exceptions
Working with cursors and triggers, including compound triggers
Using stored procedures, functions, and packages to write modular code that other programs can run
Working with collections, object-relational features, native dynamic SQL, bulk SQL, and other advanced features