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

Descripción completa

Detalles Bibliográficos
Autor principal: Allen, Grant (-)
Otros Autores: Bryla, Bob, Kuhn, Darl
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.