Oracle8i: The Complete Reference (Book/CD-ROM Package) Hardcover – May 23, 2000

As documentation of a product that incorporates a highly reliable database server, a set of utilities, and a development environment, Oracle8i: The Complete Reference essentially sets out to do the impossible. The great thing is that it succeeds. For all but the most obscure and situation-specific Oracle8i questions that database administrators (DBAs) and developers might have, this book is almost certain to have the information they need. It explains all the essentials with a straightforward combination of prose, conceptual diagrams, and code listings, so even new Oracle DBAs will derive a lot of use from the authors' work. The key concepts--including relational database design, and queries that use SQL and PL/SQL--get lots of attention. Many details seem to come up at least twice, so readers get a couple of angles on a given subject.

This book isn't a rehash of earlier editions, any more than Oracle8i itself is a rehash of its predecessors. The authors pay special attention to the new aspects of the Oracle environment, particularly to those having to do with stored procedures and Oracle's deepening relationship with the Java programming language. Don't expect to learn Java from the ground up in these pages, but look forward to a comprehensive statement of how Java code (and SQLJ queries) can make your Oracle applications more capable and platform-independent. Every Oracle DBA (and probably every Oracle developer, too) should keep this volume on hand; it's a definitive reference. Although the book isn't designed specifically as a study aid, you certainly could use it as a guide while preparing for Oracle certification. --David Wall

Topics covered: Administration of Oracle databases, and development of applications based upon them. Administrators of Oracle7.x, 8.0.x, and 8i systems will appreciate the sections on performance tuning, optimization, backup, recovery, and general relational database design. Readers with more of a development bent will like the coverage of SQL, PL/SQL, stored procedures, and Oracle's Java features. Sample code appears on a companion CD-ROM, as well as in print.

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