Oracle Essentials Oracle Database 11g

Read Oracle Essentials Oracle Database 11g Online

Authors: Rick Greenwald

Oracle Essentials

Oracle Database 11g

Other Oracle resources from O’Reilly

Related titles

Mastering Oracle SQL

Oracle DBA Pocket Guide

Optimizing Oracle

Oracle in a Nutshell

Performance

Oracle PL/SQL Programming

Oracle Application Server 10
g

Oracle SQL*Plus: The Defini-

Essentials

tive Guide

Oracle Books

oracle.oreilly.com
is a complete catalog of O’Reilly’s books on
Resource Center

Oracle and related technologies, including sample chapters and code examples.

oreillynet.com
is the essential portal for developers interested in open and emerging technologies, including new platforms, programming languages, and operating systems.

Conferences

O’Reilly brings diverse innovators together to nurture the ideas that spark revolutionary industries. We specialize in document-ing the latest tools and systems, translating the innovator’s knowledge into useful skills for those in the trenches. Visit
conferences.oreilly.com
for our upcoming events.

Safari Bookshelf (
safari.oreilly.com
) is the premier online reference library for programmers and IT professionals. Conduct

searches across more than 1,000 books. Subscribers can zero in on answers to time-critical questions in a matter of seconds.

Read the books on your Bookshelf from cover to cover or sim-

ply flip to the page you need. Try it today for free.

FOURTH EDITION

Oracle Essentials

Oracle Database 11g

Rick Greenwald, Robert Stackowiak, and

Jonathan Stern

Beijing
•
Cambridge
•
Farnham
•
Köln
•
Paris
•
Sebastopol
•
Taipei
•
Tokyo
Oracle Essentials: Oracle Database 11g, Fourth Edition

by Rick Greenwald, Robert Stackowiak, and Jonathan Stern

Printed in the United States of America.

Published by O’Reilly Media, Inc., 1005 Gravenstein Highway North, Sebastopol, CA 95472.

O’Reilly books may be purchased for educational, business, or sales promotional use. Online editions

are also available for most titles (
safari.oreilly.com
). For more information, contact our corporate/institutional sales department: (800) 998-9938 or
[email protected]
.

Editors:
Colleen Gorman and Deborah Russell

Interior Designer:
David Futato

Production Editor:
Sumita Mukherji

Cover Designer:
Karen Montgomery

Production Services:
Tolman Creek Design

Illustrator:
Robert Romano

Printing History:

October 1999:

First Edition. Originally published under the title

Oracle Essentials: Oracle8 and Oracle8i

June 2001:

Second Edition. Originally published under the title

Oracle Essentials: Oracle9i, Oracle8i and Oracle8

February 2004:

Third Edition. Originally published under the title

Oracle Essentials: Oracle Database 10g

November 2007:

Fourth Edition.

Nutshell Handbook, the Nutshell Handbook logo, and the O’Reilly logo are registered trademarks of O’Reilly Media, Inc.
Oracle Essentials: Oracle Database 11g
, the image of cicadas, and related trade dress are trademarks of O’Reilly Media, Inc.

Oracle® and all Oracle-based trademarks and logos are trademarks or registered trademarks of Oracle Corporation, Inc. in the United States and other countries. O’Reilly Media, Inc. is independent of Oracle Corporation. Java™ and all Java-based trademarks and logos are trademarks or registered trademarks of Sun Microsystems, Inc. in the United States and other countries. O’Reilly Media, Inc. is independent of Sun Microsystems. .NET is a registered trademark of Microsoft Corporation.

Many of the designations used by manufacturers and sellers to distinguish their products are claimed as trademarks. Where those designations appear in this book, and O’Reilly Media, Inc. was aware of a trademark claim, the designations have been printed in caps or initial caps.

While every precaution has been taken in the preparation of this book, the publisher and authors assume no responsibility for errors or omissions, or for damages resulting from the use of the information contained herein.

This book uses RepKover™, a durable and flexible lay-flat binding.

ISBN-10: 0-596-51454-9

ISBN-13: 978-0-596-51454-9

[M]

In memory of Jonathan

Table of Contents

Preface
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xi

1. Introducing Oracle
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
1

The Evolution of the Relational Database

The Oracle Database Family

Summary of Oracle Database Features

Database Application Development Features