Oracle 8

The Complete Reference
Erscheinungsjahr 1997
ISBN: 978-0-07-882396-1
Verlag: McGraw-Hill Education - Europe

Medienkombination, Englisch, 1300 Seiten, Format (B × H): 195 mm x 245 mm, Gewicht: 2477 g

Reihe: Oracle Press

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.

Autoren/Hrsg.

Koch, George S.

Koch, George

Loney, Kevin

Inhaltsverzeichnis

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.

Über Autor(innen)

Loney, Kevin
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

Kevin Loney ist Unternehmensberater bei TUSC und ein international anerkannter Experte für Design, Entwicklung, Administration und Tuning von Oracle Datenbanken. Seit 1987 ist er Oracle Entwickler und Datenbankadministrator. Er unterstützt Firmen bei der Einführung geschäftskritischer Oracle Applikationen.
Er ist Autor zahlreicher Fachaufsätze und Haupt- oder Co-Autor. Er hält regelmäßig Vorträge auf Oracle Anwender Konferenzen in Europa und den USA und wurde 2002 vom ORACLE Magazine zum"Consultant of the Year"gekürt.