| |
| |
Preface | |
| |
| |
Acknowledgments | |
| |
| |
| |
Storing Information in Tables | |
| |
| |
Introduction | |
| |
| |
The Parts of a Table | |
| |
| |
Examples of Tables | |
| |
| |
Summary | |
| |
| |
| |
Getting Information from a Table | |
| |
| |
The Select Statement | |
| |
| |
The Select Clause | |
| |
| |
The Where Clause | |
| |
| |
The Order By Clause | |
| |
| |
Summary | |
| |
| |
Exercises | |
| |
| |
| |
Compound Conditions in the Where Clause | |
| |
| |
Compound Conditions in the Where Clause | |
| |
| |
Constant Values | |
| |
| |
Punctuation Matters | |
| |
| |
Some Exercises Solved for You | |
| |
| |
Summary | |
| |
| |
Exercises | |
| |
| |
| |
Saving Your Results | |
| |
| |
Saving Your Results in a New Table or View | |
| |
| |
Modifying the Data in a Table | |
| |
| |
Summary | |
| |
| |
Exercises | |
| |
| |
| |
Modifying Data Through a View | |
| |
| |
Transactions | |
| |
| |
Modifying Data Through a View | |
| |
| |
Oracle SQLplus | |
| |
| |
Finding Information About Tables and Views | |
| |
| |
Summary | |
| |
| |
Exercises | |
| |
| |
| |
Creating Your Own Tables | |
| |
| |
Creating Tables | |
| |
| |
Changing Tables | |
| |
| |
Tables with Duplicate Rows | |
| |
| |
Loading a Large Amount of Data from a Flat File | |
| |
| |
Summary | |
| |
| |
Exercises | |
| |
| |
| |
Formats, Sequences, and Indexes | |
| |
| |
Formats | |
| |
| |
Sequences | |
| |
| |
Indexes | |
| |
| |
Finding More Information in the Data Dictionary | |
| |
| |
An Exercise Solved for You | |
| |
| |
Summary | |
| |
| |
Exercises | |
| |
| |
| |
Data Integrity | |
| |
| |
Referential Integrity | |
| |
| |
The Delete Options and Update Options of RI | |
| |
| |
Variations of Referential Integrity | |
| |
| |
Other Types of Constraints | |
| |
| |
Summary | |
| |
| |
Exercises | |
| |
| |
| |
Row Functions | |
| |
| |
Introduction to Row Functions | |
| |
| |
Number Functions | |
| |
| |
Text Functions | |
| |
| |
Date Functions | |
| |
| |
Summary | |
| |
| |
Exercises | |
| |
| |
| |
Using Row Functions | |
| |
| |
Other Functions | |
| |
| |
Using the Documentation of Row Functions | |
| |
| |
Creating Patterns of Numbers and Dates | |
| |
| |
Summary | |
| |
| |
Exercises | |
| |
| |
| |
Summarizing Data | |
| |
| |
Introduction to the Column Functions | |
| |
| |
Maximum and Minimum | |
| |
| |
Count | |
| |
| |
Sum and Average | |
| |
| |
Other Topics | |
| |
| |
Summary | |
| |
| |
Exercises | |
| |
| |
| |
Controlling the Level of Summarization | |
| |
| |
Dividing a Table into Groups of Rows and Summarizing Each Group | |
| |
| |
Eliminating Some of the Summarized Data | |
| |
| |
Restrictions on Summarization | |
| |
| |
Summary | |
| |
| |
Exercises | |
| |
| |
| |
Inner Joins | |
| |
| |
Introduction to Joins | |
| |
| |
Inner Joins of Two Tables | |
| |
| |
Variations of the Join Condition | |
| |
| |
Applications of Joins | |
| |
| |
Summary | |
| |
| |
Exercises | |
| |
| |
| |
Outer Joins | |
| |
| |
Introduction to Outer Joins | |
| |
| |
Applications of Outer Joins | |
| |
| |
Summary | |
| |
| |
Exercises | |
| |
| |
| |
Union and Union All | |
| |
| |
Unions | |
| |
| |
Unconventional Unions | |
| |
| |
Applications of a Union | |
| |
| |
Set Intersection and Set Difference in Oracle | |
| |
| |
Summary | |
| |
| |
Exercises | |
| |
| |
| |
Cross Joins and Self Joins | |
| |
| |
Cross Joins | |
| |
| |
Self Joins | |
| |
| |
Summary | |
| |
| |
Exercises | |
| |
| |
| |
Combining Tables in a Production Database | |
| |
| |
Methods of Joining Three or More Tables | |
| |
| |
Losing Information | |
| |
| |
Caring About the Efficiency of Your Computer | |
| |
| |
Standardizing the Way That Tables Are Joined | |
| |
| |
Summary | |
| |
| |
| |
If-Then-Else and Subqueries | |
| |
| |
If-Then-Else Logic | |
| |
| |
Parameter Queries | |
| |
| |
Subqueries | |
| |
| |
Applications of Subqueries | |
| |
| |
Older Features of Subqueries | |
| |
| |
Summary | |
| |
| |
| |
The Multiuser Environment | |
| |
| |
Database Configurations | |
| |
| |
Operating in a Multiuser Environment | |
| |
| |
Security and Privileges | |
| |
| |
Several People Using the Same Table at the Same Time | |
| |
| |
Locks | |
| |
| |
The Data Dictionary and the Multiuser Environment | |
| |
| |
How to Create a Shared Application | |
| |
| |
Summary | |
| |
| |
| |
The Design of SQL | |
| |
| |
Original SQL Design Objectives | |
| |
| |
Newer Interfaces | |
| |
| |
Typical Applications | |
| |
| |
Summary | |
| |
| |
| |
Obtaining and Installing Oracle | |
| |
| |
Getting Current Information | |
| |
| |
Which Product Should You Get? | |
| |
| |
Downloading Oracle from the Internet | |
| |
| |
Ordering Oracle on a CD | |
| |
| |
Installing Oracle | |
| |
| |
Setting Up to Run the Examples in This Book | |
| |
| |
Setting Up a New Userid | |
| |
| |
Installing the Tables Used in This Book | |
| |
| |
How to Build the Tables and Assign Other Tablespace Names | |
| |
| |
| |
Tips on Using Oracle | |
| |
| |
Starting Oracle | |
| |
| |
Entering a Query | |
| |
| |
Other Ways to Edit Your SQL Code | |
| |
| |
Error Messages Are Sometimes Correct | |
| |
| |
Using the Scrollbars | |
| |
| |
If Oracle Does Not Respond | |
| |
| |
Installing the LOGIN Script | |
| |
| |
Running All the SQL for a Chapter | |
| |
| |
| |
Tips on Using Access | |
| |
| |
You Can Use Access 2000 or 2002 | |
| |
| |
Starting Access | |
| |
| |
Entering an SQL Query | |
| |
| |
Dealing with Errors | |
| |
| |
Printing | |
| |
| |
| |
Diagram of the Lunches Database | |
| |
| |
Join Conditions | |
| |
| |
Data Validation Rules | |
| |
| |
Index | |