| OverviewThis book is the definitive guide to SQL*Plus, Oracle's
interactive query tool. Despite the wide availability and
usage of SQL*Plus, few developers and DBAs know how powerful
it really is. This book introduces SQL*Plus, provides a
syntax quick reference, and describes how to write and
execute script files, generate ad hoc reports, extract data
from the database, query the data dictionary tables, use the
SQL*Plus administrative features (new in Oracle8i), and much
more. Editorial ReviewsProduct DescriptionThis book is the definitive guide to SQL*Plus. If you want to take best advantage of the power and flexibility of this popular Oracle tool, you need this book. SQL*Plus is an interactive query tool that is ubiquitous in the Oracle world. It is present in every Oracle installation and is available to almost every Oracle developer and database administrator. SQL*Plus has been shipped with Oracle since at least version 6. It continues to be supported and enhanced with each new version of Oracle, including Oracle8 and Oracle8i. It is still the only widely available tool for writing SQL scripts. Despite this wide availability and usage, few developers and DBAs know how powerful SQL*Plus really is. This book introduces SQL*Plus, includes a quick reference to all of its syntax options, and, most important, provides chapters that describe, in step-by-step fashion, how to perform all of the tasks that Oracle developers and DBAs want to perform with SQL*Plus -- and maybe some they didn't realize they COULD perform with SQL*Plus. You will learn how to write and execute script files, generate ad hoc reports, extract data from the database, query the data dictionary tables, customize your SQL*Plus environment, and use the SQL*Plus administrative features (new in Oracle8i). This book is an indispensable resource for readers who are new to SQL*Plus, a task-oriented learning tool for those who are already using it, and a quick reference for every user. A table of contents follows: - Preface
- Introduction to SQL*Plus
- Interacting with SQL*Plus
- Generating Reports with SQL*Plus
- Writing SQL*Plus Scripts
- Extracting Data with SQL*Plus
- Exploring Your Database with SQL*Plus
- Advanced Scripting
- Tuning and Timing
- The Product User Profile
- Administration with SQL*Plus
- Customizing Your SQL*Plus Environment
Appendices - A. SQL*Plus Command Reference
- B. Connect Strings and the SQL*Plus Command
|
Top Sellers in This Category | Browse Similar Topics | | Top Level Categories:Sub-Categories: | | | |
Reader Reviews From Amazon (Ranked by 'Helpfulness') Average Customer Rating: based on 18 reviews. SQL* Plus should not be confused with SQL, 2008-10-09 Reviewer rating: 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. | An excellent reference for SQL*Plus, 2007-08-29 Reviewer rating: This book covers the basics of using SQL*Plus for adhoc querying through using it for batch processing. An excellent, extremely readable reference. | Great book ofr those using the SQL Plus command line or GUI tool, 2006-09-20 Reviewer rating: 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.
| the glories of the command line, 2005-01-19 Reviewer rating: 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. | great guide, 2005-01-15 Reviewer rating: 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.
[...] |
Some information above was provided using data from Amazon.com. View at Amazon > |
| |
|
|
