{"product_id":"oracle-pl-sql-by-example","title":"Oracle Pl Sql By Example","description":"\u003cp\u003eUsing PL\/SQL for Oracle Database 21c, you can build solutions that deliver unprecedented performance and efficiency in any environment, including the cloud. \u003cem\u003eOracle PL\/SQL by Example\u003c\/em\u003e, Sixth Edition, teaches all the PL\/SQL skills you''ll need, through real-world labs and extensive examples. Now fully updated for the newest version of PL\/SQL 21c, it covers everything from basic syntax and program control through the latest optimization and tuning enhancements.\u003c\/p\u003e \u003cp\u003eStep by step, you''ll walk through every key task, mastering today''s most valuable Oracle 21c PL\/SQL programming techniques on your own. Start by downloading the supporting schema and exercises from informit.com\/title\/9780138062835. Once you''ve done an exercise, the author doesn''t just present the answer: She offers an in-depth discussion introducing deeper insights and modern best practices.\u003c\/p\u003e \u003cp\u003eThis book''s approach fully reflects the author''s award-winning experience teaching PL\/SQL to professionals at Columbia University in New York City. 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 21c solutions reference.\u003c\/p\u003e \u003cp\u003e\u003cstrong\u003eNew in This Edition\u003c\/strong\u003e\u003c\/p\u003e \u003cul\u003e  \u003cli\u003eUpdated code examples throughout\u003c\/li\u003e  \u003cli\u003eNew iteration controls for the FOR LOOP statement, such as stepped range, multiple iterations, collection, and cursor iterations\u003c\/li\u003e  \u003cli\u003eEnhancements for PL\/SQL qualified expressions\u003c\/li\u003e  \u003cli\u003ePerformance enhancements for PL\/SQL functions, such as SQL macro, and better control of the result cache\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003cstrong\u003eOther Topics Covered\u003c\/strong\u003e\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 controls\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":"MediaPlace","offers":[{"title":"Default Title","offer_id":57393756766590,"sku":"NW9780138062835","price":62.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1379\/1261\/files\/9780138062835.jpg?v=1778652665","url":"https:\/\/mediaplace.com\/en-usa\/products\/oracle-pl-sql-by-example","provider":"MediaPlace","version":"1.0","type":"link"}