| |
| |
(Note:Each chapter concludes with Test Your Thinking.) Foreword | |
| |
| |
Acknowledgments | |
| |
| |
About the Author | |
| |
| |
Introduction | |
| |
| |
| |
Sql and Data | |
| |
| |
Data, Databases, and the Definition of sql | |
| |
| |
Table Relationships | |
| |
| |
The Student Schema Diagram | |
| |
| |
| |
Sql: The Basics | |
| |
| |
The Sql*Plus Environment | |
| |
| |
The Anatomy of a Select Statement | |
| |
| |
Editing a Sql Statement | |
| |
| |
The Where Clause: Comparison and Logical Operators | |
| |
| |
The Order By Clause | |
| |
| |
| |
Character, Number, and Miscellaneous Functions | |
| |
| |
Character Functions | |
| |
| |
Number Functions | |
| |
| |
Miscellaneous Single-Row Functions | |
| |
| |
| |
Date and Conversion Functions | |
| |
| |
Applying Oracle's Date Format Models | |
| |
| |
Performing Date and Time Math | |
| |
| |
Understanding Timestamp and Time Zone Datatypes | |
| |
| |
Performing Calculations with the Interval Datatypes | |
| |
| |
Converting from One Datatype to Another | |
| |
| |
| |
Aggregate Functions, Group By, and Having | |
| |
| |
Aggregate Functions | |
| |
| |
The Group by and Having Clauses | |
| |
| |
| |
Equijoins | |
| |
| |
The Two-Table Join | |
| |
| |
Joining Three or More Tables | |
| |
| |
| |
Subqueries | |
| |
| |
Simple Subqueries | |
| |
| |
Correlated Subqueries | |
| |
| |
Inline Views and Scalar Subquery Expressions | |
| |
| |
Any, Some, and All Operators in Subqueries | |
| |
| |
| |
Set Operators | |
| |
| |
The Power of Union and Union All | |
| |
| |
The Minus and Intersect Set Operators | |
| |
| |
| |
Complex Joins | |
| |
| |
Outer Joins | |
| |
| |
Self-Joins | |
| |
| |
| |
Insert, Update, and Delete | |
| |
| |
Creating Data and Transaction Control | |
| |
| |
Updating and Deleting Data | |
| |
| |
| |
Create, Alter, and Drop Tables | |
| |
| |
Creating and Dropping Tables | |
| |
| |
Altering Tables and Manipulating Constraints | |
| |
| |
| |
Views, Indexes, and Sequences | |
| |
| |
Creating and Modifying Views | |
| |
| |
Indexes | |
| |
| |
Sequences | |
| |
| |
| |
The Data Dictionary and Advanced Sql*Plus Commands | |
| |
| |
The Oracle Data Dictionary Views | |
| |
| |
Advanced Sql*Plus Commands | |
| |
| |
| |
Security | |
| |
| |
Users, Privileges, Roles, and Synonyms | |
| |
| |
| |
Regular Expressions and Hierarchical Queries | |
| |
| |
Regular Expressions | |
| |
| |
Hierarchical Queries | |
| |
| |
| |
Exploring Data Warehousing Features | |
| |
| |
Advanced Sql Concepts, Analytical Functions, and the with Clause | |
| |
| |
Rollup and Cube Operators | |
| |
| |
| |
Sql Optimization | |
| |
| |
The Oracle Optimizer and Writing Effective Sql Statements | |
| |
| |
| |
Answers to Self-Review Questions | |
| |
| |
| |
SQL Formatting Guide | |
| |
| |
| |
SQL*Plus Command Reference | |
| |
| |
| |
Student Database Schema | |
| |
| |
| |
Table and Column Descriptions | |
| |
| |
| |
Additional Example Tables | |
| |
| |
| |
Navigating through the Oracle Documentation | |
| |
| |
| |
Resources | |
| |
| |
| |
Oracle Datatypes | |
| |
| |
Index | |