Oracle8: The Complete Reference
Published on 16. October 1997
Book
Hardback
1344 pages
978-0-07-882396-1 (ISBN)
Description
With more than 100,000 copies sold, Oracle8: The Complete Reference is the ``must have'' book for all Oracle DBAs--or anyone who wants to be thoroughly versed on Oracle. Now thoroughly updated and expanded for Oracle8, it's the ultimate authority in the Oracle community. Special hardcover edition--completely updated to cover Oracle8. Includes a CD-ROM with an electronic version of the book, including tables and examples. Discusses implementing object technology in Oracle8 and developing applications with Oracle Context. Provides additional information regarding Oracle8's more robust handling of VLDBs (Very Large DataBases), a big advantage for DBAs.
More details
Language
English
Place of publication
United States
Publishing group
McGraw-Hill Education - Europe
Target group
Professional and scholarly
Illustrations
tables
Dimensions
Height: 234 mm
Width: 193 mm
Thickness: 72 mm
Weight
2353 gr
ISBN-13
978-0-07-882396-1 (9780078823961)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
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
Content
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.