Oracle PL/SQL by Example (5th Edition) (Prentice Hall Professional Oracle Series)

Using PL/SQL for Oracle Database 12c, you can build solutions that deliver unprecedented performance and efficiency in any environment, including the cloud. Oracle® PL/SQL by Example, Fifth Edition, 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.

 

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 12csolutions reference.

 

Other topics covered

• Mastering basic PL/SQL concepts and language fundamentals, and understanding SQL’s role in PL/SQL
• Using conditional and iterative program control, including CONTINUE and CONTINUE WHEN
• 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