Oracle SQL recipes a problem-solution approach
Have you ever been faced with a new type of query to write, or been asked to create an unfamiliar database object? In such situations, you have probably wanted a good, solid example upon which to build, and instead have been forced into the drudgery of parsing railroad-style syntax diagrams in Oracl...
Autor principal: | |
---|---|
Otros Autores: | , |
Formato: | Libro electrónico |
Idioma: | Inglés |
Publicado: |
Berkeley, Calif. :
Apress
c2009.
|
Edición: | 1st ed. 2009. |
Colección: | Expert's voice in Oracle.
|
Materias: | |
Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628348506719 |
Tabla de Contenidos:
- Foundations of Data Manipulation
- The Basics
- Summarizing and Aggregating Data
- Querying from Multiple Tables
- Creating and Deriving Data
- Common Query Patterns
- Data Types and Their Problems
- Working with Date and Time Values
- Strings
- Working with Numbers
- Your Development Environment
- Managing Transactions
- Data Dictionary
- Special Topics
- Common Reporting Problems
- Cleansing Data
- Tree-Structured Data
- Working with XML Data
- Partitioning
- LOBs
- Administration
- Database Administration
- Object Management
- SQL Monitoring and Tuning
- Database Troubleshooting.