Oracle in a Nutshell

In the tradition of O'Reilly's "Nutshell" series, this book brings order to the chaos of Oracle database documentation. The pace of Oracle's new product introduction has quickened dramatically over the past three years, and with each new feature-packed release, a huge amount of documentation appears on their web site, making it harder and harder for Oracle developers and database administrators to make sense of it all. Written by Oracle experts, Oracle in a Nutshell pulls together the most essential information, packages it for a reasonably technical readership, and provides that special "Nutshell" slant on making the information accessible.

has been active in the world of computer software for nearly two decades, including stints with Data General, Cognos, and Gupta. He is currently an analyst with Oracle Corporation. He has been a principal author of ten books and countless articles on a variety of technical topics, and has spoken at conferences and training sessions across six continents. In addition to Oracle in a Nutshell, Rick's books include Oracle Essentials: Oracle9i, Oracle8i, and Oracle8 (principal author with Robert Stackowiak and Jonathan Stern, O'Reilly & Associates, 2001), Oracle Power Objects Developer's Guide (principal author with Kasu Sista and Richard Finklestein, Oracle Press, 1995); Mastering Oracle Power Objects (principal author with Robert Hoskins, O'Reilly & Associates, 1996); Using Oracle Web Server (principal author with many others, Que Publishing, 1997); The Oracle WebDB Bible (principal author with Jim Milbery, IDG Books Worldwide, 1999); and Administering Exchange Server (principal author with Walter Glenn, Microsoft Press, 1999).

Preface

xi

Part I. Foundations

Architecture and Packaging

3

(14)

Oracle Instances and Databases

3

(1)

The Components of a Database

4

(6)

The Components of an Instance

10

(3)

Oracle Versions

13

(1)

Oracle Packaging

14

(3)

Configuration

17

(61)

Parameter Files and Types

18

(2)

Initialization Parameters

20

(58)

Concurrency

78

(7)

Concurrency Concepts

78

(3)

Oracle and Concurrent User Access

81

(4)

Security

85

(31)

Authentication

85

(3)

Profiles

88

(2)

Privileges

90

(12)

Privileges and Users

102

(2)

Roles

104

(3)

Auditing

107

(5)

Other Security Features

112

(4)

Networking

116

(29)

Oracle Networking Fundamentals

116

(4)

Configuration Files

120

(20)

Networking Management Utilities

140

(5)

Data Dictionary

145

(34)

Static Data Dictionary Views

145

(16)

Dynamic Data Dictionary Views

161

(18)

Part II. Languages

SQL

179

(109)

Common Keywords and Identifiers

179

(2)

Common SQL Clauses

181

(12)

Data Definition Statements

193

(74)

Data Manipulation Statements

267

(21)

Functions

288

(41)

Common Keywords and Clauses

289

(1)

Aggregate and Analytic Functions

290

(9)

Numeric Functions

299

(3)

Character Functions

302

(5)

Date and Time Functions

307

(7)

Conversion Functions

314

(5)

Object Functions

319

(1)

XML Functions

320

(2)

Miscellaneous Functions

322

(7)

PL/SQL

329

(50)

PL/SQL Fundamentals

329

(3)

Header Section

332

(3)

Declaration Section

335

(9)

Execution Section

344

(15)

Exception Section

359

(3)

Pragmas

362

(1)

Program Units

362

(4)

Packages

366

(3)

Triggers

369

(3)

Calling PL/SQL Functions in SQL

372

(2)

Native Compilation of PL/SQL

374

(1)

External Procedures

375

(3)

Java and PL/SQL

378

(1)

PL/SQL Packages

379

(190)

Java and Oracle

569

(100)

Java Drivers

570

(1)

Java in the Oracle Database

570

(6)

Data Mapping

576

(1)

SQLJ

577

(11)

JDBC

588

(81)

Part III. Tools and Utilities

SQL *Plus

669

(42)

Running SQL *Plus

669

(5)

Formatting Text Reports

674

(3)

SQL *Plus Format Elements

677

(2)

Commands

679

(32)

Export and Import

711

(11)

Export/Import Fundamentals

711

(4)

Common Parameters

715

(3)

Export-Only Parameters

718

(1)

Import-Only Parameters

719

(3)

SQL *Loader

722

(15)

Running SQL *Loader

723

(1)

Command-Line Parameters

723

(4)

Control File

727

(10)

Backup and Recovery

737

(52)

Backup and Recovery Fundamentals

738

(2)

User-Managed Backup and Recovery

740

(11)

Recovery Manager (RMAN)

751

(38)

Enterprise Manager

789

(15)

Architecture

790

(1)

Running Enterprise Manager

791

(1)

Enterprise Manager Interface

791

(4)

Enterprise Manager Administration

795

(3)

Expansion Packs

798

(3)

Oemutil

801

(3)

Performance

804

(53)

SQL Optimization

804

(11)

Explain Plan

815

(4)

Tkprof

819

(4)

Autotrace

823

(1)

Statistics Collection

824

(7)

Part IV. Appendixes

A. Datatypes

831

(9)

B. Expressions, Operators, and Conditions

840

(6)

C. Numeric Formats

846

(2)

D. Data Formats

848

(3)

E. Additional Resources

851

(6)

Index

857

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Summary

Author Biography

Table of Contents

Supplemental Materials