{"product_id":"oracle-pl-sql-by-example-9780133796780","title":"Oracle PL\/SQL by Example","description":"\u003cp\u003e • Author(s): Benjamin Rosenzweig | Elena Rakhimov\u003cbr\u003e • Publisher: Pearson\u003cbr\u003e • Publisher Imprint: Pearson\u003cbr\u003e • BISAC: Database Administration \u0026amp; Management\u003c\/p\u003e\u003cp\u003eUsing PL\/SQL for Oracle Database 12\u003ci\u003ec\u003c\/i\u003e, you can build solutions that deliver unprecedented performance and efficiency in any environment, including the cloud. \u003ci\u003e\u003cb\u003eOracle\u003csup\u003e(R)\u003c\/sup\u003e PL\/SQL by Example, Fifth Edition, \u003c\/b\u003e\u003c\/i\u003e 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.\u003c\/p\u003e  Step by step, you'll walk through every key task, mastering today's most valuable Oracle 12\u003ci\u003ec\u003c\/i\u003ePL\/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.  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\u003ci\u003ec\u003c\/i\u003esolutions reference.  New in This Edition \u003cul\u003e \u003cli\u003eUpdated code examples throughout\u003c\/li\u003e \u003cli\u003eResult-caching of invoker's right functions for better performance\u003c\/li\u003e \u003cli\u003eExtended support for PL\/SQL-only data types in dynamic SQL, OCI, and JDBC\u003c\/li\u003e \u003cli\u003eSecurity enhancements, including ACCESSIBLE BY whitelists, improved privilege control, and Invisible Columns\u003c\/li\u003e \u003c\/ul\u003e  Other topics covered \u003cul\u003e \u003cli\u003eMastering basic PL\/SQL concepts and language fundamentals, and understanding SQL's role in PL\/SQL\u003c\/li\u003e \u003cli\u003eUsing conditional and iterative program control, including CONTINUE and CONTINUE WHEN\u003c\/li\u003e \u003cli\u003eEfficiently handling errors and exceptions\u003c\/li\u003e \u003cli\u003eWorking with cursors and triggers, including compound triggers\u003c\/li\u003e \u003cli\u003eUsing stored procedures, functions, and packages to write modular code that other programs can run\u003c\/li\u003e \u003cli\u003eWorking with collections, object-relational features, native dynamic SQL, bulk SQL, and other advanced features\u003c\/li\u003e \u003c\/ul\u003e ","brand":"Atlantic Books","offers":[{"title":"Paperback","offer_id":46486625517719,"sku":"9780133796780","price":5627.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0666\/3471\/1191\/files\/9780133796780.jpg?v=1766331276","url":"https:\/\/atlanticbooks.com\/products\/oracle-pl-sql-by-example-9780133796780","provider":"Atlantic Books","version":"1.0","type":"link"}