here is high demand and competition for professionals in the Information Technology (IT) industry, and the Oracle Certified Professional (OCP) certification is the hottest credential in the database world. You have made the right decision to pursue certification: Being an OCP will give you a distinct advantage in this highly competitive market. Many readers may already be familiar with Oracle and do not need an introduction to the Oracle database world. For those who aren’t familiar with the company, Oracle (founded in 1977), is the world’s leading database company and second-largest independent software company, with revenues of more than $9 billion, serving more than 145 countries. Oracle databases are the de. | OCP Oracle8i DBA SQL and PL SQL Study Guide Copyright 2000 SYBEX Inc. Alameda CA OCP Oracle8i DBA SQL and PL SQL Study Guide Chip Dawes Biju Thomas SÆ3EX San Francisco Paris Düsseldorf Soest London Copyright 2000 SYBEX Inc. Alameda CA Associate Publisher Richard Mills Contracts and Licensing Manager Kristine O Callaghan Acquisitions Developmental Editor Kim Goodfriend Associate Developmental Editor Ben Tompkins Editor Nancy Conner Marilyn Smith Production Editors Lisa Duran Leslie E. H. Light Technical Editors Betty MacEwen Ashok Hanumanth Book Designer Bill Gibson Graphic Illustrator Tony Jonick Electronic Publishing Specialist Susie Hendrickson Proofreader Lindy Wolf Indexer Matthew Spence CD Coordinator Kara Eve Schwartz CD Technician Keith McNeil Cover Design Archer Design Cover Photograph Photo Researchers Copyright 2000 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 photocopy photograph magnetic or other record without the prior agreement and written permission of the publisher. Library of Congress Card Number 00-105388 ISBN 0-7821-2682-0 SYBEX and the SYBEX logo are trademarks of SYBEX Inc. in the USA and other countries. The CD interface was created using Macromedia Director COPYRIGHT 1994 1997-1999 Macromedia Inc. For more information on Macromedia and Macromedia Director visit http . 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 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 .
