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. Youll discover built-in functionality that can save you massive amounts of time that otherwise would be spent reinventing the wheel...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autores principales: Nuijten, Alex (Autor), Barel, Patrick (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: New York : Apress, 2023.
Temas:
Oracle (Computer file)
Database management.
SQL (Computer program language)
PL/SQL (Computer program language)
JSON (Document markup language)
Bases de données > Gestion.
SQL (Langage de programmation)
PL/SQL (Langage de programmation)
JSON (Langage de balisage)
Database management
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 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.

Ejemplares similares