Oracle PL/SQL by Example

Oracle PL/SQL by Example

<p style="margin:0px;">Using PL/SQL for Oracle Database 12<i>c</i>, you can build solutions that deliver unprecedented performance and efficiency in any environment, including the cloud. <i> <b>Oracle^® PL/SQL by Example, Fifth Edition,</b> </i> teaches all the PL/SQL skills you’ll need, through real-world labs, extensive examples, exercises, and projects. Now fully updated for the newest version of PL/SQL, it covers everything from basic syntax and program control through the latest optimization and security enhancements.</p> <p style="margin:0px;"> </p> <p style="margin:0px;" msonormal="">Step by step, you’ll walk through every key task, mastering today’s most valuable Oracle 12<i>c</i>PL/SQL programming techniques on your own. Start by downloading projects and exercises from informit.com/title/0133796787. Once you’ve done an exercise, the authors don’t just present the answer: They offer an in-depth discussion introducing deeper insights and modern best practices.</p> <p style="margin:0px;"> </p> <p style="margin:0px;" msonormal="">This book’s approach fully reflects the authors’ award-winning experience teaching PL/SQL to professionals at Columbia University. 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 12<i>c</i>solutions reference.</p> <p style="margin:0px;"> </p> <p style="margin:0px;" msonormal="">New in This Edition</p> <ul> <li>Updated code examples throughout</li> <li>Result-caching of invoker’s right functions for better performance</li> <li>Extended support for PL/SQL-only data types in dynamic SQL, OCI, and JDBC</li> <li>Security enhancements, including ACCESSIBLE BY whitelists, improved privilege control, and Invisible Columns</li> </ul> <p style="margin:0px;"> </p> <p style="margin:0px;" msonormal="">Other topics covered</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 control, including CONTINUE and CONTINUE WHEN</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> <p style="margin:0px;"> </p>