Learning Oracle PL/SQL Paperback – Dec 1 2001
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
Getting the download link through email is temporarily not available. Please check back later.
To get the free app, enter your mobile phone number.
No doubt that reading this book and applying its principles will make the reader a better PL/SQL programmer. -- Ileana Bâlcu, New York Oracle Users Group, March 2002
From the Publisher
Designed for both new programmers and those experienced in other languages, this book presents the core features of Oracle's PL/SQL language in an easy-to-read format. Learning Oracle PL/SQL will bring programmers up to
speed on the most important aspects of PL/SQL, including web and Internet programming. Updated through Oracle9i, includes sample programs downloadable from examples.
Top Customer Reviews
Another very useful thing the author does is list common and not-as-common mistakes that a programmer may make (which may not always result in errors or exceptions), hence possibly saving you the trouble of hours of debugging.
The only problem I've had with it is that he doesn't treat foreign keys as constraints. One of his sample column declarations is: "isbn VARCHAR2(100) FOREIGN KEY REFERENCES books (isbn)", but I kept getting an error until I changed it to: "isbn VARCHAR2(100), FOREIGN KEY (isbn) REFERENCES books (isbn)". I am not sure if this is a peculiarity of my installation (running Oracle 9i), but a check online reveals that many people also consider foreign keys a constraint.
Except for that problem, I would have given this book 5 stars.
The organization is great and the writing is crystal clear. It doesn't just cover syntax. It also explains when and why you'd want to use various PL/SQL features.
If you're a radical C++ coding genius, maybe you want one of the other O'Reilly books on PL/SQL. On the other hand, if you've tried some other books that deal with PL/SQL and found they didn't provide the background, explanations and programming strategies you need, try this book. The authors are talented PL/SQL experts, and their presentation of the subject is great.
This book is not a slap-dash effort to write a quick book. It's a solid, quality book. If you have some exposure to Oracle but have never developed PL/SQL skills, you'll like this book.
You'll learn about coding anonymous blocks, stored procedures, functions, and packages. You will learn how to write and use cursors, how to organize code into packages, Oracle security basics, Oracle built in packages, and error handling. The book also covers some basics of using SQL*Plus, to make your life a little easier.
If you need a relatively small (less than 400 pages) introduction to Oracle PL/SQL, then this is definitely a book you will want to pick up. If you need more in-depth information after reading this book, pick up the authors' other book Oracle PL/SQL.
I recommend this book. As a developer having knowledge resource information is critical.
If you are a programer/engineer/dba looking to "learn Oracle PL/SQL", interested in practical applications of such fundamental topics as constraints, foreign keys, indexes, joins, cursors, views, triggers, corelated subqueries and the like, look elsewhere. Don't take my word for it--take a peek at the index or table of contents and you'll see that the focus of this book has very little to do with PL/SQL.
Most recent customer reviews
I use a self-taught approach to learn new things like most people. And, like most people, I get frustrated with the lengthy superfluous nature of how-to books which throw... Read morePublished on April 22 2003
It goes straight to the point, to learn and use Oracle's PL/SQL in an effective way. This book is a gem!!Published on Oct. 8 2002 by Adam Rivers
This 300+ page book is a gem. It goes straight to the point about how to use PL/SQL. With clear examples and tips to make you a better developer.Published on Oct. 8 2002 by Adam Rivers
As a Oracle DBA I needed an intoduction to PL/SQL.
This is exactly the kind of book I was looking for.
Excellent style, I enjoyed the time I spent reading this book. Read more
I'm a programmer familiar with SQL and needing to learn PL/SQL to use with SQL Navigator and SQL*Plus. Read morePublished on May 2 2002
Look for similar items by category
- Books > Computers & Technology > Databases > Database Management Systems
- Books > Computers & Technology > Databases > Oracle > PL & SQL
- Books > Computers & Technology > Programming > Languages & Tools
- Books > Computers & Technology > Software
- Books > Computers & Technology > Web Development > Programming > SQL
- Books > Education & Reference
- Books > Professional & Technical > Professional Science > Mathematics
- Books > Textbooks > Computer Science & Information Systems > Database Storage & Design
- Books > Textbooks > Computer Science & Information Systems > Programming Languages