"Oracle9i: The Complete Reference" covers critical relational, object-oriented and Web database concepts, including SQL, PL/SQL, Java, JDBC, SQLJ and XML programming. New features like flashback queries, external tables, list partitions, CASE statements, multitable inserts, MERGE commands and more are included in this comprehensive resource. The Oracle9i data dictionary and optimizer are detailed, as are the basic concepts and commands of database administration. This is a must-have reference for all Oracle professionals. A CD that accompanies the book includes a fully searchable electronic version, complete listings of all practice tables and an Oracle9i "Information and Documentation Kit" featuring an Oracle9i release 2 new features white paper and selected documentation. About the Author Kevin Loney is an expert in in the administration, design, development, tuning, security and recovery of Oracle databases and applications. An Oracle database administrator and developer since 1987, he is the author or co-author of numerous books, including "Oracle9i DBA Handbook," "Oracle9i Instant Scripts" and "Oracle8 Advanced Tuning and Administration," all published by Oracle Press. He is a frequent presenter at local and international Oracle users group shows and conferences. Table of Contents		Authors Kevin Loney George Koch Book Information Paperback 1,296 pages ISBN: 0072225211 Downloads Sample Scripts (9Kb) Order it from Amazon
Chapter 1: Sharing Knowledge and Success Chapter 2: The Dangers in a Relational Database Chapter 3: The Basic Parts of Speech in SQL Chapter 4: The Basics of Object-Relational Databases Chapter 5: Introduction to Web-Enabled Databases Chapter 6: Basic SQL*PLUS Reports and Commands Chapter 7: Getting Text Information and Changing It Chapter 8: Playing the Numbers Chapter 9: Dates: Then, Now and the Difference Chapter 10: Conversion and Transformation Functions Chapter 11: Grouping Things Together Chapter 12: When One Query Depends Upon Another Chapter 13: Some Complex Possibilities Chapter 14: Building a Report in SQL*PLUS Chapter 15: Changing Data: Insert, Update, Merge and Delete Chapter 16: Advanced Use of Functions and Variables Chapter 17: DECODE and CASE: If, Then and Else in SQL Chapter 18: Creating, Dropping and Altering Tables and Views Chapter 19: By What Authority? Chapter 20: Changing the Oracle Surroundings Chapter 21: Using SQL*Loader to Load Data Chapter 22: Accessing Remote Data Chapter 23: Using Materialized Views Chapter 24: Using Oracle Text for Text Searches Chapter 25: Using External Tables Chapter 26: Using Flashback Queries Chapter 27: An Introduction to PL/SQL Chapter 28: Triggers Chapter 29: Procedures, Functions and Packages Chapter 30: Implementing Types, Object Views and Methods Chapter 31: Collectors (Nested Tables and Varying Arrays) Chapter 32: Using Large Objects Chapter 33: Advanced Object-Oriented Concepts Chapter 34: An Introduction to Java Chapter 35: JDBC and SQLJ Programming Chapter 36: Java Stored Procedures Chapter 37: The Hitchhiker's Guide to the Oracle9i Data Dictionary Chapter 38: The Hitchhiker's Guide to the Oracle Optimizer Chapter 39: The Hitchhiker's Guide to Oracle9iAS Chapter 40: The Hitchhiker's Guide to Database Administration Chapter 41: The Hitchhiker's Guide to XML in Oracle Alphabetical Reference of Commands, Clauses and Concepts