iii
Contents
Volume 1
Preface xi....................................................................
Profile xii.................................................................
Related Publications xviii....................................................
Typographic Conventions xix................................................
I Introduction IĆ1...........................................................
Course Objectives IĆ3......................................................
Course Outline IĆ5.........................................................
The Relational Database Concept IĆ9........................................
System Development Cycle IĆ17..............................................
What Is Oracle? IĆ19........................................................
The Oracle Product Set IĆ21..................................................
SQL, SQL*Plus, and PL/SQL IĆ23.............................................
Summit Sporting Goods Demonstration Tables IĆ29.............................
Summary IĆ33..............................................................
1. Selecting Rows 1Ć1........................................................
Objectives 1Ć3.............................................................
The Basic Query Block 1Ć5..................................................
Arithmetic Expressions 1Ć13..................................................
Column Aliases 1Ć21........................................................
The Concatenation Operator 1Ć23.............................................
Literal Character String 1Ć25..................................................
Managing Null Values 1Ć27...................................................
Preventing the Selection of Duplicate Rows 1Ć31................................
SQL*Plus Commands 1Ć35...................................................
Logging in to SQL*Plus 1Ć37.................................................
Displaying Table Structure 1Ć39...............................................
SQL*Plus Editing Commands 1Ć41............................................
SQL*Plus File Commands and Online Help 1Ć43................................

Nesting Single Row Functions 3Ć51............................................
Nesting Functions 3Ć53......................................................
Summary 3Ć55..............................................................
Practice Overview 3Ć57......................................................
Practice 3 3Ć59..............................................................
4. Displaying Data from Multiple Tables 4Ć1....................................
Objectives 4Ć3.............................................................
Overview 4Ć5..............................................................
What Is a Cartesian Product? 4Ć7............................................
Simple Join Query 4Ć9......................................................
Using Table Aliases 4Ć17.....................................................
NonĆEquijoin 4Ć19...........................................................
Returning Records with No Direct Match 4Ć21...................................
Joining a Table to Itself 4Ć25..................................................
Summary 4Ć27..............................................................
Practice Overview 4Ć29......................................................
Practice 4 4Ć31..............................................................
5. Group Functions 5Ć1.......................................................
Objectives 5Ć3.............................................................
Overview 5Ć5..............................................................
Group Functions 5Ć7.......................................................
v
The GROUP BY Clause 5Ć13..................................................
Illegal Queries Using Group Functions 5Ć19....................................
Groups Within Groups 5Ć23..................................................
The HAVING Clause 5Ć25....................................................
Summary 5Ć31..............................................................
Practice Overview 5Ć33......................................................
Practice 5 5Ć34..............................................................
6. Subqueries 6Ć1............................................................

Integrity Constraints and Keys 8Ć23............................................
Designing the Database 8Ć29.................................................
Summary 8Ć39..............................................................
vi
9. Creating Tables 9Ć1........................................................
Objectives 9Ć3.............................................................
Overview 9Ć5..............................................................
Creating Tables 9Ć7.........................................................
Oracle7 Datatypes 9Ć13......................................................
Constraints 9Ć15............................................................
Creating a Table from a Table Instance Chart 9Ć25...............................
Creating a Table from Rows in Another Table 9Ć31...............................
Confirming Table Creation 9Ć33...............................................
Summary 9Ć35..............................................................
Practice Overview 9Ć37......................................................
Practice 9 9Ć39..............................................................
10. Oracle Data Dictionary 10Ć1.................................................
Objectives 10Ć3.............................................................
Overview 10Ć5..............................................................
Querying the Data Dictionary 10Ć7.............................................
Checking Constraints on a Table 10Ć13.........................................
Summary 10Ć17..............................................................
Practice Overview 10Ć19......................................................
Practice 10 10Ć21............................................................
11. Manipulating Data 11Ć1.....................................................
Objectives 11Ć3.............................................................
Overview 11Ć5..............................................................
Adding a New Row to a Table 11Ć7............................................
Copying Rows from Another Table 11Ć19........................................
Updating Rows 11Ć21.........................................................

Summary 13Ć21..............................................................
Practice Overview 13Ć23......................................................
Practice 13 13Ć25............................................................
14. Creating Views 14Ć1........................................................
Objectives 14Ć3.............................................................
Overview 14Ć5..............................................................
Creating a View 14Ć7........................................................
Performing DML Operations on a View 14Ć15....................................
Confirming View Names and Structures 14Ć21...................................
Removing a View 14Ć23.......................................................
Summary 14Ć25..............................................................
Practice Overview 14Ć27......................................................
Practice 14 14Ć29............................................................
15. Creating Indexes 15Ć1......................................................
Objectives 15Ć3.............................................................
Overview 15Ć5..............................................................
When Is the Index Used? 15Ć7................................................
Index Structure 15Ć9.........................................................
Creating an Index 15Ć13.......................................................
Confirming Indexes 15Ć17.....................................................
Removing an Index 15Ć19.....................................................
Summary 15Ć21..............................................................
Practice Overview 15Ć23......................................................
Practice 15 15Ć25............................................................
16. Controlling User Access 16Ć1...............................................
Objectives 16Ć3.............................................................
Overview 16Ć5..............................................................