Oracle Database 10g SQL

Jason Price

McGraw-Hill /Osborne

New York    Chicago    San Francisco
Lisbon    London    Madrid    Mexico City    Milan
New Delhi    San Juan    Seoul    Singapore    Sydney    Toronto

McGraw-Hill /Osborne
2100 Powell Street, 10th Floor
Emeryville, California 94608
U.S.A.

To arrange bulk purchase discounts for sales promotions, premiums, or fund-raisers, please contact McGraw-Hill /Osborne at the above address. For information on translations or book distributors outside the U.S.A., please see the International Contact Information page immediately following the index of this book.

Copyright 2004 by The McGraw-Hill Companies, Inc. (Publisher). All rights reserved. Printed in the United States of America. Except as permitted under the Copyright Act of 1976, no part of this publication may be reproduced or distributed in any form or by any means, or stored in a database or retrieval system, without the prior written permission of Publisher.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates .

Screen displays of copyrighted Oracle software programs have been reproduced herein with the permission of Oracle Corporation and/or its affiliates.

Excerpts of copyrighted Oracle user documentation have been reproduced herein with the permission of Oracle Corporation and/or its affiliates.

1234567890 FGR FGR 01987654

ISBN 0-07-222981-0

Publisher
Brandon A. Nordin

Vice President & Associate Publisher
Scott Rogers

Acquisitions Editor
Lisa McClain

Project Editors
Lisa Wolters-Broder
Mark Karmendy

Acquisitions Coordinator
Athena Honore

Technical Editor
Ron Hardman

Copy Editor
Lunaea Weatherstone

Proofreader
Claire Splan

Indexer
Valerie Robbins

Composition
Apollo Publishing Services
Tara A. Davis

Illustrators
Kathleen Edwards
Melinda Lytle
Michael Mueller

Series Design
Jani Beckwith
Peter F. Hancik

Cover Series Design
Sarah F. Hinks

This book was composed with Corel VENTURA ^¢ Publisher.

Information has been obtained by Publisher from sources believed to be reliable. However, because of the possibility of human or mechanical error by our sources, Publisher, or others, Publisher does not guarantee to the accuracy, adequacy, or completeness of any  information included in this work and is not responsible for any errors or omissions or the results obtained from the use of such information.

Oracle Corporation does not make any representations or warranties as to the accuracy, adequacy, or completeness of any information contained in this Work, and is not responsible for any errors or omissions.

This book is dedicated to my family.
Even though you re far away,
you are still in my heart.

About the Author

Jason Price is a freelance consultant and former product manager of Oracle Corporation. He has contributed to many of Oracle s products, including the database, the application server, and several of the CRM applications. Jason is an Oracle Certified Database Administrator and Application Developer, and has more than 10 years of experience in the software industry. Jason has written many books on Oracle, Java, and .NET. Jason holds a Bachelor of Science degree (with honors) in physics from the University of Bristol, England.

Acknowledgments

Thanks to the wonderful people at McGraw-Hill/Osborne, including Lisa McClain, Athena Honore, and Lisa Wolters-Broder. Thanks also to Ron Hardman for his thorough technical review, and to Geoff Lee at Oracle for reviewing the book and acting as the Oracle sponsor.