By Steven Feuerstein
With
Bill Pribyl
September 1997
Pages: 1024
ISBN 10: 1-56592-335-9 |
ISBN 13: 9781565923355
(Average of 6 Customer Reviews)
This book has been updated—the edition you're requesting is OUT OF PRINT. Please visit the catalog page of the latest edition.
The latest edition is also available on Safari Books Online.
The first edition of Oracle PL/SQL Programming quickly became an indispensable reference for PL/SQL developers. The second edition focuses on Oracle8, covering Oracle8 object types, object views, collections, and external procedures, as well as new datatypes and functions and tuning, tracing, and debugging PL/SQL programs. The diskette contains an online Windows-based tool with access to more than 100 files of source code.
Full Description
- 1. Introduction to PL/SQL
- 2. PL/SQL Language Fundamentals
- 3. Effective Coding Style
- 11. Character Functions
- 12. Date Functions
- 13. Numeric, LOB, and Miscellaneous Functions
- 14. Conversion Functions
- 15. Procedures and Functions
- 16. Packages
- 17. Calling Stored PL/SQL Functions from SQL
- 18. Object Types
- 19. Nested Tables and VARRAYs
- 20. Object Views
- 21. External Procedures
- 22. Code Design Tips
- 23. Managing Code in the Database
- 24. Debugging PL/SQL
- 25. Tracing PL/SQL
- 26. Tuning PL/SQL
- A. What's on the Companion Disk?
- B. Calling Stored Procedures from PL/SQL Version 1.1
- C. Built-in Packages
Register your book | Submit Errata | Examples | Surf the PL/SQL Pipeline
Browse within this book
Cover | Table of Contents | Index | Sample Chapter | Colophon
Book details
Second Edition: September 1997
ISBN: 1-56592-335-9
Pages: 1024
Average Customer Reviews: (Based on 6 Reviews)
Featured customer reviews
Oracle PL/SQL Programming, 2nd Edition Review, August 06 2003
Very good, but scant coverage of triggers
Oracle PL/SQL Programming, 2nd Edition Review, November 15 2002
This is a very good book, can also be used as a quick reference.
Oracle PL/SQL Programming, 2nd Edition Review, July 24 2002
Excellent book. Any pl/sql programmer novice or an expert will have something (infact many things) to learn from this book.
Oracle PL/SQL Programming, 2nd Edition Review, June 01 2001
It is an EXCELLENT BOOK!
For anyone trying to learn PL/SQL this book is the best one I've seen!
I recommend it for all developers of PL/SQL applications.
Oracle PL/SQL Programming, 2nd Edition Review, November 22 2000
I am new to Oracle Deveoplement. This book was suggested by one of my co-workers. I have read through a few Oracle books but this one is far superior than anything they have put out. Steve is a great writer and makes a dry subject readable.
Oracle PL/SQL Programming, 2nd Edition Review, October 19 2000
EXCELLENT BOOK! Combined with a PL/SQL Debugger like SQL-Programmer from SFI, this book rocks! Buy it now, you need it.
Oracle PL/SQL Programming, 2nd Edition Review, April 11 2000
Submitted by Kevin M Lanaghan [Respond | View]
The best PL\SQL Book I've seen.
Oracle PL/SQL Programming, 2nd Edition Review, February 16 2000
Submitted by Robin [Respond | View]
I recommend this book highly to every developer I work with, and to every class that I teach. This is the definitive reference for PL/SQL, a dog-eared, constantly used reference for beginners and advanced programmers alike. Several other books try to cover the PL/SQL language, but none have the detail level, comprehensive discussions, and examples of this book.
Normally, I do not buy "2nd" edition releases, since they add little to the original -- this book is an improvement on the first. With the other PL/SQL books from O'Reilly (Programmning with Packages and Oracle Built-ins) this is a complete reference shelf for Oracle developers.
Oracle PL/SQL Programming, 2nd Edition Review, December 03 1999
Submitted by Andrew Smith [Respond | View]
I have been programming in PL/SQL for a number of years now, and still find useful nuggets of information in this book. I recommend it for all developers of PL/SQL applications.
Oracle PL/SQL Programming, 2nd Edition Review, October 04 1999
Submitted by Mike [Respond | View]
Excellent book. It covers both the forest view of PL/SQL and the individual trees. It is very good at organizing and presenting an ad-hoc like language into something that is highly structured and ordered. Also contains very good insight on how to debug/ finetune PL/SQL code. I highly recommend it. ----------
Oracle PL/SQL Programming, 2nd Edition Review, September 30 1999
Submitted by Warren S. Corman [Respond | View]
Although I have had some exposure to the PL/SQL environment I was somewhat overwhelmed until I dove into this book. For anyone trying to learn about the wonderful world of PL/SQL this book is the one!
Oracle PL/SQL Programming, 2nd Edition Review, May 27 1999
Submitted by James Todd [Respond | View]
I'm a fairly new developer of PL/SQL and this book has been an invaluable resource. If you only buy one book, make this the one.
Oracle PL/SQL Programming, 2nd Edition Review, March 18 1999
Submitted by Stephanie Giovannini [Respond | View]
I have to admit that I haven't read the whole book yet. In fact, I've only read the first four chapters. But I'm so impressed with the first four chapters that I figure I've already got my money's worth. I like to read a book cover to cover, every word. Many computer books are written in such a dry, choppy style that this is impossible. This book is a pleasure. I enjoy the humor, the real-life anecdotes and, of course, there's lots of technical stuff. What I like most about the book are the coding standards and "best practices" that appear throughout the book (well, at least the first four chapters). Most of the technical content of this book is contained in the Oracle on-line books--but without this extra insight and commentary the technical details just don't mean much. This book answers the "how do I use this?" and "why do I care?" questions. If you're doing PL/SQL, this is THE book to have.
Media reviews
"The book is suitable for use both as a learning aid and as a reference. It's my first choice for answering PL/SQL questions and certainly much more useful than the Oracle supplied documentation." --Michael Minihane, ACCU, March 2000
"This book is an excellent reference for any serious student of Oracle PL/SQL. Even if you've already read the first edition of Oracle PL/SQL Programming, you'll find an enormous amount of new and revised information in this second edition and on its companion diskette. If you're new to PL/SQL, you'll soon find yourself on the road to mastery." --John J Dyer, Dallas/Ft. Worth UNIX Users Group, June 2001
"With the release of Oracle8 and the introduction of object technology into Oracle, PL/SQL has become an even more critical element of successful Oracle-based applications. The first edition of Steven Feuerstein's brilliantly written book, Oracle PL/SQL Programming, has become the 'PL/SQL bible' for developers around the world. This second edition is even better! Steven and Bill cover all the new features of PL/SQL8 -- especially the Oracle8 objects option -- and provide even more real-world examples. I recommend this book whole-heartedly." --Ken Jacobs, Vice-President, Product Strategy, Server Technologies, Oracle Corporation
"For those of us who have committed our lives to solving real-world problems within our industry of choice, Steven Feuerstein's book has proven to be an excellent technical manual by which we can begin -- or continue -- to use PL/SQL and extend our creative abilities. Small IS departments do not have the resources to spend endless hours searching for solutions to their problems. Oracle PL/SQL Programming provides us with an accessible source of technical expertise, good programming practices, and in-depth knowledge of the nuances of PL/SQL. Strong technical content packaged with a touch of humor and philosophy makes the book a must for PL/SQL developers." --Becky Olsen, Information Systems, Office Equipment Wholesale, Inc.
These quotes are from the first edition:
"This book is teeming with tips, techniques, tested examples, and tools you can use to pump up your productivity and the quality of your PL/SQL code. Oracle users have patiently awaited the arrival of a true resource for 'real world' PL/SQL programming; this book delivers." --Steve Muench, Senior Product Manager, Oracle Tools Development, Oracle Corporation, and coauthor of Oracle Forms Developer's Companion
"ORACLE PL/SQL Programming was written by someone with vast PL/SQL experience in the Oracle workplace... The book is a must for any PL/SQL programmer who wants significantly more than what is in the manuals. It has already taken pride of place on my bookshelf." -- Mark Gurry, coauthor of ORACLE Performance Tuning
"Steven's book introduces the users of Oracle's products to PL/SQL in a friendly and effective manner." -- Sunil Bhargava, Development Manager, PL/SQL, Server Technologies, Oracle Corporation
"PL/SQL is the key to current and future development using Oracle and its products. This book takes you into the PL/SQL psyche of a recognized industry expert...the journey will be very enlightening." --Michael Abbey, coauthor of ORACLE Tuning
"Steve's book is a must have for any Oracle programmer...It will become a part of every programmer's daily diet along with Coke Classic and chocolate chip cookies. --Tammy Lowe, Assistant MIS Manager, Burlington Coat Factory
"In this book Steven Feuerstein demystifies, defines, and delivers. PL/SQL is destined to assume a key role in gluing together the soon-to-arrive objects of Oracle8..Read this key book to understand, appreciate, and implement." --Dale Lowery, Senior Principal, CASEtech, Inc.
"The whole book is just full of good advice on the PL/SQL programming language...It is a whole reference library in one book." --Jihad Feghali, www3.sympatico.ca/cypher
