Oracle Database 10g SQL (Osborne ORACLE Press Series)
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.