Sybex - OCA-OCP - Introduction to Oracle 9i SQL. Study Guide (2002), Informatyka, ● PHP, MySQL, ORACLE
[ Pobierz całość w formacie PDF ]
Using Your Sybex Electronic Book
To realize the full potential of this Sybex electronic book, you must have Adobe Acrobat Reader with
Search installed on your computer. To find out if you have the correct version of Acrobat Reader, click on
the Edit menu—Search should be an option within this menu file. If Search is not an option in the Edit
menu, please exit this application and install Adobe Acrobat Reader with Search from this CD (double-
click on rp500en
u
.exe in the Adobe folder).
Navigation
Navigate throught the book by clicking on the headings that appear in the left panel;
the corresponding page from the book displays in the right panel
.
Search
To search, click the Search Query button on the toolbar
or choose Edit >Search > Query to open the Search window. In
the Adobe Acrobat Search dialog’s text field, type the text you
want to find and click Search.
Use the Search Next button (Control+U) and Search
Previous button (Control+Y) to go to other matches in
the book. The Search command also has powerful tools for
limiting and expanding the definition of the term you are
searching for. Refer to Acrobat's online Help (Help > Plug-In
Help > Using Acrobat Search) for more information.
Click here to begin using
your Sybex E lectronic Book!
www.sybex.com
Introduction to
Oracle9i
™
SQL
Study Guide
Chip Dawes
Biju Thomas
San Francisco • London
OCA/OCP:
Associate Publishers: Richard Mills and Neil Edde
Acquisitions Editor: Christine McGeever
Developmental Editor: Elizabeth Hurley
Editors: Marilyn Smith and Carol Henry
Production Editor: Leslie E. H. Light
Technical Editors: Ashok Hanumanth and Damir Bersinic
Graphic Illustrator: Tony Jonick
Electronic Publishing Specialist: Jill Niles
Proofreaders: Emily Hsuan, David Nash, Laurie O’Connell, and Nancy Riddiough
Indexer: Ted Laux
CD Coordinator: Dan Mummert
CD Technician: Kevin Ly
Book Designer: Bill Gibson
Cover Designer: Archer Design
Cover Photographer: Photo Researchers
Copyright © 2002 SYBEX Inc., 1151 Marina Village Parkway, Alameda, CA 94501. World rights reserved. No part of this
publication may be stored in a retrieval system, transmitted, or reproduced in any way, including but not limited to photo-
copy, photograph, magnetic, or other record, without the prior agreement and written permission of the publisher.
Library of Congress Card Number: 2001099188
ISBN: 0-7821-4062-9
SYBEX and the SYBEX logo are either registered trademarks or trademarks of SYBEX Inc. in the United States and/or other
countries.
Screen reproductions produced with FullShot 99. FullShot 99 © 1991-1999 Inbit Incorporated. All rights reserved.
FullShot is a trademark of Inbit Incorporated.
The CD interface was created using Macromedia Director, COPYRIGHT 1994, 1997-1999 Macromedia Inc. For more
Internet screen shot(s) using Microsoft Internet Explorer reprinted by permission from Microsoft Corporation.
SYBEX is an independent entity from Oracle Corporation and is not affiliated with Oracle Corporation in any manner. This
publication may be used in assisting students to prepare for an Oracle Certified Associate/Professional exam. Neither Oracle
Corporation nor SYBEX warrants that use of this publication will ensure passing the relevant exam. Oracle is either a
registered trademark or a trademark of Oracle Corporation in the United States and/or other countries.
TRADEMARKS: SYBEX has attempted throughout this book to distinguish proprietary trademarks from descriptive terms
by following the capitalization style used by the manufacturer.
The author and publisher have made their best efforts to prepare this book, and the content is based upon final release software
whenever possible. Portions of the manuscript may be based upon pre-release versions supplied by software manufacturer(s).
The author and the publisher make no representation or warranties of any kind with regard to the completeness or accuracy
of the contents herein and accept no liability of any kind including but not limited to performance, merchantability, fitness
for any particular purpose, or any losses or damages of any kind caused or alleged to be caused directly or indirectly from
this book.
Manufactured in the United States of America
10 9 8 7 6 5 4 3 2 1
To Our Valued Readers:
In a CertCities.com article dated December 15, 2001, Oracle certification was ranked #2 in a list
of the “10 Hottest Certifications for 2002.” This shouldn’t come as a surprise, especially when you
consider the fact that the OCP program nearly tripled in size (from 30,000 to 80,000) in the last
year. Oracle continues to expand its dominance in the database market, and as companies begin
integrating Oracle9i systems into their IT infrastructure, you can be assured of high demand for
professionals with the Oracle Certified Associate and Oracle Certified Professional certifications.
Sybex is proud to have helped thousands of Oracle certification candidates prepare for the exams
over the years, and we are excited about the opportunity to continue to provide professionals like
you with the skills needed to succeed in the highly competitive IT industry.
Our authors and editors have worked hard to ensure that the Oracle9i Study Guide you hold in your
hands is comprehensive, in-depth, and pedagogically sound. We’re confident that this book will
meet and exceed the demanding standards of the certification marketplace and help you, the
Oracle9i certification candidate, succeed in your endeavors.
Good luck in pursuit of your Oracle9i certification!
Neil Edde
Associate Publisher—Certification
Sybex, Inc.
SYBEX Inc. 1151 Marina Village Parkway, Alameda, CA 94501
Software License Agreement: Terms and Conditions
The media and/or any online materials accompanying this
book that are available now or in the future contain programs
and/or text files (the "Software") to be used in connection with
the book. SYBEX hereby grants to you a license to use the
Software, subject to the terms that follow. Your purchase,
acceptance, or use of the Software will constitute your acceptance
of such terms.
The Software compilation is the property of SYBEX unless
otherwise indicated and is protected by copyright to SYBEX or
other copyright owner(s) as indicated in the media files (the
"Owner(s)"). You are hereby granted a single-user license to
use the Software for your personal, noncommercial use only.
You may not reproduce, sell, distribute, publish, circulate, or
commercially exploit the Software, or any portion thereof,
without the written consent of SYBEX and the specific copyright
owner(s) of any component software included on this media.
In the event that the Software or components include specific
license requirements or end-user agreements, statements of
condition, disclaimers, limitations or warranties ("End-User
License"), those End-User Licenses supersede the terms and
conditions herein as to that particular Software component.
Your purchase, acceptance, or use of the Software will
constitute your acceptance of such End-User Licenses.
By purchase, use or acceptance of the Software you further
agree to comply with all export laws and regulations of the
United States as such laws and regulations may exist from
time to time.
Warranty
SYBEX warrants the enclosed media to be free of physical
defects for a period of ninety (90) days after purchase. The
Software is not available from SYBEX in any other form or
media than that enclosed herein or posted to
www.sybex.com
.
If you discover a defect in the media during this warranty
period, you may obtain a replacement of identical format at no
charge by sending the defective media, postage prepaid, with
proof of purchase to:
SYBEX Inc.
Product Support Department
1151 Marina Village Parkway
Alameda, CA 94501
After the 90-day period, you can obtain replacement media of
identical format by sending us the defective disk, proof of pur-
chase, and a check or money order for $10, payable to SYBEX.
Disclaimer
SYBEX makes no warranty or representation, either expressed
or implied, with respect to the Software or its contents, quality,
performance, merchantability, or fitness for a particular purpose.
In no event will SYBEX, its distributors, or dealers be liable
to you or any other party for direct, indirect, special, incidental,
consequential, or other damages arising out of the use of or
inability to use the Software or its contents even if advised of the
possibility of such damage. In the event that the Software
includes an online update feature, SYBEX further disclaims any
obligation to provide this feature for any specific duration other
than the initial posting.
The exclusion of implied warranties is not permitted by some
states. Therefore, the above exclusion may not apply to you.
This warranty provides you with specific legal rights; there
may be other rights that you may have that vary from state to
state. The pricing of the book with the Software by SYBEX
reflects the allocation of risk and limitations on liability
contained in this agreement of Terms and Conditions.
Reusable Code in This Book
The authors created reusable code in this publication expressly
for reuse for readers. Sybex grants readers permission to reuse
for any purpose the code found in this publication or its
accompanying CD-ROM so long as all of the authors are
attributed in any application containing the reusable code, and
the code itself is never sold or commercially exploited as a
stand-alone product.
Software Support
Components of the supplemental Software and any offers
associated with them may be supported by the specific Owner(s)
of that material, but they are not supported by SYBEX.
Information regarding any available support may be obtained
from the Owner(s) using the information provided in the
appropriate read.me files or listed elsewhere on the media.
Should the manufacturer(s) or other Owner(s) cease to offer
support or decline to honor any offer, SYBEX bears no
responsibility. This notice concerning support for the Soft-
ware is provided for your information only. SYBEX is not the
agent or principal of the Owner(s), and SYBEX is in no way
responsible for providing any support for the Software, nor is it
liable or responsible for any support provided, or not provided,
by the Owner(s).
Shareware Distribution
This Software may contain various programs that are distributed
as shareware. Copyright laws apply to both shareware and
ordinary commercial software, and the copyright Owner(s)
retains all rights. If you try a shareware program and continue
using it, you are expected to register it. Individual programs
differ on details of trial periods, registration, and payment.
Please observe the requirements stated in appropriate files.
Copy Protection
The Software in whole or in part may or may not be copy-
protected or encrypted. However, in all cases, reselling or redis-
tributing these files without authorization is expressly forbidden
except as specifically provided for by the Owner(s) therein.
[ Pobierz całość w formacie PDF ]