Oracle PL - SQL For Dummies (ISBN - 0764599577).pdf - For Dummies E-Book Collection - bugnme5

PL/SQL

FOR

DUMmIES

‰

by Michael Rosenblum and Dr. Paul Dorsey

Oracle ®

PL/SQL

FOR

DUMmIES

‰

by Michael Rosenblum and Dr. Paul Dorsey

Oracle ®

Oracle ® PL/SQL For Dummies ®

Published by

Wiley Publishing, Inc.

111 River Street

Hoboken, NJ 07030-5774

www.wiley.com

Published by Wiley Publishing, Inc., Indianapolis, Indiana

Published simultaneously in Canada

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or

by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permit-

ted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written

permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the

Requests to the Publisher for permission should be addressed to the Legal Department, Wiley Publishing,

Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, (317) 572-3447, fax (317) 572-4355, or online at

http://www.wiley.com/go/permissions .

Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the

Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, and related trade

dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates in the United

States and other countries, and may not be used without written permission. Oracle is a registered trade-

mark of Oracle Corporation. All other trademarks are the property of their respective owners. Wiley

Publishing, Inc., is not associated with any product or vendor mentioned in this book.

LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY : THE PUBLISHER AND THE AUTHOR MAKE NO REP-

RESENTATIONS OR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CON-

TENTS OF THIS WORK AND SPECIFICALLY DISCLAIM ALL WARRANTIES, INCLUDING WITHOUT

LIMITATION WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE. NO WARRANTY MAY BE CRE-

ATED OR EXTENDED BY SALES OR PROMOTIONAL MATERIALS. THE ADVICE AND STRATEGIES CON-

TAINED HEREIN MAY NOT BE SUITABLE FOR EVERY SITUATION. THIS WORK IS SOLD WITH THE

UNDERSTANDING THAT THE PUBLISHER IS NOT ENGAGED IN RENDERING LEGAL, ACCOUNTING, OR

OTHER PROFESSIONAL SERVICES. IF PROFESSIONAL ASSISTANCE IS REQUIRED, THE SERVICES OF A

COMPETENT PROFESSIONAL PERSON SHOULD BE SOUGHT. NEITHER THE PUBLISHER NOR THE

AUTHOR SHALL BE LIABLE FOR DAMAGES ARISING HEREFROM. THE FACT THAT AN ORGANIZATION

OR WEBSITE IS REFERRED TO IN THIS WORK AS A CITATION AND/OR A POTENTIAL SOURCE OF FUR-

THER INFORMATION DOES NOT MEAN THAT THE AUTHOR OR THE PUBLISHER ENDORSES THE INFOR-

MATION THE ORGANIZATION OR WEBSITE MAY PROVIDE OR RECOMMENDATIONS IT MAY MAKE.

FURTHER, READERS SHOULD BE AWARE THAT INTERNET WEBSITES LISTED IN THIS WORK MAY HAVE

CHANGED OR DISAPPEARED BETWEEN WHEN THIS WORK WAS WRITTEN AND WHEN IT IS READ.

For general information on our other products and services, please contact our Customer Care

Department within the U.S. at 800-762-2974, outside the U.S. at 317-572-3993, or fax 317-572-4002.

For technical support, please visit www.wiley.com/techsupport.

Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may

not be available in electronic books.

Library of Congress Control Number: 2006922426

ISBN-13: 978-0-7645-9957-6

ISBN-10: 0-7645-9957-7

Manufactured in the United States of America

10 9 8 7 6 5 4 3 2 1

1O/RX/QV/QW/IN

About the Authors

Michael Rosenblum is originally from Kremenchuk, Ukraine. In 2000, he moved

to the United States, where he lives with his family in Edison, New Jersey. He

works as a Development DBA at Dulcian, Inc. Michael is responsible for system

tuning and application architecture. He also supports Dulcian developers

by writing complex PL/SQL routines and researching new features. He is a

frequent presenter at various regional and national Oracle user group confer-

ences. In his native Ukraine, he received the scholarship of the President of

Ukraine, a Masters Degree in Information Systems, and a Diploma with Honors

from the Kiev National University of Economics, Ukraine.

Dr. Paul Dorsey is the founder and President of Dulcian, Inc. (www.dulcian.

com), an Oracle consulting firm that specializes in business rules-based

Oracle Client-Server and Web custom application development. He is the

chief architect of Dulcian’s Business Rules Information Manager (BRIM ® ) tool.

Paul is the co-author of seven Oracle Press books that have been translated

into nine languages: Oracle JDeveloper 10g Handbook , Oracle9i JDeveloper

Handbook, Oracle JDeveloper 3 Handbook, Oracle Designer Handbook (2

editions), Oracle Developer Forms and Reports: Advanced Techniques and

Development Standards , Oracle8 Design Using UML Object Modeling . In 2003,

he was honored by ODTUG as volunteer of the year, in 2001 by IOUG as vol-

unteer of the year and by Oracle as one of the six initial honorary Oracle 9 i

Certified Masters. Paul is an Oracle Fusion Middleware Regional Director. He

is the President of the New York Oracle Users’ Group and a Contributing

Editor of the International Oracle User Group’s SELECT Journal. He is also

the founder and chairperson of the ODTUG Business Rules Symposium

(now called Best Practices Symposium), currently in its sixth year, and

the J2EE SIG.

Dedications

Dedicated to the memory of my grandfather, Vladimir Zaguskin, who was

always able to give me a simple explanation of not-so-simple things.

— Michael Rosenblum, Edison, NJ, 2006

Dedicated to Dr. Robert Stafford Sterling (my mentor in graduate school and

no dummy) and to his namesake Robert Stefan Dorsey (born December 2005,

who I hope will also not be a dummy).

— Dr. Paul Dorsey, Colonia, NJ, 2006

Oracle PL - SQL For Dummies (ISBN - 0764599577).pdf

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: