文档介绍：cyan yelloW
MAGENTA BLACK
panTONE 123 C
Books for professionals by professionals® The EXPERT’s VOIce® in Oracle
Companion
eBook Available
Beginning PL/SQL: From Novice to Professional
Beginning
Dear Reader,
The book you’re holding is a tutorial (not a reference) on Oracle’s PL/SQL that fol-
lows the 80/20 rule, starting you out on the 80% of the SQL and PL/SQL that is
used in almost every stored procedure. It also covers how to debug, profile, test,
and document your PL/SQL programs. And most uniquely, it shows you how to
develop both relational and object-relational PL/SQL solutions, while relating
sound, hard-earned advice.
Author of Beginning
I wrote this book because I’m tired of reading the regurgitated tomes of
Java Programming with reference found on bookshelves. I figure you’re tired of that, too. I want a book
Oracle JDBC
that tells me what I need to do and how I need to do it, and not a whole lot
JDBC Pocket Reference more. So I assume that’s what you want as well. PL/SQL
Oracle Application Server I also assume you already know how to program, because it’s unlikely that
10g Essentials anyone would learn PL/SQL as a first programming language. And I assume
you know SQL. So I cover PL/SQL quickly, at a pace that won’t waste your time.
Be prepared to learn fast! By the time you’re finished reading this book, you’ll
have consumed too much caffeine and groaned one too many times at my idea
of humor, all while learning how to write stored functions, procedures, and
packages, using singletons and cursors. You’ll know how to debug, profile, test,
and document your PL/SQL—these are the skills that make you a professional
PL/SQL programmer. PL/SQL
Applications that use PL/SQL are faster. They better leverage the power of
SQL. And using PL/SQL in an Oracle database allows you to model the real world.
The more closely you model the real world, the more closely your applications
wi