Share
Create bookmark
Mastering Oracle SQL
Notes
Please login to add notes
- Table of Contents
- + Preface
-
+
Introduction to SQL
-
+
The WHERE Clause
- + Joins
-
+
Group Operations
- + Aggregate Functions
-
+
The GROUP BY Clause
-
+
Correspondence Between SELECT and GROUP BY
- Aggregate expressions generally require a GROUP BY clause
- GROUP BY clause must include all nonaggregate expressions
- Aggregate functions not allowed in GROUP BY clause
- Constants can be omitted from the GROUP BY clause
- Scalar functions may be grouped by their underlying column
- Concatenated columns may be grouped in either of two ways
- You can sometimes exclude a nonaggregate expression from the GROUP BY clause
- You are not required to show your GROUP BY columns
- GROUP BY Clause and NULL Values
- GROUP BY Clause with WHERE Clause
-
+
Correspondence Between SELECT and GROUP BY
- The HAVING Clause
- Nested Group Operations
-
+
Subqueries
-
+
Handling Temporal Data
- + Time Zones
- + Temporal Data Types in Oracle
- + Literals of Temporal Types
- + Getting Temporal Data In and Out of a Database
- + Date and Time Formats
-
+
Manipulating Temporal Data
- + Set Operations
-
+
Hierarchical Queries
-
+
DECODE and CASE
-
+
Partitioning
-
+
PL/SQL
-
+
Objects and Collections
-
+
Advanced Group Operations
-
+
Advanced Analytic SQL
-
+
SQL Best Practices
-
+
XML
-
+
Regular Expressions
-
+
Model Queries
- + Oracle’s Old Join Syntax
- Index
The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQL on a regular basis, you want much more. You want to access the full power of SQL to write queries in an Oracle environment. You want a solid understanding of what's possible with Oracle SQL, creative techniques for writing effective and accurate queries, and the practical, hands-on information that leads to true mastery of the language. Simply put, you want useful, expert best practices that can be put to work immediately, not just non-vendor specific overview or theory.
Updated to cover the latest version of Oracle, Oracle 10g, this edition of the highly regarded Mastering Oracle SQL has a stronger focus on technique and on Oracle's implementation of SQL than any other book on the market. It covers Oracle s vast library of built-in functions, the full range of Oracle SQL query-writing features, regular expression support, new aggregate and analytic functions, subqueries in the SELECT and WITH clauses, multiset union operators, enhanced support for hierarchical queries: leaf and loop detection, and the CONNECT_BY_ROOT operator, new partitioning methods (some introduced in Oracle9i Release 2), and the native XML datatype, XMLType.
Mastering Oracle SQL, 2nd Edition fills the gap between the sometimes spotty vendor documentation, and other books on SQL that just don't explore the full depth of what is possible with Oracle-specific SQL. For those who want to harness the untapped (and often overlooked) power of Oracle SQL, this essential guide for putting Oracle SQL to work will prove invaluable.
Test the closed alpha on paperc.com
Book Details
Authors
Sanjay Mishra and Alan Beaulieu
Categories
Computers > Operating Systems > Windows Workstation
Publishers
Publication year : 2007
License: All rights reserved ©
Times read: 576
