Using PL SQL for Oracle Database 21c you can build solutions that deliver unprecedented performance and efficiency in any environment including the cloud Oracle PL SQL by Example Sixth Edition teaches all the PL SQL skills you ll need through real world labs and extensive examples Now fully updated for the newest version of PL SQL 21c it covers everything from basic syntax and program control through the latest optimization and tuning enhancements 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 EditionUpdated code examples throughoutNew iteration controls for the FOR LOOP statement such as stepped range multiple iterations collection and cursor iterationsEnhancements for PL SQL qualified expressionsPerformance enhancements for PL SQL functions such as SQL macro and better control of the result cacheOther Topics CoveredMastering basic PL SQL concepts and language fundamentals and understanding SQL s role in PL SQLUsing conditional and iterative program controlsEfficiently handling errors and exceptionsWorking with cursors and triggers including compound triggersUsing stored procedures functions and packages to write modular code that other programs can runWorking with collections object relational features native dynamic SQL bulk SQL and other advanced features