Cooking with Oracle Cookbook
Rating:
5 / 5
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.
Developers will learn/produce alot by using this cookbook
Rating:
5 / 5
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.
What, specifically, is in this book?
Rating:
5 / 5
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.
|