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 whee...
| Otros Autores: | , , |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
New York, NY :
Apress Media LLC
[2023]
|
| Edición: | 1st ed. 2023. |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009724217306719 |
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.
