Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in Sql, Pl/Sql, and Json Nuijten Alex

Level up your skill set to the latest that Oracle Database can offer. You'll discover built-in functionality that can save you massive amounts of time that otherwise would be spent reinventing the wheel. This book introduces features that are not well known that can transform your development efforts.

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 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. You'll learn about new join types, pattern matching across rows, Top N pagination (useful in