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...
| Main Authors: | , , , |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
Berkeley, CA
Apress
2009, 2009
|
| Edition: | 1st ed. 2009 |
| Subjects: | |
| Online Access: | |
| Collection: | Springer eBooks 2005- - Collection details see MPG.ReNa |
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