书目名称 | Modern Oracle Database Programming |
副标题 | Level Up Your Skill |
编辑 | Alex Nuijten,Patrick Barel |
视频video | |
概述 | Shows the modern approach to programming in PL/SQL.Covers underused features that are too powerful not to use.Opens your eyes to a wealth of built-in functionality that many ignore |
图书封面 |  |
描述 | Level up your skill set to the latest that Oracle Database can offer. This book introduces features that are not well known that can transform your development efforts. You’ll discover built-in functionality that can save you massive amounts of time that otherwise would be spent reinventing the wheel. You’ll find that what used to take a lot of programming some years ago can be done with less code in a more reliable way today. Anyone using Oracle Database without the knowledge in this book is leaving valuable functionality–that their company has paid for–on the table, and this book opens the door to that functionality so that you can deliver reliable and performant solutions faster and more easily than ever..Part I looks at features in SQL and PL/SQL that are underused and not well known. You’ll learn about new join types, pattern matching across rows, Top N pagination (useful in reporting!), qualified expressions, and enhancements to iterators that reduce code complexity and make your logic easier to understand..Part II covers how and when to invoke PL/SQL from SQL while maintaining performance. You‘ll learn about SQL macro functions for creating reusable SQL fragments, polymorphi |
出版日期 | Book 2023 |
关键词 | Oracle Database; PL/SQL; SQL; Oracle PL/SQL Programming; Lateral Joins; JSON; Analytic Functions; Applicati |
版次 | 1 |
doi | https://doi.org/10.1007/978-1-4842-9166-5 |
isbn_softcover | 978-1-4842-9165-8 |
isbn_ebook | 978-1-4842-9166-5 |
copyright | Alex Nuijten, Patrick Barel 2023 |