{"product_id":"oracle-pl-sql-by-example-9780138062835","title":"Oracle Pl\/SQL by Example","description":"\u003cp\u003e • Author(s): Benjamin Rosenzweig\u003cbr\u003e • Publisher: Oracle Press\u003cbr\u003e • Publisher Imprint: Oracle Press\u003cbr\u003e • BISAC: Database Administration \u0026amp; Management\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\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":"Oracle Press","offers":[{"title":"Paperback","offer_id":45036062146711,"sku":"9780138062835","price":5873.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0666\/3471\/1191\/files\/9780138062835.webp?v=1769212669","url":"https:\/\/atlanticbooks.com\/products\/oracle-pl-sql-by-example-9780138062835","provider":"Atlantic Books","version":"1.0","type":"link"}