Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL.
Get code examples and access popular documentation PDFs plus a full electronic copy of the book on the included CD-ROM.
Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more.

• Part I: Critical Database Concepts
  • Oracle Database 10g Architecture Options
  • Installing Oracle Database 10g and Creating a Database
  • Upgrading to Oracle Database 10g
  • Planning Oracle Applications'Approaches, Risks, and Standards
• Part II: SQL and SQL
  • · Plus
  • The Basic Parts of Speech in SQL
  • Basic SQL
  • · Plus Reports and Commands
  • Getting Text Information and Changing It
  • Searching for Regular Expressions
  • 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
  • Changing Data insert, update, merge, and delete
  • DECODE and CASE: if, then, and else in SQL
  • Creating and Managing Tables, Views, Indexes, Clusters, and Sequences
  • Basic Oracle Security
• Part III: Beyond the Basics
  • Advanced Security'Virtual Private Databases
  • Working with Tablespaces
  • Using SQL
  • · Loader to Load Data
  • Using Data Pump Export and Import
  • Accessing Remote Data
  • Using Materialized Views
  • Using Oracle Text for Text Searches
  • Using External Tables
  • Using Flashback Queries
  • Flashback'Tables and Databases
• Part IV: PL/SQL
  • An Introduction to PL/SQL
  • Triggers
  • Procedures, Functions, and Packages
  • Using Native Dynamic SQL and DBMS_SQL
• Part V: Object-Relational Databases
  • Implementing Types, Object Views, and Methods
  • Collectors (Nested Tables and Varying Arrays)
  • Using Large Objects
  • Advanced Object-Oriented Concepts
• Part VI: Java in Oracle
  • An Introduction to Java
  • JDBC Programming
  • Java Stored Procedures
• Part VII: Clustered Oracle'The Grid
  • Oracle Real Application Clusters
  • Grid Architecture and Management
• Part VIII: Hitchhiker's Guides
  • The Hitchhiker's Guide to the Oracle Data Dictionary
  • The Hitchhiker's Guide to Tuning Applications and SQL
  • Case Studies in Tuning
  • The Hitchhiker's Guide to Oracle Application Server 10g
  • The Hitchhiker's Guide to Database Administration
  • The Hitchhiker's Guide to XML in Oracle
  • Appendix: Alphabetical Reference