Programming Books C Java PHP Python Learn more Browse Programming Books
Sell yours for a Gift Card
We'll buy it for $1.50
Learn More
Trade in now
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide) Paperback – October 4, 2009

ISBN-13: 978-0596514464 ISBN-10: 0596514468 Edition: Fifth Edition

12 New from $64.28 25 Used from $11.29
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$64.28 $11.29

There is a newer edition of this item:

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Spring Books
The Big Books of Spring
See our editors' picks for the books you'll want to read this season, from blockbusters and biographies to new fiction and children's books.
NO_CONTENT_IN_FEATURE

Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

Product Details

  • Series: Animal Guide
  • Paperback: 1232 pages
  • Publisher: O'Reilly Media; Fifth Edition edition (October 4, 2009)
  • Language: English
  • ISBN-10: 0596514468
  • ISBN-13: 978-0596514464
  • Product Dimensions: 7 x 2.2 x 9.2 inches
  • Shipping Weight: 3.8 pounds
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (30 customer reviews)
  • Amazon Best Sellers Rank: #278,459 in Books (See Top 100 in Books)

Editorial Reviews

Book Description

Covers Versions Through Oracle Database 11g Release 2

About the Author

Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language. He is the author or coauthor of Oracle PL/SQL Programming, Oracle PL/SQL Best Practices, Oracle PL/SQL Developer's Workbook, Oracle Built-in Packages, Advanced Oracle PL/SQL Programming with Packages, and several pocket reference books (all from O'Reilly & Associates). Steven is a Senior Technology Advisor with Quest Software, has been developing software since 1980, and worked for Oracle Corporation from 1987 to 1992.

Bill Pribyl is the primary author of Learning Oracle PL/SQL and the coauthor of Oracle PL/SQL Programming and its companion pocket reference, all from O'Reilly Media. He is oddly proud of having used PL/SQL to write TCP/IP networking clients, tnsping callouts, near-realtime commodity price loaders, and transcendental functions. Bill, who holds a degree in physics from Rice University, is the former editor of the IOUG technical journal (Select) and former president of the South Central Oracle Users Group. At home with his family in Houston, Texas, Bill's current nonbillable titles include Webmaster for his neighborhood civic club, "IT Guy" for his son's Boy Scout troop, and Eucharistic Adoration Coordinator for his church. Visit Bill's firm at http://www.datacraft.com.


Important Information

Ingredients
Example Ingredients

Directions
Example Directions

Customer Reviews

4.6 out of 5 stars
5 star
21
4 star
8
3 star
0
2 star
1
1 star
0
See all 30 customer reviews
It's written by Pl/Sql guru Steven Feuerstein.
Rony
Purchased this book for class and was pleasantly surprised at how easy it was to read.
James T. Ashford
The examples are very clear and easy to understand.
Alberto N. Noronha

Most Helpful Customer Reviews

17 of 18 people found the following review helpful By Mr. Mark S. Jones on October 26, 2009
Format: Paperback Verified Purchase
There are always 2-3 books every developer has in their area of expertise and if you're using PL/SQL, the Feuerstein book is one of them.

I'm not sure how much someone can get out of it if they never did work coding before and you're trying to learn it but I can think of many many times I needed an example for a specific problem and the book had a great example of how to do it.

Also I warn people to be careful because especially for the later chapters, they evolve to the answer to the problem and the cognitive method for this book is to follow along to the end to see how it got there - I think to some of the reviewers this is verbose but this really sinks the PL/SQL concept into your brain effectively and in my experience it's clearly worthwhile. I'm amazed (as always) how clear the evolution is if you take the time to follow it.

I might also add if you're not doing PL/SQL for work but trying to learn it, the evolution might not make sense it's very obvious to me the author has hard core real experience to approach the topics the way he does it.

For people in the field, I'd even say if you're a brand new developer on a job or programmed in something else and are approaching PL/SQL for the first time, the examples are more than clear enough and the opening chapters cover relatively universal and simple concepts so I believe the book is extremely beneficial for beginners as well as very advanced PL/SQL developers.
3 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
6 of 6 people found the following review helpful By Alberto N. Noronha on February 15, 2010
Format: Paperback Verified Purchase
If you're looking for a book that can be your reference for every doubt you may have in PL/SQL programming, its syntax and constructions, that's the book for you. The examples are very clear and easy to understand. The author uses examples in both ways, before applying a certain functionality and after applying it, which makes comprehension much better. In case I had no PL/SQL book so far, I wouldn't waste my time buying other ones. There is only one cons: the size and weight of this book. It's not something you'll like to carry in your backpack everyday, but keeping in your shelf as a handy reference book.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 6 people found the following review helpful By Amazon Customer on September 25, 2010
Format: Paperback Verified Purchase
With the exception of the first edition, I have purchase all others that Steve has published. Not bad for a self-confessed newby programmer. Just kidding. It is the one book I would want if I were stuck on a desert island. Of course, for a lack of firewood, well sorry Steve; we have to do what we have to do.

