Note: Supplemental materials are not guaranteed with Rental or Used book purchases.
Purchase Benefits
What is included with this book?
Preface | p. xxv |
Storing Information in Tables | p. 1 |
Introduction | p. 3 |
The Parts of a Table | p. 9 |
Examples of Tables | p. 19 |
Key Points | p. 30 |
Getting Information from a Table | p. 31 |
The Select Statement | p. 33 |
The Select Clause | p. 37 |
The Where Clause | p. 50 |
The Order By Clause | p. 71 |
Key Points | p. 80 |
Compound Conditions in the Where Clause | p. 83 |
Compound Conditions in the Where Clause | p. 85 |
Constant Values | p. 95 |
Punctuation Matters | p. 102 |
Case Sensitivity | p. 113 |
Three-Valued Logic | p. 120 |
Error Messages | p. 122 |
Some Exercises Solved for You | p. 124 |
Key Points | p. 131 |
Saving Your Results | p. 133 |
Saving Your Results in a New Table or View | p. 135 |
Modifying the Data in a Table with SQL | p. 151 |
Modifying the Data in a Table with the GUI | p. 161 |
Restrictions on Modifying the Data in a Table | p. 167 |
Key Points | p. 170 |
The Data Dictionary and Other Oracle Topics | p. 171 |
Commit, Rollback, and Transactions | p. 173 |
Modifying Data through a View | p. 179 |
The SQL Commands Page in Oracle | p. 192 |
Using the Oracle Data Dictionary | |
p. 195 | |
Key Points | p. 207 |
Creating Your Own Tables | p. 209 |
Creating Tables | p. 211 |
Changing Tables | p. 226 |
Tables with Duplicate Rows | p. 236 |
Key Points | p. 243 |
Formats, Sequences, and Indexes | p. 245 |
Formats | p. 247 |
Sequences | p. 257 |
Indexes | p. 262 |
Using the Oracle Data Dictionary | |
p. 266 | |
An Exercise Solved for You | p. 278 |
Key Points | p. 280 |
Data Integrity | p. 281 |
Constraints on One Table | p. 283 |
Referential Integrity | p. 289 |
The Delete Options and Update Options of RI | p. 303 |
Variations of Referential Integrity | p. 311 |
How to Code Constraints in a Create Table Statement | p. 316 |
Key Points | p. 319 |
Row Functions | p. 321 |
Introduction to Row Functions | p. 323 |
Numeric Functions | p. 334 |
Text Functions | p. 340 |
Date Functions | p. 350 |
Key Points | p. 359 |
Using Row Functions | p. 361 |
Specialized Row Functions | p. 363 |
Using the Documentation of Row Functions | p. 372 |
Creating Patterns of Numbers and Dates | p. 376 |
Key Points | p. 397 |
Summarizing Data | p. 399 |
Introduction to the Column Functions | p. 401 |
Maximum and Minimum | p. 404 |
Count | p. 411 |
Sum and Average | p. 420 |
Other Topics | p. 428 |
Key Points | p. 434 |
Controlling the Level of Summarization | p. 435 |
Dividing a Table into Groups of Rows | p. 437 |
Eliminating Some of the Summarized Data | p. 459 |
Key Points | p. 471 |
Inner Joins | p. 473 |
Introduction to Joins | p. 475 |
Inner Joins of Two Tables | p. 479 |
Variations of the Join Condition | p. 495 |
Applications of Joins | p. 504 |
Key Points | p. 515 |
Outer Joins | p. 517 |
Introduction to Outer Joins | p. 519 |
Applications of Outer Joins | p. 534 |
Key Points | p. 553 |
Union and Union All | p. 555 |
Union Basics | p. 557 |
Unconventional Unions | p. 573 |
Applications of a Union | p. 577 |
Set Intersection and Set Difference in Oracle | p. 590 |
Key Points | p. 595 |
Cross Joins, Self Joins, and Cross Tab Queries | p. 597 |
Cross Joins | p. 599 |
Self Joins | p. 613 |
Cross Tab Queries in Access | p. 624 |
Cross Tab Queries in Oracle | p. 645 |
Key Points | p. 650 |
Combining Tables in a Production Database | p. 653 |
Methods of Joining Three or More Tables | p. 655 |
Losing Information | p. 660 |
Caring about the Efficiency of Your Computer | p. 663 |
Standardizing the Way That Tables Are Joined | p. 666 |
Key Points | p. 671 |
If-Then-Else, Parameter Queries, and Subqueries | p. 673 |
If-Then-Else Logic | p. 675 |
Table of Contents provided by Publisher. All Rights Reserved. |