Customer Reviews

Pete Cassidy's Cookbook for Oracle SQL*Plus

5 star:		(9)
4 star:		(0)
3 star:		(0)
2 star:		(0)
1 star:		(0)

 

 

If you're thinking about buying this book, you might want to know what's in it. This book is about 250 pages, and each page contains one example of something you can do in SQL*Plus. There is only a small amount of explanation about what the example does, often only a sentence.

The examples are all things that people who work with Oracle might want to do from time to time, but might not know how to accomplish.

So this book will be most appreciated by someone who already has a certain amount of experience with Oracle. If you use the Beginner, Intermediate, Advanced categories of Oracle knowledge, I'd say the people who would most like this book are those who are at least half way through the Beginner stage, up to people who are just entering the Advanced stage.

If you are a rank beginner to Oracle, you will not understand many of the examples. For instance, the page for Using Array Processing merely demonstrates, for SQL*Plus, the command SHOW ARRAYSIZE. That's all! If you already know what array processing is, and just want to know how to determine what arraysize is currently set to, then the command shown will be helpful. But if you don't know about array processing in SQL*Plus, what's the use of seeing this page?

Most of the book is like this. In fact, imagine for a minute there was a SQL*Plus expert in your office, and every day several people came over and asked, "I'm stuck on one point and was wondering if you could tell me how to...." Now suppose that expert typed a few commands, showing the person how to do the specific thing they were asking, and then saved what he typed. After he had 250 commonly asked questions, he put what he typed in a book, one per page, adding a title to the page and maybe one sentence of explanation.

That's exactly what this book is. It assumes you already have a certain level of knowledge about Oracle in general, and about SQL*Plus in particular. If that's true for you, then great, you'll appreciate these 250 techniques and tips, because they're things you'll probably want to know how to do. But even if you have a year or two of experience with Oracle, you'll probably find you have to look in the Oracle documentation for a fuller explanation to make sense of some of the things in this book.

That's not necessarily a bad thing. It could be a great way to learn. In fact, if you're a rank beginner, you might still like this book if you're the type of person who likes to dive right in and start typing commands to see what they do. Just be aware that you better have the Oracle documentation CD-ROM handy, because virtually none of the great commands and techniques shown in this book are accompanied by any explanation other than the occasional sentence.

If you are the type who likes to read complete explanations, I'd suggest the SQL*Plus book by Gennick. Whatever, this is a good book, it's just that you'll probably need some background before you can really appreciate and make use of it.

This is a excellent book to learn SQL*Plus or to refine your knowledge. I teach several Oracle classes and I recommend this book to students to clarify important concepts. I would highly recommend this book to those that want to expand their knowledge of SQL*Plus.

Got to be the worst cover ever - even though its his daughters idea sorry! I cover it in brown paper at client sites. Its an excellent dip in and read and contains solutions to many commonly experienced problems both for experience and neophytes alike. For me its a MUST HAVE. I can give it to very inexperiened developers rather than explain for the n'th time how to define your editor in SQLPLUS for example.

Howard Latham Editor Oracle Scene.

I'm just getting into SQL scripting, and have found this book to be practical and very useful. Explanations are well-written and concise, with lots of great examples.

Excellent information presented. I've used this book countless times in real world scenarios. In fact the original book I purchased was so well liked by others it went on a "hiatus" and I had to purchase another. I look forward to acquiring the Oracle 8 Tuning guide.

I have used Pete's book for over a year now, and I find it a strong sourcebook. Unlike many of my other source books, this book gives the actual text of the commands that are necessary to accomplish the job.
I place this text at the top of the Oracle books I have.

Pete's cookbook is an excellent resource which I highly recommend. What makes the book 'work' for me is there are many superb examples of both simple and complex practical SQL and SQL*PLUS problems and solutions. In addition to being humorous, it is easy to follow and to understand. When I am trying to get a task done by a certain deadline, I don't have time to wade through miles of explanation. I need the answer YESTERDAY and the SQL COOKBOOK does that for me. I also teach Oracle courses and my students really love the book too.

Very well written book with lots of real world examples

It contains all that you need and nothing you don't for using SQL plus utility effectively. It also has lot of examples.