 |
|
Title: Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
ISBN: 0596007469
Author:
Jonathan Gennick
Publicate Date: 2004-11-16
Publish: 2004-11-16
List Price: $39.95
Average Customer Rating: 4.0
Format: Paperback
 |
|
|
|
|
Amazon Lowest New Price: $14.00
Amazon Lowest Used Price: $14.00
Amazon Merchant Price: $26.37
|
|
|
|
|
|
|
|
|
|
|
| Customer Review: |
|
1: SQL* Plus should not be confused with SQL
I had bought this text a few years ago to learn SQL. Little did I know then that SQL Plus is a "sand box" that contains SQL. Needless to say that I was disappointed and had to shelf this book.
However, after reading an introductory book on SQL and writing lots of code, I revisited this text and found it to be quite useful.
In summary, this should not be used by SQL novices. This book teaches "SQL Plus" and not SQL per se. Once, you have learnt the language, this book will come handy to
1, execute sql queries (by scripting)
2, format the report
3, set up the development environment
4, to discover the database
5, and much much more
One reason for not assigning five stars is the lack of ease when it comes to downloading the sample code and installing it on my machine.
|
2: An excellent reference for SQL*Plus
This book covers the basics of using SQL*Plus for adhoc querying through using it for batch processing. An excellent, extremely readable reference.
|
3: Great book ofr those using the SQL Plus command line or GUI tool
Oracle SQL Plus: The Defnitive Guide
Jonthan Gennick
1-56592-578-5
This book is great for those using the SQL Plus tool. I use SQL Plus for Oracle 8 and 9. This book covers up to 8i but I have not had any trouble using the commands in 9i. I have not tried the commands listed on 10g yet. The book is easy to use since the topics are split into reasonable chapters and the font is large enough to read with the book beside the keyboard. I also like the chapters that list commonly used items in tables. One example would be the chapter listing the user_ and all_ views. The chapter covering the SET command is one I use frequently. This book is fairly specific to the usage of SQL Plus itself and does not delve too deeply into the inner workings of the Oracle database, but it does have examples in SQL query language and PL/SQL stored procedures. If one is looking for a book on SQL itself, I recommend another title. If one needs a book on SQL Plus, get this one.
|
4: the glories of the command line
The glories of the command line. SQLPlus [I am not going to write that irritating asterix] is an acknowledgment of the reality that for many large computer programs and operating systems, a command line utility is vital. The book explains this for the specific instance of hooking to Oracle's database. It is meant as a definitive reference. Showing every command, often accompanied by example code.
For an Oracle DBA, a good acquaintance with SQLPlus is probably mandatory. From the book, you can see how to quickly interrogate the database and get results in various useful paginated formats. Plus, and vitally, you can see how to build script files that can be run, where these files encode your experience in amassing customised sequences of commands specific to your needs. Exactly analogous to batch files in most operating systems, and just as useful.
Along those lines, SQLPlus is conceptually not that hard. When using Oracle, it is often far more important, and harder, to design optimal tables for a given problem.
|
5: great guide
I have found this book to be a really great guide that is easy to follow. The author provides a gentle, but thorough introduction to topics like creating reports, writing scripts, customization etc. He offers methodologies and alternatives beyond the syntax that you can find in the manual. For example, he presents and evaluates six ways one can achieve some kind of if-then-else flow control in SQL*Plus.
[...]
|
|
|
|
|
