| OverviewThis quick reference is an excellent, portable resource for
every Oracle administrator and developer. It summarizes the
syntax of SQL*Plus, Oracle's ubiquitous interactive query
tool, including new Oracle8i release
8.1.6 features. It also summarizes how to interact with
SQL*Plus and presents the basics of selecting data,
formatting reports, and tuning SQL. Editorial ReviewsProduct DescriptionThis pocket reference provides quick reference information that will help you use SQL*Plus, Oracle's interactive query tool. It summarizes all of the SQL*Plus syntax, including the syntax for new Oracle8 i release 8.1.6 features. SQL*Plus is available at every Oracle site--from the largest data warehouse to the smallest single-user system--and it's a critical tool for virtually every Oracle user. Despite its wide use, few developers and DBAs know how powerful a tool SQL*Plus can be. This book boils down the most vital information from Gennick's best-selling book, Oracle SQL*Plus: The Definitive Guide, into an accessible summary. It concisely describes interacting with SQL*Plus, selecting data, formatting reports with SQL*Plus, and tuning SQL queries. It also contains quick references to the SQL*Plus commands and format elements. This book is an indispensable companion to O'Reilly bestselling book, Oracle SQL*Plus: The Definitive Guide, but it does not replace it; the larger book is truly the definitive guide, suitable for readers at all levels of expertise. The definitive guide describes the many tasks that SQL*Plus can perform, and provides a tutorial on many SQL*Plus topics. But this quick reference is an excellent, portable resource for readers who want a pocket-sized summary of SQL*Plus capabilities and a reminder of how to issue specific commands and formatting options for SQL*Plus. Table of Contents: - Interacting with SQL*Plus
- Selecting Data
- Formatting Reports
- Tuning SQL
- SQL*Plus Format Elements
- SQL*Plus Command Reference
|
Other Readers Also Read | 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 4 reviews. Extremely Useful..., 2006-09-21 Reviewer rating: ...a good combination of size, price, and content. I have the 3rd edition, which includes an 8-page index. I use this as part of teaching a class in Oracle Developer and recommend it for my students. As the other reviewers recommend, write your name in it...the Oreilly pocket references are easy to misplace, and walk off sometimes. There are four blank pages at the end for your own notes. Content is adequate for its purpose -- for extensive details, the Oracle online documentation is available, if slower to access.
Drawbacks? I'd like a larger index, although the current one is useful. A little bit more room throughout the book for notes might be handy, although it would enlarge the book a bit. I think the content is about right, although there will always be things one can't find, and other topics which are never used in this type of book.
And, as with all the Oreilly pocket references I've seen, there is no colophon, so one must go to the original large book to discover that the insect on the front cover is a moving leaf, Phyllium giganteum, a Malaysian creature which grows to about four inches in length...roughly the width of the book! | OK as far as it goes, 2002-12-07 Reviewer rating: For those SQL*Plus keywords it contains, it's good. Very easy to use and helpful. What I'd really like to see is a more comprehensive reference that covers general SQL statements in SQL*Plus, without all the references to the other "flavors" of SQL out there (those weren't in this book, by the way). Exactly the same level of references found in the book now, but much more comprehensive, so I only need the one source for quick 'n' dirty query help. There were many SQL keywords and functions not found either here, or in The Complete SQL (not so complete, after all), making it difficult to move forward without looking elsewhere, like online using the search engine Copernicus. | A great revision guide., 2001-06-25 Reviewer rating: After 7 years solid experience within the ORACLE toolset I find that books like this not only teach us a few new things but are also great revision guides giving new thought to commands, formats,functions etc not used or thought of for some time. In my opinion, even though a small book, it was well worth the money and one that all Oracle users of whatever standard will appreciate. I suggest any purchser write their name in it. | A Real Time Saver, 2000-05-25 Reviewer rating: This pocket reference version has been a real time saver! I really appreciated the concise, clear explanations and examples. Since my co-workers are always walking off with it, I'm having to buy another copy for myself. |
Some information above was provided using data from Amazon.com. View at Amazon > |
| |
|
|