I have been a professional PL/SQL programmer since the mid-eighties. On one job, an earlier edition made me a hero. Today, I program for the US Army Aeromedical establishment, so I serve the heros and proud of it. My one and only PL/SQL book I keep at my side is this book. Steve, keep up the good work. It would not hurt my feelings if you wrote a book on the practical side of PL/SQL for DBAs as I find myself involved in DDL work 1/3 of my project life cycle so scripts and hints would always be welcomed. I do have a copy of Donald Burleson's DBA Scripts affectionately known as Code Depot and I take nothing away from Donald, but I enjoy the format used in the Oracle PL/SQL; it is the best even though it is just my opinion.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By JohnD on August 10, 2013
Format: Paperback Verified Purchase
Excellent book, but with one comment: it implicitly assumes you know Oracle's version of SQL. The discussions and examples are excellent when covering details about the PL/SQL programming language (which, in fairness, is what the book is about). However, since I didn't understand some of the references to the basic SQL language (my experience was with T-SQL), I was left confused in places. The book is probably worth 5 stars if you do understand Oracle SQL already and just want to learn more about PL/SQL. I would give it 5 stars for everyone if the next edition added just a few lines of explanation whenever it currently assume you understand the details about the underlying SQL. Nevertheless, still an excellent book and one I recommend.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By Matt Gross on November 23, 2013
Format: Kindle Edition Verified Purchase
The formatting in this book on the Kindle Fire HD is terrible. The table of contents is hard to read, and spans many pages on the Kindle. The author of this book should do a better job auditing the user experience before publishing the digital format. I am disappointed with this version of the book and will be calling Amazon for a return/refund.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback Verified Purchase
It has been a decade since I did any detailed work with Oracle and my references were very faded. Once the book arrived I was amazed to find out just how thorough it was. "Oracle PL/SQL Programming" not only covered the usual design of databases, tables, indexes, stored procedures, cursors, and data types but also covered best practices and gave away some typical 'gotchas' that have plagued programmers for years. This book is not only far better at explaining the nature of PL/SQL design than my former references, but it goes into better depth in each area it covers as well. Check out the Array data category, this one alone can save you days of table design for modern program inerfaces. And SQL Server is stuck in the SQL 89 standard and has no way to match modern database data type.

At 1500 pages you may think that every possible area of Oracle would be covered. But I did find out that there is still two areas of Oracle programming that this book makes no attempt to address and they are OCI and OCCI. These are the high performance program interfaces to the Oracle database that actually allow faster database interfacing than SQL Server. This astounding result is achieved by using either the C interface( OCI ) or the C++ interface ( OCCI ). The author is right not to include these areas or the book would have expanded to 2500 pages! I have spent two weeks already pulling information off the internet on OCCI( forget finding a book on it ) and I'm not even half way done designing a Windows service to use OCCI across the network.

So, now you know what to get. If you intend to spend more than a few weeks designing, updating or interfacing to a post 2010 Oracle databasse, GET THIS BOOK and break into Oracle programming!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews


More About the Author

Steven Feuerstein is considered to be one of the world's leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all published by O'Reilly Media). Steven has been developing software since 1980, spent five years with Oracle (1987-1992), and has served as PL/SQL Evangelist for Quest Software since January 2001. He is an Oracle ACE Director and writes regularly for Oracle Magazine, which named him the PL/SQL Developer of the Year in both 2002 and 2006. He is also the first recipient of ODTUG's Lifetime Achievement Award (2009). Since 2005 he has focused his attention on improving the testing of PL/SQL programs, primarily through the creation of Quest Code Tester for Oracle, which automates PL/SQL code testing. Steven's online PL/SQL cyberhome is located at www.ToadWorld.com/SF; but you can also find out more about Steven at http://www.StevenFeuerstein.com.

What Other Items Do Customers Buy After Viewing This Item?