18 of 18 people found the following review helpful
Another masterpiece from Thomas Kyte,
This review is from: Effective Oracle by Design (Oracle Press) (Paperback)
The previous work by the same author, "Expert one-on-one: Oracle", got an average of 5/5 stars and more than 50 reviews, which is of course an outstanding result for any book, but especially for books about Oracle, which aren't normally so well-received by the readers community (to say the least). Well, I'm sure that this book is going to get the same success.
Thomas Kyte is well known for being an excellent writer, and in fact the material is presented here in a clear, concise yet complete manner, and it's very easy to follow the discussion and reproduce the examples.
The examples themselves are one of the greatest strengths of this book, because they illustrate, and prove, the topics discussed (and so what is written is *reliable*, which is of course a fundamental property for any technical book, but a quality seldom found in other Oracle tomes). At the same time, the examples (written mostly in SQL and PL/SQL) teach you a lot about how to code appropriately (the Author being a well-known SQL guru), showing e.g. syntactic variations, useful Oracle-supplied packages, new Oracle extensions ... I strongly believe that in order to be a good developer you must be exposed to high quality code, and reading this book is an excellent way to achieve this (well, I learnt more about SQL and PL/SQL from Thomas Kyte's books than from other books dedicated exclusively to SQL and PL/SQL programming).
The book is also magic - it can read your mind. Yes, I had in store a couple of non-trivial questions to be asked on asktom.oracle.com, and I found the answers in the book! Well, this magic property comes straight from the Author's experience in answering thousands of technical question on his aforementioned web site, asked by Oracle developers and DBAs all around the world - so it's not surprising that the book is tuned with what people think, and need to know, about Oracle. I would say that this is a feature present only in Thomas Kyte's books, since there is simply no other place like asktom.
To sum up - this book and "Expert one-on-one: Oracle" are overall the best books about Oracle I've read, and I own more than 15 of them. I can't remember all the times that I've used the latter book in my work as an Oracle specialist, and I've already used a lot of things learnt from this book as well. I absolutely recommend both this and "Expert one-on-one: Oracle".