Your rating(Clear)Rate this item


There was a problem filtering reviews right now. Please try again later.

13 of 13 people found the following review helpful
on January 22, 2001
I enjoyed reading the PL/SQL 101 thoroughly, I have finished one complete reading of the book and now I am going through it the second time. I decided to buy this book after getting totally frustrated of asking others to help me with Oracle. I asked our dedicated Oracle DBA to show me how to create a simple table, it took me more than three months to chase her and could not get any result and one day I found out she was gone, then I bought the PL/SQL 101 and in chapter one the author explains the most basic way to get going.
Remember this is a 101 book, if you already know quite a bit of SQL, then this book might bore you. The title is perfect, and its readers should of that level.
I would like to thank the author for getting me hooked to Oracle and PL/SQL the easy way (Ofcourse there is no easy way, you still have to read and reread the book several times, and practice and practice).
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
10 of 10 people found the following review helpful
on October 11, 2001
It's right there on the cover: Oracle PL/SQL. And that's what this book explains, from the very beginning. You can't learn PL/SQL without knowing SQL, so a substantial portion of the book covers SQL techniques that are necessary to write good PL/SQL code.
Each chapter has dozens of exercises, so by the end of the book you have worked through hundreds of experiments, samples, and exercises. It's all hands-on.
The sections on PL/SQL programming cover functions, procedures, packages, and triggers...all the tools you need to make Oracle dance to your tune.
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
9 of 9 people found the following review helpful
This is one of the best books that I've bought recently. I've been a programmer for 4 years, but I just recently started working with relational databases, specifically Oracle. This book is clear, concise, and very accessible. The writing style is very engaging, too. The author manages to present the material in a way that keeps your interest without sacraficing quality. Consequently, the book is fast to read, but of great value.
The chapter on using SQL*Plus is of great value. It helped me to more effective look at what is in our databases to get a feel for the results from the programs that I was testing.
After reading this book I felt like the author gave a solid overview of the PL/SQL language without being overly rigorous. If you are looking for an academic treatment with lots of theory, this is not the place. Those books are very import to broaden your understanding, but this book bridges the gap to make the advance texts accessible.
This is the place for Oracle beginners to get their hands dirty. There are plenty of examples that run throughout the book to demonstrate the concepts. As you work with PL/SQL and SQL*Plus, you will find yourself referring back to this book often as you come up to speed. It is definitely worth the money and the time.
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
9 of 9 people found the following review helpful
on March 23, 2001
This is the best introduction I've seen to PL/SQL programming. The book takes its "101" moniker seriously - it doesn't assume anything, but explains fully everything you need to know to learn how to program in PL/SQL. Since PL/SQL relies on a fundamental knowledge of SQL, the book invests a good deal of time covering the database concepts, SQL concepts, and SQL commands necessary to write good PL/SQL code. Bravo! That's why this deserves to have "101" in its title.
Those who already have some SQL knowledge would do well to read over these SQL chapters anyway - the book really pulls things together, filling in the gaps that often come with self-teaching. It also has great examples for some of the more obscure features of SQL and PL/SQL.
Perhaps the author can be persuaded to do a "PL/SQL 201" book - I would buy it.
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
8 of 8 people found the following review helpful
on January 18, 2001
JOB WELL DONE Mr. Christopher Allen!! This is the MOST helpful book to me on Oracle Pl/ SQL that I have ever seen in Silicon Valley area! I have spent many months browsing and buying books on Oracle from almost all bookstores in the bay area, but this book is the only one that helped me. I am very thankful for that. Abdullahi Koshin from Oakland, CA
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
10 of 11 people found the following review helpful
on September 27, 2001
Since I've been working on Oracle for a couple of years, I was not really expecting too much from this book when I got it from the public library. However, when I read it last night, it refreshed a lot of concepts for me and taught me some *very* useful tricks I never knew before.
I agree that this book is very useful for beginners since it explains everything crystal clear. e.g. the way it explained To_Date and To_Char function is a lot better than all the oracle books I've read, including Oracle 8i: The complete reference, which is one of the all time Oracle best sellers.
If you like to go one step further on PL/SQL after read this book, I would suggest Advanced Oracle PL/SQL programming by Scott Urman. Although it has 'Advanced' in its title, that book is actually quite beginner friendly. And Scott has long been one of my most favorite writers. You won't waste your money on that one...
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
7 of 7 people found the following review helpful
on May 7, 2001
Great book for new Oracle DBAs learning how to write SQL statements and queries. I worked through the book chapter by chapter. The first two sections ("Database Basics" and "Advanced SQL") are very strong, with clear instructions and a logical progress from simple to more complex steps. However, the third section, "Creating Programs using PL/SQL", falls short. Here the material gets too complex too quickly.
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
6 of 6 people found the following review helpful
on October 19, 2001
This book takes away any questions about PL/SQL...I had taken a class where the instuctor left me thoroughly lost. After one night with this book, I was completely at ease. There are various exercises in each chapter, which enhance your understanding of what is being explained. The author gives precise short explanations which clearly delineate the principles you are expecting to master. The best way to learn is to use the examples with data of your own as opposed to "widgets". By replacing the data, and saving your scripts, you can review and it is always fresh in your mind. Great beginner book!
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
6 of 6 people found the following review helpful
on November 11, 2001
I am taking a SQL course in college in order to be able to start
a new career when I leave my present career. I knew absolutely
nothing about SQL when I started the class. My instructor referred me to this book "PLSQL 101" to use besides my classbook.
This book explains things much better than the book supplied by
Oracle! It's very easy to read and comprehend. Very nice. With this book I have learned and absorbed a lot of information to
help me along to a new career. Without this book as a sidekick to my classbook, I probably would have stopped.
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
11 of 13 people found the following review helpful
on November 16, 2001
For beginners to Oracle like myself, I cannot stress how useful this book is. Don't pay thousands for a course in Oracle, or even begin a course at a community college, until you go through this book first. (This would be the ideal CC book). Allen's ability to "teach" SQL and PL/SQL in a logical and well thought out progression is to be commended! This book is written for the beginner and will give you a solid foundation in the basics of SQL and PL/SQL, so you can make the most of your time in the expensive classes later.
If you have more than a year's worth of experience in SQL or PL/SQL, you may do better to just get the Sybex book to prepare for the exam since it is more comprehensive and comes with the software and test question. However, Allen still does a better job of writing and presenting the material without dumbing it down. If you're new, like me, you'll wish you read this book and gone through his examples (you can download his code from osborne.com), before taking any courses. You will be able to keep pace with the instructor better and ask more intelligent questions. This book will not cover everything that may be on the exam, but it will help you make better use of other more comprehensive books. Believe me.
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Send us feedback

How can we make Amazon Customer Reviews better for you?
Let us know here.