@article{1454882,
      recid = {1454882},
      author = {Nuijten, Alex, and Barel, Patrick,},
      title = {Modern Oracle Database programming : level up your skill  set to Oracle's latest and most powerful features in SQL,  PL/SQL, and JSON /},
      pages = {1 online resource (576 pages) :},
      note = {Includes index.},
      abstract = {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. Youll  discover built-in functionality that can save you massive  amounts of time that otherwise would be spent reinventing  the wheel. Youll 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  functionalitythat their company has paid foron 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. Youll  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, polymorphic  table functions with return types determined by incoming  argument types, and constructing and parsing JSON documents  for data interchange with other systems. Part III  introduces a vast array of built-in functionality that  Oracle provides that is just waiting to be used.  Edition-based redefinition enables zero-downtime  application and schema upgrades. Data redaction enables  easier compliance with privacy laws and similar regulations  by protecting sensitive data from those who have no need to  see it. Virtual private databases provide the appearance of  giving each user their own database, again helping to  secure sensitive data. These features are just a taste of  what the book provides. Soon youll be improving your skills  and wondering why you ever worked so hard to solve problems  that Oracle Database already solves for you. What You Will  Learn Write more powerful code by incorporating underused  features in SQL and PL/SQL Optimize your integration  between SQL and PL/SQL for best performance Take advantage  of enhanced set operators, lateral joins, row-based pattern  matching, and other advanced features in SQL Make your code  easier to understand through your use of newer PL/SQL  features, such as qualified expressions and iterator  enhancements Integrate with web services and external data  sources directly from the database Create and parse JSON  documents for easy data exchange and flexible schema  design.},
      url = {http://library.usi.edu/record/1454882},
      doi = {https://doi.org/10.1007/978-1-4842-9166-5},
}