1: Sharing Knowledge and Success

2: The Dangers in a Relational Database

3: The Basic Parts of Speech in SQL

4: The Basics of Object-Relational Databases

5: Introduction to Web-Enabled Databases

PART II: SQL and SQL*PLUS

6: Basic SQL*PLUS Reports and Commands

7: Getting Text Information and Changing It

8: Playing the Numbers

9: Dates: Then, Now, and the Difference

10: Conversion and Transformation Functions

11: Grouping Things Together

12: When One Query Depends upon Another

13: Some Complex Possibilities

14: Building a Report in SQL*PLUS

15: Changing Data: insert, update, merge, and delete

16: Advanced Use of Functions and Variables

17: DECODE and CASE: if, then, and else in SQL

18: Creating, Dropping, and Altering Tables and Views

19: By What Authority?

20: Changing the Oracle Surroundings

21: Using SQL*Loader to Load Data

22: Accessing Remote Data

23: Using Materialized Views

24: Using Oracle Text for Text Searches

25: Using External Tables

26: Using Flashback Queries

PART III: PL/SQL

27: An Introduction to PL/SQL

28: Triggers

29: Procedures, Functions, and Packages

PART IV: Object-Relational Databases

30: Implementing Types, Object Views, and Methods

31: Collectors (Nested Tables and Varying Arrays)

32: Using Large Objects

33: Advanced Object-Oriented Concepts

PART V: Java in Oracle

34: An Introduction to Java

35: JDBC and SQLJ Programming

36: Java Stored Procedures

PART VI: Hitchhiker’s Guides

37: The Hitchhiker’s Guide to the Oracle9i Data Dictionary

38: The Hitchhiker’s Guide to the Oracle Optimizer

39: The Hitchhiker’s Guide to Oracle9iAS

40: The Hitchhiker’s Guide to Database Administration

41: The Hitchhiker’s Guide to XML in Oracle

PART VII: Alphabetical Reference Reference