| |
| |
| Acknowledgments | |
| |
| |
| Introduction | |
| |
| |
| |
| Database Basics | |
| |
| |
| |
| Introduction to Databases | |
| |
| |
| What Exactly Is a Database? | |
| |
| |
| How Is a Database Different from a Spreadsheet? | |
| |
| |
| How Will Knowing This Help You? | |
| |
| |
| History of SQL | |
| |
| |
| SQL Command Categories | |
| |
| |
| Chapter Summary | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| |
| Storing and Retrieving Data: The Basics | |
| |
| |
| Putting Your Toe in the Water | |
| |
| |
| Creating Tables | |
| |
| |
| Inserting Data--Additional Techniques | |
| |
| |
| Viewing Data--Additional Techniques | |
| |
| |
| Chapter Summary | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| |
| Advanced Data Manipulation | |
| |
| |
| Limit Which Records You Select | |
| |
| |
| Change the Order of Records | |
| |
| |
| Show Only Unique Values | |
| |
| |
| Select from DUAL | |
| |
| |
| Modify Data In a Table | |
| |
| |
| Remove Records from a Table | |
| |
| |
| Transaction Control | |
| |
| |
| Chapter Summary | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| |
| Controlling SQL*Plus | |
| |
| |
| Edit Prior Commands | |
| |
| |
| Copy and Paste | |
| |
| |
| Clear the SQL*Plus Screen | |
| |
| |
| Customize the SQL*Plus Environment | |
| |
| |
| Produce More Readable Output | |
| |
| |
| Spool Output to Disk | |
| |
| |
| SQL Script Files | |
| |
| |
| Chapter Summary | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| |
| Advanced SQL | |
| |
| |
| |
| SQL Functions | |
| |
| |
| Commonly Used Single-Row Functions | |
| |
| |
| Commonly Used Group Functions | |
| |
| |
| Chapter Summary | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| |
| Using Indexes and Constraints | |
| |
| |
| Indexes | |
| |
| |
| Ensure Data Integrity: Constraints | |
| |
| |
| Relationships Between Tables | |
| |
| |
| Write Subqueries | |
| |
| |
| Chapter Summary | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| |
| Other Useful Oracle Techniques | |
| |
| |
| Transfer Data Between Tables | |
| |
| |
| Rename Tables | |
| |
| |
| Alter a Table's Structure | |
| |
| |
| Views | |
| |
| |
| Other Database Objects | |
| |
| |
| Chapter Summary | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| |
| Create Programs Using PL/SQL | |
| |
| |
| |
| Introduction to PL/SQL | |
| |
| |
| What Is PL/SQL? | |
| |
| |
| Structure of a PL/SQL Block | |
| |
| |
| Create a Simple PL/SQL Procedure | |
| |
| |
| PL/SQL Variables and Constants | |
| |
| |
| Control Structures in PL/SQL | |
| |
| |
| Error Handling | |
| |
| |
| Chapter Summary | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| |
| More PL/SQL Tools | |
| |
| |
| Coding Conventions | |
| |
| |
| More on PL/SQL and Oracle Server Interaction | |
| |
| |
| Timing Operations | |
| |
| |
| PL/SQL Packages | |
| |
| |
| Triggers | |
| |
| |
| XML | |
| |
| |
| Chapter Summary | |
| |
| |
| Chapter Questions | |
| |
| |
| Answers to Chapter Questions | |
| |
| |
| Glossary of Common Oracle Terms | |
| |
| |
| Index | |