Oracle - Mastering Oracle SQL.pdf

(4725 KB) Pobierz
,TITLE.12934 Page i Wednesday, March 27, 2002 2:34 PM
Mastering Oracle SQL
Sanjay Mishra and Alan Beaulieu
Beijing
•
Cambridge
•
Farnham
•
Köln
•
Paris
•
Sebastopol
•
Taipei
•
Tokyo
,COPYRIGHT.12657 Page ii Wednesday, March 27, 2002 2:34 PM
Mastering Oracle SQL
by Sanjay Mishra and Alan Beaulieu
Copyright © 2002 O’Reilly & Associates, Inc. All rights reserved.
Printed in the United States of America.
Published by O’Reilly & Associates, Inc., 1005 Gravenstein Highway North,
Sebastopol, CA 95472.
O’Reilly & Associates 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
corporate@oreilly.com.
Editor:
Production Editor:
Cover Designers:
Interior Designer:
Printing History:
April 2002:
Jonathan Gennick
Colleen Gorman
Ellie Volckhausen and Emma Colby
David Futato
First Edition.
Nutshell Handbook, the Nutshell Handbook logo, and the O’Reilly logo are registered
trademarks of O’Reilly & Associates, Inc. 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 & Associates, Inc. was aware of a trademark claim, the designations
have been printed in caps or initial caps. 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 & Associates, Inc., is independent of Oracle Corporation. The association
between the image of a lantern fly and the topic of mastering Oracle SQL is a trademark of
O’Reilly & Associates, Inc.
While every precaution has been taken in the preparation of this book, the publisher and the
authors assume no responsibility for errors or omissions, or for damages resulting from the use of
the information contained herein.
ISBN: 0-596-00129-0
[M]
,AUTHOR.COLO.12460 Page 1 Wednesday, March 27, 2002 2:33 PM
About the Authors
Sanjay Mishra
is a certified Oracle database administrator with more than ten years of
IT experience. He has been involved in the design, architecture, and implementation of
many mission-critical and decision support databases. He has worked extensively in
database architecture, database management, backup/recovery, performance tuning,
Oracle Parallel Server, and parallel execution. He has a Bachelor of Science degree in
Electrical Engineering and a Master of Engineering degree in Systems Science and Auto-
mation. He is the coauthor of
Oracle Parallel Processing
and
Oracle SQL Loader: The
Definitive Guide
(both published by O’Reilly). Presently, he works as a database archi-
tect at Dallas-based i2 Technologies, and can be reached at
Sanjay_Mishra@i2.com.
Alan Beaulieu
has been designing, building, and implementing custom database appli-
cations for over 13 years. He currently runs his own consulting company that
specializes in designing Oracle databases and supporting services in the fields of finan-
cial services and telecommunications. In building large databases for both OLTP and
OLAP environments, Alan utilizes such Oracle features as Parallel Query, Partitioning,
and Parallel Server. Alan has a Bachelor of Science degree in Operations Research from
the Cornell University School of Engineering. He lives in Massachusetts with his wife
and two daughters and can be reached at
albeau_mosql@yahoo.com.
Colophon
Our look is the result of reader comments, our own experimentation, and feedback
from distribution channels. Distinctive covers complement our distinctive approach
to technical topics, breathing personality and life into potentially dry subjects.
The insect on the cover of
Mastering Oracle SQL
is a lantern fly. The lantern fly is
mostly tropical, with a wingspan of up to six inches. The lantern fly’s elongated head is
an evolutionary adaptation called automimicry, in which parts of the body are disguised
or artifically shifted to other areas to confuse predators: the lantern fly’s head looks like
a tail, and its tail looks like a head. On the rear it has artificial eyes and antennae.
Colleen Gorman was the production editor and copyeditor for
Mastering Oracle SQL.
Sheryl Avruch and Ann Schirmer provided quality control. Tom Dinse wrote the index.
Ellie Volckhausen and Emma Colby designed the cover of this book, based on a
series design by Edie Freedman. The cover image is a 19th-century engraving from
Johnson’s Natural History. Emma Colby produced the cover layout with Quark-
XPress 4.1 using Adobe’s ITC Garamond font.
David Futato designed the interior layout. Neil Walls converted the files from
Microsoft Word to FrameMaker 5.5.6 using tools written in Perl by Erik Ray, Jason
McIntosh, and Neil Walls, as well as tools written by Mike Sierra. The text font is
Linotype Birka; the heading font is Adobe Myriad Condensed; and the code font is
LucasFont’s TheSans Mono Condensed. The illustrations that appear in the book
were produced by Robert Romano and Jessamyn Read using Macromedia FreeHand
9 and Adobe Photoshop 6. The tip and warning icons were drawn by Christopher
Bing. This colophon was written by Colleen Gorman.
,DEDICATION.12802 Page iii Wednesday, March 27, 2002 2:34 PM
I dedicate this book to my father.
I wish he were alive to see this book.
—Sanjay Mishra
To my daughters, Michelle and Nicole.
—Alan Beaulieu
,DEDICATION.12802 Page iv Wednesday, March 27, 2002 2:34 PM

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin