Oracle PL/SQL Programming

Oracle PL/SQL Programming

by StevenFeuerstein (Author), Bill Pribyl (Author)


This text has been thoroughly revised and updated to include the latest Oracle releases - Oracle8i and Oracle9i - the Internet databases that communicate with other technologies, such as Java, to run powerful e-commerce applications. Oracle has made substantial changes to the PL/SQL language, and developers who want to take full advantage of its power should find the information they need in this book. This new edition of the book includes all PL/S QL language features up to and including Oracle 9i Release 2 (9.2). Regardless of the version you are using, from Oracle 7.3.4 to Oracle 9i, this book will answer your questions. In addition, Oracle PL/SQL Programming now contains much-requested new chapters on Oracle triggers, the internal architecture of PL/SQL in the Oracle database, and the use of PL/SQL with Java. The authors have carefully constructed each chapter of this edition with three objectives: to help you take full advantage of PL/SQL, learn to use PL/SQL to solve your problems, and to write efficient, maintainable code. Beginning with an introduction to PL/SQL programming and continuing through advanced PL/SQL topics, the book covers: PL/SQL language fundamentals; PL/SQL program structure; types of program data; the connection of PL/SQL to the underlying database; application construction; managing your PL/SQL code base; if you're new to PL/SQL, reading this book will improve your skills and help your understanding. If you're already a proficient PL/SQL programmer, you'll be able to extract particular techniques for immediate application. Whether you use this book as a teaching guide or reference, you'll find it will have a significant impact on your ability to use PL/SQL more effectively.


Save:$41.48 (93%)


2 in stock

More Information

Format: Paperback
Pages: 1018
Edition: 3
Publisher: O'Reilly Media
Published: 23 Sep 2002

ISBN 10: 0596003811
ISBN 13: 9780596003814

Author Bio
Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language. He is also the author of the sequel to Oracle PL/SQL Programming, Advanced Oracle PL/SQL Programming with Packages (O'Reilly & Associates, 1996), and Oracle Built-in Packages (O'Reilly & Associates, 1998). Steven has been developing software since 1980 and worked for Oracle Corporation from 1987 to 1992. He is a partner with RevealNet, Inc. ( and is the chief architect of the RevealNet products, PL/SQL Knowledge Base and PL/Vision (a code library of prebuilt PL/SQL packages that accelerates PL/SQL-based application development). Steven also sysops RevealNet's PL/SQL Pipeline, an online community for PL/SQL developers ( He can be reached through email at Steven is also president of PL/Solutions, which offers training and consulting on both PL/Vision and PL/SQL ( Finally (on the Oracle side of Steven's life), he serves as codirector of the Oracle Practice at SSC, a systems management consulting firm based in Chicago ( Steven shares his Rogers Park, Chicago, Georgian with his wife Veva, his youngest son Eli, two cats (Sister Itsacat and Moshe Jacobawitz), and Mercury (the Congo Red African Gray parrot). His older son, Chris, is busy making music and creating art nearby. Steven is a member of the Board of Directors of the Crossroads Fund, which provides grants to organizations in Chicago working for social change. Bill Pribyl, author, teacher, and software consultant, is coauthor of the best-selling Oracle PL/SQL Programming and its companion pocket reference, both published by O'Reilly & Associates. An Oracle user for 15 years, Bill has consulted on many aspects of using Oracle products. He recently spearheaded, a Web-based repository where developers can share open source PL/SQL. At home in Houston, Bill volunteers with a Christian organization teaching computer skills to low-income clients, and he says his next project will be persuading fellow database technologists to contemplate the ethical and moral implications of all their work. Visit Bill at