Oracle 8i: The Complete Reference - Hardcover

Loney, Kevin; Koch, George

Hardcover

ISBN 10: 0072123648 ISBN 13: 9780072123647

Publisher: McGraw-Hill Education, 2000

Synopsis

This is the most definitive resource available on Oracle8i and is a must-have for every Oracle professional. The book describes how to master all the powerful features of Oracle8i--the most complete and comprehensive platform for building and deploying Internet and enterprise applications. Written by best-selling Oracle author, Kevin Loney, and a former senior vice president of Oracle Corporation, George Koch, Oracle8i: The Complete Reference covers all the components of this robust product. The reader will learn key relational and object-relational database concepts, SQL, PL/SQL, SQLJ, and Java programming techniques, backup, recovery, and tuning methods, and much more. A fully searchable version of the book and reusable code are included on the CD-ROM.

About this title

Review

This whopping 1,300-page book is a reference book par excellence, and the CD-ROM is equally useful, being the complete and searchable text (albeit in the stranglehold of Acrobat's .PDF format) with, ready to copy and paste, all the example tables and code. Divided into nine parts, it begins with critical database concepts which include the basics of relational databases, surprisingly with a perpetuation of the myth that the word "relational" comes from the fact that data in one table is related to data in another, rather than from set theory. Object-relational and Web-enabled databases and SQL syntax are also outlined.

There is a great deal on the SQL querying language in this book: 400 pages on SQL and SQL*Plus (Oracle's querying front-end/reporting tool), 50 more on Oracle's PL/SQL extensions to SQL and 300 pages of alphabetical reference of commands from SQL, PL/SQL and SQL*Plus. Other parts cover Java, two "Hitchhiker's Guides" to Oracle's optimizer and 8i's data dictionary, object-related databases and designing for performance.

The style is readable if somewhat lacking in character and the book is destined to be used, as indeed the title states, as reference material rather than a teaching aid. The CD-ROM electronic text version effectively gives you two copies of this useful work: installed on your laptop, it can be always to hand--and you certainly wouldn't choose to tote the hard copy around all the time. --Mark Whitehorn

From the Back Cover

The Official Resource on Oracle's E-Business-Enabled Database Solution.

Master all the powerful features of Oracle8i the most complete and comprehensive platform for building and deploying Internet and enterprise applications. Written by best-selling Oracle author, Kevin Loney, and a former senior vice president of Oracle Corporation, George Koch, Oracle8i: The Complete Reference covers all the components of this robust product. You'll learn key relational and object-relational database concepts; SQL, PL/SQL, SQLJ, and Java programming techniques; backup, recovery, and tuning methods; and much more.

- Get full details on critical database concepts, including all of the new Oracle8i features

- Handle SQL queries and data conversion

- Build reports with SQL -Plus

- Develop robust, Web-enabled PL/SQL applications

- Execute object technology in Oracle8i

- Implement object technology in Oracle8i
- Create multi-platform database applications with SQLJ and JDBC

- Use Oracle8i developer tools, including the data dictionary and optimizer

- Guarantee the security, recoverability, and availability of the database

- Back up, recover, and tune Oracle8i databases

Edition details

• Publisher: McGraw-Hill Education
• Publication date: 2000
• ISBN 10: 0072123648
• ISBN 13: 9780072123647
• Binding: Hardcover
• Language: English
• Number of pages: 1392