| |
| |
| Preface | |
| |
| |
| |
| Storing Information in Tables | |
| |
| |
| Introduction | |
| |
| |
| The Parts of a Table | |
| |
| |
| Examples of Tables | |
| |
| |
| Key Points | |
| |
| |
| |
| Getting Information from a Table | |
| |
| |
| The Select Statement | |
| |
| |
| The Select Clause | |
| |
| |
| The Where Clause | |
| |
| |
| The Order By Clause | |
| |
| |
| Key Points | |
| |
| |
| |
| Compound Conditions in the Where Clause | |
| |
| |
| Compound Conditions in the Where Clause | |
| |
| |
| Constant Values | |
| |
| |
| Punctuation Matters | |
| |
| |
| Case Sensitivity | |
| |
| |
| Three-Valued Logic | |
| |
| |
| Error Messages | |
| |
| |
| Some Exercises Solved for You | |
| |
| |
| Key Points | |
| |
| |
| |
| Saving Your Results | |
| |
| |
| Saving Your Results in a New Table or View | |
| |
| |
| Modifying the Data in a Table with SQL | |
| |
| |
| Modifying the Data in a Table with the GUI | |
| |
| |
| Restrictions on Modifying the Data in a Table | |
| |
| |
| Key Points | |
| |
| |
| |
| The Data Dictionary and Other Oracle Topics | |
| |
| |
| Commit, Rollback, and Transactions | |
| |
| |
| Modifying Data through a View | |
| |
| |
| The SQL Commands Page in Oracle | |
| |
| |
| Using the Oracle Data Dictionary | |
| |
| |
| |
| |
| |
| Key Points | |
| |
| |
| |
| Creating Your Own Tables | |
| |
| |
| Creating Tables | |
| |
| |
| Changing Tables | |
| |
| |
| Tables with Duplicate Rows | |
| |
| |
| Key Points | |
| |
| |
| |
| Formats, Sequences, and Indexes | |
| |
| |
| Formats | |
| |
| |
| Sequences | |
| |
| |
| Indexes | |
| |
| |
| Using the Oracle Data Dictionary | |
| |
| |
| |
| |
| |
| An Exercise Solved for You | |
| |
| |
| Key Points | |
| |
| |
| |
| Data Integrity | |
| |
| |
| Constraints on One Table | |
| |
| |
| Referential Integrity | |
| |
| |
| The Delete Options and Update Options of RI | |
| |
| |
| Variations of Referential Integrity | |
| |
| |
| How to Code Constraints in a Create Table Statement | |
| |
| |
| Key Points | |
| |
| |
| |
| Row Functions | |
| |
| |
| Introduction to Row Functions | |
| |
| |
| Numeric Functions | |
| |
| |
| Text Functions | |
| |
| |
| Date Functions | |
| |
| |
| Key Points | |
| |
| |
| |
| Using Row Functions | |
| |
| |
| Specialized Row Functions | |
| |
| |
| Using the Documentation of Row Functions | |
| |
| |
| Creating Patterns of Numbers and Dates | |
| |
| |
| Key Points | |
| |
| |
| |
| Summarizing Data | |
| |
| |
| Introduction to the Column Functions | |
| |
| |
| Maximum and Minimum | |
| |
| |
| Count | |
| |
| |
| Sum and Average | |
| |
| |
| Other Topics | |
| |
| |
| Key Points | |
| |
| |
| |
| Controlling the Level of Summarization | |
| |
| |
| Dividing a Table into Groups of Rows | |
| |
| |
| Eliminating Some of the Summarized Data | |
| |
| |
| Key Points | |
| |
| |
| |
| Inner Joins | |
| |
| |
| Introduction to Joins | |
| |
| |
| Inner Joins of Two Tables | |
| |
| |
| Variations of the Join Condition | |
| |
| |
| Applications of Joins | |
| |
| |
| Key Points | |
| |
| |
| |
| Outer Joins | |
| |
| |
| Introduction to Outer Joins | |
| |
| |
| Applications of Outer Joins | |
| |
| |
| Key Points | |
| |
| |
| |
| Union and Union All | |
| |
| |
| Union Basics | |
| |
| |
| Unconventional Unions | |
| |
| |
| Applications of a Union | |
| |
| |
| Set Intersection and Set Difference in Oracle | |
| |
| |
| Key Points | |
| |
| |
| |
| Cross Joins, Self Joins, and Cross Tab Queries | |
| |
| |
| Cross Joins | |
| |
| |
| Self Joins | |
| |
| |
| Cross Tab Queries in Access | |
| |
| |
| Cross Tab Queries in Oracle | |
| |
| |
| Key Points | |
| |
| |
| |
| 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 | |
| |
| |
| Key Points | |
| |
| |
| |
| If-Then-Else, Parameter Queries, and Subqueries | |
| |
| |
| If-Then-Else Logic | |