Cover Image
Read Now

Modern Oracle Database Programming Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON

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...

Full description

Bibliographic Details
Main Authors: Nuijten, Alex, Barel, Patrick (Author)
Format: eBook
Language:English
Published: Berkeley, CA Apress 2023, 2023
Edition:1st ed. 2023
Subjects:
Database Management System
Programming Languages (electronic Computers)
Database Management
Programming Language
Online Access:
Collection: Springer eBooks 2005- - Collection details see MPG.ReNa
Table of Contents:
  • Part I. The Advanced Basics
  • 1. Underutilized Functionality and Enhancements
  • 2. Analytic Functions, Model, and Pivoting
  • 3. Joins
  • 4. Finding Patterns
  • 5. Pagination and Set Operators
  • 6. Conditional Compilation
  • 7. Iterations and Qualified Expressions
  • Part II. Multiple Techniques and Languages
  • 8. SQL Macro and Polymorphic Table Functions and SQL Macros
  • 9. Subquery Factoring, the WITH Clause Explained
  • 10. Calling PL/SQL from SQL
  • 11. Storing JSON in the Database
  • 12. Creating and Parsing JSON in SQL
  • 13. Creating and Parsing JSON in PL/SQL
  • Part III. Oracle-Provided Functionality
  • 14.Comparing and Manipulating JSON
  • 15. Useful APEX Packages
  • 16. Processing Data in the Background
  • 17. Introspecting PL/SQL
  • 18. See What You Need to See
  • 19. Upgrade your Application with Zero Downtime
  • 20. Choosing the Right Table

Similar Items