Special Formats with the Date Data Type

55

Nested Functions

56

Critical Skill 2.8 Employ Joins (ANSI vs. Oracle): Inner, Outer, Self

57

Inner Joins

57

Outer Joins

61

Project 2-1 Joining Data Using Inner and Outer Joins

62

Project 2-2 Joining Data Using ANSI SQL Joins

65

Self-Joins

66

Critical Skill 2.9 Learn the group by and having Clauses

67

group by

67

having

68

Project 2-3 Grouping Data in Your select Statements

69

Critical Skill 2.10 Learn Subqueries: Simple and Correlated Comparison with Joins

72

Simple Subquery

72

Correlated Subqueries with Joins

73

Critical Skill 2.11 Use Set Operators: Union, Intersect, Minus

74

union

74

union all

75

intersect

75

minus

76

Project 2-4 Using the union Function in Your SQL

76

Critical Skill 2.12 Use Views

78

Critical Skill 2.13 Learn Sequences: Just Simple Stuff

79

Critical Skill 2.14 Employ Constraints: Linkage to Entity Models, Types, Deferred, Enforced, Gathering Exceptions

80

Linkage to Entity Models

81

Types

82

Deferred

83

Critical Skill 2.15 Format Your Output with SQL*Plus

83

Page and Line Size

83

Page Titles

84

Page Footers

84

Formatting Columns

84

Project 2-5 Formatting Your SQL Output

84

Writing SQL*Plus Output to a File

87

Chapter 2 Mastery Check

87

3 The Database Administrator

89

Critical Skill 3.1 Learn the Job of the DBA

90

Critical Skill 3.2 Understand the Oracle Database 10g DBA Skill Set

90