Oracle Database 10g: The Complete Reference (Paperback)

Description:

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.

 

 

Table of Contents:

PART I: Critical Database Concepts

Chapter 1: Oracle Database 10g Architecture Options

Chapter 2: Installing Oracle Database 10g and Creating a Database

Chapter 3: Upgrading to Oracle Database 10g

Chapter 4: Planning Oracle Applications—Approaches, Risks, and Standards

PART II: SQL and SQL*Plus

Chapter 5: The Basic Parts of Speech in SQL

Chapter 6: Basic SQL*Plus Reports and Commands

Chapter 7: Getting Text Information and Changing It

Chapter 8: Searching for Regular Expressions

Chapter 9: Playing the Numbers

Chapter 10: Dates: Then, Now, and the Difference

Chapter 11: Conversion and Transformation Functions

Chapter 12: Grouping Things Together

Chapter 13: When One Query Depends upon Another

Chapter 14: Some Complex Possibilities

Chapter 15: Changing Data insert, update, merge, and delete

Chapter 16: DECODE and CASE: if, then, and else in SQL

Chapter 17: Creating and Managing Tables, Views, Indexes, Clusters, and Sequences

Chapter 18: Basic Oracle Security

PART III: Beyond the Basics

Chapter 19: Advanced Security—Virtual Private Databases

Chapter 20: Working with Tablespaces

Chapter 21: Using SQL*Loader to Load Data

Chapter 22: Using Data Pump Export and Import

Chapter 23: Accessing Remote Data

Chapter 24: Using Materialized Views

Chapter 25: Using Oracle Text for Text Searches

Chapter 26: Using External Tables

Chapter 27: Using Flashback Queries

Chapter 28: Flashback—Tables and Databases

PART IV: PL/SQL

Chapter 29: An Introduction to PL/SQL

Chapter 30: Triggers

Chapter 31: Procedures, Functions, and Packages

Chapter 32: Using Native Dynamic SQL and DBMS_SQL

PART V: Object-Relational Databases

Chapter 33: Implementing Types, Object Views, and Methods

Chapter 34: Collectors (Nested Tables and Varying Arrays)

Chapter 35: Using Large Objects

Chapter 36: Advanced Object-Oriented Concepts

PART VI: Java in Oracle

Chapter 37: An Introduction to Java

Chapter 38: JDBC Programming

Chapter 39: Java Stored Procedures

PART VII: Clustered Oracle—The Grid

Chapter 40: Oracle Real Application Clusters

Chapter 41: Grid Architecture and Management

PART VIII: Hitchhiker’s Guides

Chapter 42: The Hitchhiker’s Guide to the Oracle Data Dictionary

Chapter 43: The Hitchhiker’s Guide to Tuning Applications and SQL

Chapter 44: Case Studies in Tuning

Chapter 45: The Hitchhiker’s Guide to Oracle Application Server 10g

Chapter 46: The Hitchhiker’s Guide to Database Administration

Chapter 47: The Hitchhiker’s Guide to XML in Oracle

Appendix: Alphabetical Reference