02350nam a2200193 a 4500 14421 14421 0137144229 (paperback) 9780137144228 (paperback) Rosenzweig, Benjamin. Oracle PL/SQL by Example / 4th ed. [S.l.] : Prentice Hall, 2008. 768 p. ; 4th edition. This integrated learning solution teaches all the Oracle PL/SQL skills you need, hands-on, through real-world labs, extensive examples, exercises, and projects! Completely updated for Oracle 11g, Oracle PL/SQL by Example , Fourth Edition covers all the fundamentals, from PL/SQL syntax and program control through packages and Oracle 11g’s significantly improved triggers.   One step at a time, you’ll walk through every key task, discovering the most important PL/SQL programming techniques on your own. Building on your hands-on learning, the authors share solutions that offer deeper insights and proven best practices. End-of-chapter projects bring together all the techniques you’ve learned, strengthening your understanding through real-world practice.   This book’s approach fully reflects the authors’ award-winning experience teaching PL/SQL programming to professionals at Columbia University. New database developers and DBAs can use its step-by-step instructions to get productive fast; experienced PL/SQL programmers can use this book as a practical solutions reference. Coverage includes         • Mastering basic PL/SQL concepts and general programming language fundamentals, and understanding SQL’s role in           PL/SQL         • Using conditional and iterative program control techniques, including the new CONTINUE and CONTINUE WHEN statements         • Efficiently handling errors and exceptions         • Working with cursors and triggers, including Oracle 11g’s powerful new compound triggers         • Using stored procedures, functions, and packages to write modular code that other programs can execute         • Working with collections, object-relational features, native dynamic SQL, bulk SQL, and other advanced PL/SQL capabilities         • Handy reference appendices: PL/ Oracle SQL Language BK 0 0 0 0 QUESTCL QUESTCL 2015-10-28 1417.00 0 005.133ROZ 52349 2015-10-28 00:00:00 2015-10-28 BK