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

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, 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 you'll 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

Who This Book Is For
Any developer who is writing SQL or PL/SQL, PL/SQL experts who want to level up their knowledge and skills to the latest features that Oracle Database provides, and developers who don't want to write their own solutions only to find out later that they've wasted their time by building something that Oracle Database provides out of the box

提升你的技能，掌握 Oracle Database 最新的功能。本書介紹了一些不太被人熟知的功能，可以改變你的開發方式。你將發現內建的功能可以節省大量時間，否則你可能會浪費在重新發明輪子上。你會發現，以前需要大量編程的事情現在可以用更少的代碼以更可靠的方式完成。沒有本書中的知識，使用 Oracle Database 的人將錯失公司已經付費的寶貴功能，而本書則為你打開了這些功能的大門，讓你能夠比以往更快、更輕鬆地提供可靠且高效的解決方案。

第一部分介紹了 SQL 和 PL/SQL 中不常使用和不太熟知的功能。你將學習到新的連接類型、跨行模式匹配、Top N 分頁（在報表中很有用！）、合格表達式以及減少代碼複雜性並使邏輯更易理解的迭代器增強功能。

第二部分介紹了如何在保持性能的同時從 SQL 中調用 PL/SQL。你將學習到用於創建可重用 SQL 片段的 SQL 宏函數、根據傳入參數類型確定返回類型的多態表函數，以及構建和解析 JSON 文檔以實現與其他系統的數據交換。

第三部分介紹了 Oracle 提供的大量內建功能，只等著被使用。基於版本的重定義實現了零停機應用程序和模式升級。數據遮蔽使得更容易遵守隱私法律和類似法規，保護敏感數據免於不需要查看的人的訪問。虛擬私有數據庫提供了每個用戶擁有自己數據庫的外觀，同樣有助於保護敏感數據。這些功能只是本書提供的一小部分。很快你將提升你的技能，並想知道為什麼以前要花那麼多功夫解決問題，而 Oracle Database 已經為你解決了這些問題。

你將學到什麼：
- 通過使用 SQL 和 PL/SQL 中不常使用的功能，編寫更強大的代碼
- 優化 SQL 和 PL/SQL 之間的集成，以獲得最佳性能
- 利用 SQL 中的增強集合運算符、側向連接、基於行的模式匹配和其他高級功能
- 通過使用較新的 PL/SQL 功能（如合格表達式和迭代器增強功能），使代碼更易理解
- 直接從數據庫與 Web 服務和外部數據源進行集成
- 創建和解析 JSON 文檔，實現數據交換和靈活的架構設計

適合閱讀對象：
- 所有撰寫 SQL 或 PL/SQL 的開發人員
- 想要提升自己對 Oracle Database 最新功能的了解和技能的 PL/SQL 專家
- 不想自己開發解決方案，卻後來發現浪費了時間的開發人員，因為 Oracle Database 已經提供了這些功能

​Alex Nuijten is an independent consultant specializing in Oracle database development with PL/SQL and Oracle Application Express (APEX). Besides his consultancy work, he conducts training classes in APEX, SQL, and PL/SQL. He is a speaker at numerous international conferences, such as ODTUG, Oracle Open World, HrOUG, UKOUG, IOUG, OUGF, BGOUG, NLOUG APEX World, OBUG, and many more. He has received several Best Speaker awards and writes at regular intervals about Oracle Application Express and Oracle database development on his blog "Notes on Oracle." He is co-author of Oracle APEX Best Practices and Real World SQL and PL/SQL. Because of his contributions to the Oracle community, Alex was awarded the Oracle ACE Director membership in August 2010.
Patrick Barel is a PL/SQL developer for Qualogy in The Netherlands. Besides working with SQL and PL/SQL Developer, he has written different plug-ins for PL/SQL. He publishes articles on his own blog and on the Qualogy blog. He is a speaker at international conferences, such as ODTUG, UKOUG, AUSOUG, NZOUG, IOUG, OUGN, NLOUG, DOUG, HrOUG, and many more. Patrick was awarded the Oracle ACE membership. In 2015, he received the Oracle Developer Choice Award in the PL/SQL Category. In 2019, he was promoted to Oracle ACE Director.

Alex Nuijten是一位獨立顧問，專注於Oracle數據庫開發，擅長使用PL/SQL和Oracle Application Express（APEX）。除了顧問工作外，他還開設APEX、SQL和PL/SQL的培訓課程。他是許多國際會議的演講嘉賓，包括ODTUG、Oracle Open World、HrOUG、UKOUG、IOUG、OUGF、BGOUG、NLOUG APEX World、OBUG等等。他曾獲得多個最佳演講者獎項，並定期在他的博客“Notes on Oracle”上撰寫有關Oracle Application Express和Oracle數據庫開發的文章。他是《Oracle APEX最佳實踐和現實世界SQL和PL/SQL》的合著者。由於對Oracle社區的貢獻，Alex於2010年8月獲得了Oracle ACE Director會員資格。

Patrick Barel是荷蘭Qualogy的PL/SQL開發人員。除了使用SQL和PL/SQL Developer工作外，他還為PL/SQL編寫了不同的插件。他在自己的博客和Qualogy博客上發表文章。他是國際會議的演講嘉賓，包括ODTUG、UKOUG、AUSOUG、NZOUG、IOUG、OUGN、NLOUG、DOUG、HrOUG等等。Patrick獲得了Oracle ACE會員資格。2015年，他在PL/SQL類別中獲得了Oracle Developer Choice Award。2019年，他晉升為Oracle ACE Director。