Oracle8i: The Complete Reference (Book/CD-ROM Package)

Kevin Loney (Wilmington, DE) is a veteran Oracle developer and DBA. He is the author of the best-selling Oracle8 DBA Handbook and co-author of Advanced Tuning and Administration and Oracle8i: The Complete Reference. He frequently makes presentations at Oracle conferences and contributes to Oracle Magazine

Section I: Critical Database Concepts. Chapter 1: Sharing Knowledge and Success. Chapter 2: The Dangers in a Relational Database. Section II: SQL: Going from Beginner to Expert. Chapter 3: The Basic Parts of Speech in SQL. Chapter 4: The Basics of Object-Relational Databases. Chapter 5: Basic SQLPLUS Reports and Commands. Chapter 6: Getting Text Information and Changing It. Chapter 7: Playing the Numbers. Chapter 8: Dates: Then, Now, and the Difference. Chapter 9: Conversion and Transformation Functions. Chapter 10: Grouping Things Together. Chapter 11: When One Query Depends Upon Another. Chapter 12: Some Complex Possibilities. Chapter 13: Building a Report in SQLPLUS. Chapter 14: Changing Data: Insert, Updated, and Delete. Chapter 15: Advanced Use of Functions and Variables. Chapter 16: DECODE: Amazing Power in A Single Word. Chapter 17: Creating, Dropping and Altering Tables, Partitions, and Views. Chapter 18: By What Authority? Chapter 19: Changing the ORACLE Surroundings. Chapter 20: Tips/Techniques. Chapter 21: Accessing Remote Data. Chapter 22: An Introduciton to PL/SQL. Chapter 23: Triggers. Chapter 24: Procedures, Functions, and Packages. Chapter 25: Implementing Types, Ojbective views, and Methods. Chapter 26: Collectors (Nested Tables and Varying Arrays). Chapter 27: Using Large Objects (LOBs). Chapter 28: Snapshots. Chapter 29: Using Context for Text Searches. Chapter 30: New Content. Chapter 31: Advanced Object-Oriented Concepts. Section III: Java in Oracle. Chapter 32: An Introduction to Java. Chapter 33: JDBG and SQLJ. Chapter 34: Java Stored Procedures and Enterprise Java Beans. Chapter 35: Web-Based Architecture Issues. Section IV: Ilitchhiker's Guides. Chapter 36: Ilitchhiker's Guide to the Data Dictionary. Chapter 37: Ilitchhiker's Guide to the Optimizer. Chapter 38: Ilitchhiker's Guide WebDB. Chapter 39: Ilitchhiker's Guide to Database Administration. Section V: Designing for Performance. Good Design Has a Human Touch. Performance and Design. The Ten Commandments of Ilumane Design.