- A Note Regarding Supplemental Files
- Preface
- 1. Introduction to SQL
- 2. The WHERE Clause
- 3. Joins
- 4. Group Operations
- 4.1. Aggregate Functions
- 4.2. The GROUP BY Clause
- 4.2.1. Correspondence Between SELECT and GROUP BY
- 4.2.1.1. Aggregate expressions generally require a GROUP BY clause
- 4.2.1.2. GROUP BY clause must include all nonaggregate expressions
- 4.2.1.3. Aggregate functions not allowed in GROUP BY clause
- 4.2.1.4. Constants can be omitted from the GROUP BY clause
- 4.2.1.5. Scalar functions may be grouped by their underlying column
- 4.2.1.6. Concatenated columns may be grouped in either of two ways
- 4.2.1.7. You can sometimes exclude a nonaggregate expression from the GROUP BY clause
- 4.2.1.8. You are not required to show your GROUP BY columns
- 4.2.2. GROUP BY Clause and NULL Values
- 4.2.3. GROUP BY Clause with WHERE Clause
- 4.2.1. Correspondence Between SELECT and GROUP BY
- 4.3. The HAVING Clause
- 4.4. Nested Group Operations
- 5. Subqueries
- 6. Handling Temporal Data
- 6.1. Time Zones
- 6.2. Temporal Data Types in Oracle
- 6.3. Literals of Temporal Types
- 6.4. Getting Temporal Data In and Out of a Database
- 6.5. Date and Time Formats
- 6.6. Manipulating Temporal Data
- 6.6.1. Using the Built-in Temporal Functions
- 6.6.2. Addition
- 6.6.3. Subtraction
- 6.6.3.1. Subtracting one DATE from another
- 6.6.3.2. Subtracting one TIMESTAMP from another
- 6.6.3.3. Subtracting a number from a DATE
- 6.6.3.4. Subtracting months from a DATE
- 6.6.3.5. Number of months between two DATEs
- 6.6.3.6. Time interval between two DATEs
- 6.6.3.7. Subtracting an INTERVAL from a DATE or TIMESTAMP
- 6.6.4. Determining the First Day of the Month
- 6.6.5. Rounding and Truncating Dates
- 6.6.6. SELECTing Data Based on Date Ranges
- 6.6.7. Creating a Date Pivot Table
- 6.6.8. Summarizing by a Date/Time Element
- 7. Set Operations
- 8. Hierarchical Queries
- 8.1. Representing Hierarchical Information
- 8.2. Simple Hierarchy Operations
- 8.3. Oracle SQL Extensions
- 8.4. Complex Hierarchy Operations
- 8.4.1. Finding the Number of Levels
- 8.4.2. Listing Records in Hierarchical Order
- 8.4.3. Checking for Ascendancy
- 8.4.4. Deleting a Subtree
- 8.4.5. Listing Multiple Root Nodes
- 8.4.6. Listing the Top Few Levels of a Hierarchy
- 8.4.7. Aggregating a Hierarchy
- 8.4.8. Ordering Hierarchical Data
- 8.4.9. Finding the Path to a Node
- 8.5. Restrictions on Hierarchical Queries
- 8.6. Enhancements in Oracle Database 10g
- 9. DECODE and CASE
- 10. Partitioning
- 11. PL/SQL
- 12. Objects and Collections
- 13. Advanced Group Operations
- 14. Advanced Analytic SQL
- 15. SQL Best Practices
- 16. XML
- 17. Regular Expressions
- 18. Model Queries
- A. Oracle’s Old Join Syntax
- About the Authors
- Colophon
- Copyright
About the Authors
Sanjay Mishra is a certified Oracle database administrator with more than ten years of IT experience. He has been involved in the design, architecture, and implementation of many mission-critical and decision support databases. He has worked extensively in the areas of database architecture, database management, backup / recovery, performance tuning, Oracle Parallel Server, and parallel execution. He has a Bachelor of Science degree in Electrical Engineering, and a Master of Engineering degree in Systems Science and Automation. He is the coauthor of Oracle Parallel Processing and Oracle SQL Loader: The Definitive Guide (both published by O'Reilly & Associates). Presently, he works as a database architect at Dallas Based i2 Technologies, and can be reached at [email protected].
Alan Beaulieu has been designing, building, and implementing custom database applications for over 13 years. He currently runs his own consulting company that specializes in designing Oracle databases and supporting services in the fields of Financial Services and Telecommunications. In building large databases for both OLTP and OLAP environments, Alan utilizes such Oracle features as Parallel Query, Partitioning, and Parallel Server. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters and can be reached at [email protected].
-
No Comment