About the Book
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.
Related Books
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 |
