{"product_id":"9780133798531","title":"Oracle PL\/SQL by Example","description":"\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®\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 \u003cp\u003e \u003c\/p\u003e \u003cp\u003eStep 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.\u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003eThis 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.\u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003eNew in This Edition\u003c\/p\u003e \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 \u003cp\u003e \u003c\/p\u003e \u003cp\u003eOther topics covered\u003c\/p\u003e \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 \u003cp\u003e \u003c\/p\u003e","brand":"Pearson Education","offers":[{"title":"Default Title","offer_id":47071870484720,"sku":"9780133798531","price":47.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780133798531_p0.jpg?v=1763641135","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780133798531","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}