Oracle PL/SQL by Example

<p>Using PL/SQL for Oracle Database 21c you can build solutions that deliver unprecedented performance and efficiency in any environment including the cloud. <em>Oracle PL/SQL by Example</em> 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.</p> <p>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.</p> <p>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.</p> <p><strong>New in This Edition</strong></p> <ul> <li>Updated code examples throughout</li> <li>New iteration controls for the FOR LOOP statement such as stepped range multiple iterations collection and cursor iterations</li> <li>Enhancements for PL/SQL qualified expressions</li> <li>Performance enhancements for PL/SQL functions such as SQL macro and better control of the result cache</li> </ul> <p><strong>Other Topics Covered</strong></p> <ul> <li>Mastering basic PL/SQL concepts and language fundamentals and understanding SQL's role in PL/SQL</li> <li>Using conditional and iterative program controls</li> <li>Efficiently handling errors and exceptions</li> <li>Working with cursors and triggers including compound triggers</li> <li>Using stored procedures functions and packages to write modular code that other programs can run</li> <li>Working with collections object-relational features native dynamic SQL bulk SQL and other advanced features</li> </ul>