Customer Reviews

Oracle PL/SQL 101

5 star:		(59)
4 star:		(4)
3 star:		(10)
2 star:		(2)
1 star:		(2)

 

 

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).

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.

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.

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.

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

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...

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.

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.

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!

I bought this book after buying several other books that assume the reader has a basic knowledge of SQL and Oracle, which wasn't me. Christopher starts the reader at the beginning and walks them through the basic fundamentals with patience and even some humor. I think this book is a great starting point for anyone who is database ignorant and doesn't want to stay that way.