Loading…

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

Full description

Bibliographic Details
Call Number:Libro Electrónico
Main Authors: Allen, Grant (Author), Bryla, Bob (Author), Kuhn, Darl (Author), Allen, Chris (Author)
Corporate Author: SpringerLink (Online service)
Format: Electronic eBook
Language:Inglés
Published: Berkeley, CA : Apress : Imprint: Apress, 2009.
Edition:1st ed. 2009.
Subjects:
Online Access:Texto Completo
Table of Contents:
  • 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.