Oracle SQL Recipes A Problem-Solution Approach /

• Κύριοι συγγραφείς: Allen, Grant (Συγγραφέας), Bryla, Bob (Συγγραφέας), Kuhn, Darl (Συγγραφέας)
• Συγγραφή απο Οργανισμό/Αρχή: SpringerLink (Online service)
• Μορφή: Ηλεκτρονική πηγή Ηλ. βιβλίο
• Γλώσσα: English
• Έκδοση: Berkeley, CA : Apress, 2009.
• Θέματα: Computer science.; Database management.; Computer Science.; Computer Science, general.; Database Management.

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

Πίνακας περιεχομένων:

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