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