Most Oracle DBAs spend the majority of their time each day doing pretty much the same things they do every other day, which is great, since they don't have any problem remembering the syntax and commands they want to use. But for the rest of their time, they're doing something they may only do once every few months -- and that's the time they need help. Not from a huge instructional manual, or awkward online documentation -- they have plenty of both and will use them when they need to. What DBA's really need is a simple, small, single volume quick reference that will remind them of the syntax and options of a command they rarely use, or give them a quick reminder of the available views and tables that make up a DBAs life.
Book Description
Editorial Reviews
From the Back Cover
- The Oracle SQL every DBA needs—fast and easy!
- Covers all the core day-to-day tasks DBAs are responsible for
- Quick access to SQL commands, operators, functions, data dictionary views, and more
- Includes dozens of easy-to-understand syntax diagrams
The fast, practical Oracle SQL reference for every Oracle DBA!
If you're a working Oracle DBA, here's the Oracle SQL reference you've been searching for—simple, straightforward, and incredibly easy to use! There's no faster way to discover the exact syntax you need...refresh your memory about that option you haven't used lately...find the name of that view you know exists...start using that new Oracle 9i feature you haven't tried yet. Keep it by your desk, near your server...wherever you need fast, reliable answers right this minute!- Covers Oracle SQL through Oracle9i Release 2
- Clear, well-organized tables of operators, functions, format models, privileges, and reserved words
- Complete command reference: syntax and options for every Oracle SQL command
- Standard "railroad" syntax diagrams make it easy to write correct syntax
- Handy listings of data dictionary views and dynamic performance tables
About the Author
CHARLIE RUSSEL has extensive system administration and Oracle DBA experience in both Windows and UNIX environments. His books include Microsoft Windows 2000 Server Administrator's Companion, second edition, Microsoft Windows Server 2003 Administrator's Companion (MS Press), UNIX and Linux Answers! Certified Tech Support, and NT and UNIX Intranet Secrets (IDG).
ROBERT CORDINGLEY is an Oracle DBA in Austin, Texas. Russel and Cordingley are also co-authors of Oracle DBA Scripting Quick Reference (Prentice Hall PTR).
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
3 of 3 people found the following review helpful:
4.0 out of 5 stars
Clear and simple to use,
By
This review is from: Oracle DBA SQL Quick Reference (Prentice Hall PTR Oracle Series) (Paperback)
Remember the early days of Oracle's products? Now we've reached the heights of Oracle 9i. How things are grown. The multiple table joins; the many obscure syntactical variants added by what are now centuries of person years of coding. Perhaps it is inevitable that any successful software will continually add refinements that increase its capabilities, but usually this is done at a concomitant loss of simplicity. Typically you as a database administrator will rarely use most features. But how to find the occasional rarity that you need, and have forgotten (or perhaps never knew)?By definition, the vendor's manuals are authoritative. But often these fall short in usability or pedagogy. (Oracle is by no means alone in this.) So here, Russel and Cordingley give you an independent, simple index into 9i. A quick perusal shows no index. But a second look shows that the entire book is really a graphical index into, and a refresher of, the command syntax. Like conventional indices, the book does not attempt to explain its entries. For example, on page 146, we see a graph for "add hash substitution". They assume you know what this means, but that you need a quick reminder of HOW to invoke it. Given that you have the database and its online help accessible (otherwise why would you need this book?), this is a fair assumption. Clearly, you can consult the online or hardcopy documentation for more information. The stress in the book is on simplicity. There is a little irony here. A database is a means whereby you can store data in a silo and easily get summaries and subsets ("views") of it. When you strip away the technical jargon, every database package aspires to this. If you regard the commands and capabilities of a database as data (or metadata), then you cannot usually change these. But how do you get summaries and views of THIS data? That is what the vendor's online help and documentation is all about. The irony about this book is not that it was written, but that it was not written by Oracle. The vendor's raison d'etre is to provide tools for access to information. But here, others have seen a need to write another tool to get at the vendor's own data.
1.0 out of 5 stars
Does not compete online references,
By Szilágyi Donát (Dunakeszi, Hungary) - See all my reviews
This review is from: Oracle DBA SQL Quick Reference (Prentice Hall PTR Oracle Series) (Paperback)
Type this in Google: "oracle9i sql reference contents".You will find better reference, which matches your Oracle version perfectly and contain examples, unlike this book. I bet that this book is a printed version of a similar web site as well, because I found a lot of underlined words in it; some of them links to somewhere in the book, some not.
5.0 out of 5 stars
Prashant Dangash,
This review is from: Oracle DBA SQL Quick Reference (Prentice Hall PTR Oracle Series) (Paperback)
The book is truly what the title suggest - a quick reference guide. It makes an Oracle user's life easy by putting SQL commands in a clear concise manner.If you are an Oracle user, who uses Oracle extensively using SQL command interface and not the GUI, this book is for you.
Share your thoughts with other customers: Create your own review
|
|
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
