Oracle 8

by Koch, George; Loney, Kevin

• ISBN13: 9780078823961
• ISBN10: 007882396X
• Edition: CD
• Format: Hardcover
• Copyright: 1997-08-01
• Publisher: Oracle Pr

Summary

With its increased page count, up-to-the-minute information, CD-ROM, and new coverage on Object technology, "Oracle8: The Complete Reference" is the all-in-one reference that virtually replaces the manuals provided by Oracle Corp. The book is part of the Oracle Press series and features a CD-ROM that contains the reference section, plus all the tables from the book.

Table of Contents

Part I: Critical Database Concepts. Sharing Knowledge and Success. The Dangers in a Relational Database. Part II: SQL: Going from Begninner to Expert. The Basic Parts of Speech in SQL. The Basics of Object-Relational Databases. Basic SQLPLUS Reports and Commands. Getting Text Information and Changing It. Playing the Numbers. Dates: Then, Now, and the Difference. Conversion and Transformation Functions. Grouping Things Together. When One Query Depends Upon Another. Some Complex Possibilities. Building a Report in SQLPLUS. Changing Data: Insert, Update, and Delete. Advanced Use of Functions and Variables. DECODE - Amazing Power in a Single Word. Creating, Dropping, and Altering Tables and Views. By What Authority? Changing the ORACLE Surroundings. SQLPLUS. Accessing Remote Data. An Introduction to Pl/SQL. Triggers. Procedures. Implementing Types, Object Views, and Methods. Collectors (Nested Tables and Varying Arrays). Using Large Objects (LOBs) in Oracle8. Snapshots. Using ConText for Text Searches. Configuring the ConText Option. Advanced Object-Oriented Concepts in ORACLE8. Part III: The Hitchhiker's Guide to the ORACLE8 Data Dictionary. Part IV: Designing for Productivity. Good Design has a Human touch. Performance and Design. The Ten Commandments of Human Design. The Hitchhiker's Guide to the ORACLE Optimizer. Part V: Alphabetical Reference. Part VI: Appendix. A: Tables Used in This Book.