{"product_id":"oracle-plsql-by-example-9780138062835","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\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Benjamin Rosenzweig, Elena Rakhimov\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Oracle Press\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 05\/21\/2023\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 480\u003cbr\u003e\u003cb\u003eBinding Type:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 1.63lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.00h x 6.90w x 1.10d\u003cbr\u003e\u003cb\u003eISBN:\u003c\/b\u003e 9780138062835","brand":"Oracle Press","offers":[{"title":"Paperback","offer_id":40846654636147,"sku":"9.78014E+12","price":86.95,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0555\/9255\/0515\/products\/img_978c2c2b-af53-408d-8b86-db68fb52807b.jpg?v=1686143242","url":"https:\/\/bookstorenmore.com\/en-de\/products\/oracle-plsql-by-example-9780138062835","provider":"Bookstore N More","version":"1.0","type":"link"}