Synopses & Reviews
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
As the new Oracle8i technology transitions into a complete, Internet-based database solution, this guide defines, explains, and instructs the entire feature set, including how to integrate the many components of the core product. CD contains an electronic version of the book.
Announcing the 10th Anniversary Edition of the best-selling Oracle book of all time--Oracle8i: The Complete Reference! Written by Oracle experts and complete with a fully searchable book and reusable code on CD-ROM, this is the most definitive resource available on Oracle8i. It's a must-have for every Oracle professional.
This text covers topics such as the usage of the WebDB development environment, the usage of the Internet File System, Java implementation within the Oracle kernel, along with walkthroughs of Java and its usage in database programming.
Table of Contents
Section I: Critical Database Concepts.
Chapter 1: Sharing Knowledge and Success.
Chapter 2: The Dangers in a Relational Database.
Section II: SQL: Going from Beginner to Expert.
Chapter 3: The Basic Parts of Speech in SQL.
Chapter 4: The Basics of Object-Relational Databases.
Chapter 5: Basic SQLPLUS Reports and Commands.
Chapter 6: Getting Text Information and Changing It.
Chapter 7: Playing the Numbers.
Chapter 8: Dates: Then, Now, and the Difference.
Chapter 9: Conversion and Transformation Functions.
Chapter 10: Grouping Things Together.
Chapter 11: When One Query Depends Upon Another.
Chapter 12: Some Complex Possibilities.
Chapter 13: Building a Report in SQLPLUS.
Chapter 14: Changing Data: Insert, Updated, and Delete.
Chapter 15: Advanced Use of Functions and Variables.
Chapter 16: DECODE: Amazing Power in A Single Word.
Chapter 17: Creating, Dropping and Altering Tables, Partitions, and Views.
Chapter 18: By What Authority?