Oracle SQL*Plus Pocket Reference (Pocket Reference (O'Reilly))
| Author | : | |
| Rating | : | 4.32 (789 Votes) |
| Asin | : | 0596008856 |
| Format Type | : | paperback |
| Number of Pages | : | 154 Pages |
| Publish Date | : | 2013-03-05 |
| Language | : | English |
DESCRIPTION:
New SQL information includes the SELECT statement's new MODEL clause, flashback queries, partition outer joins, and DBMS_XPLAN.With its quick-reference format and compact size, the Oracle SQLPlus Pocket Reference follows in the long line of successful "pocket references" offered by O'Reilly. In addition to summarizing all of the SQLPlus syntax and format options, including new Oracle Database 10g features, this handy, on-the-job guide specifically shows readers how to:Differentiate between SQL and SQLPlusInteract with SQLPlus from both the command line and the web browserSelect, insert, update, and delete dataFormat both text and HTML reports with SQLPlusSpecify SQLPlus commands and format elementsTune SQL queriesThe new third edition of this book has been updated for Oracle Database 10g to include information on both SQLPlus and SQL. As Oracle's long-standing interactive query tool, SQLPlus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. It also serves as the ideal companion to O'Reilly's larger, more comprehensive book on SQLPlus, the bestselling Oracle SQLPlus: The Definitive Guide.Author Jonathan Gennick is an editor for O'Reil
editor specializing in database and programming titles. Jonathan currently resides in Munising, Michigan with his wife Donna and their two children: Jenny and Jeff. Prior to joining O'Reilly, Jonathan amassed some 17 years of programming and database management experience. During the latter part of his career
OK as far as it goes R. Ross 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 . Extremely Useful 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 itthe 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 d. E. Winstead said A Real Time Saver. 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.
editor specializing in database and programming titles. During that period he developed a fondness for SQL, and for the challenge of applying SQL creatively in ways that leveraged it's set-oriented capabilities.In 1994 Jonathan made the leap to Oracle, and is now often found writing about it. About the AuthorJonathan Gennick is an O'Reilly Media, Inc. Recent projects include Oracle SQLLoader (O'Reilly Media, Inc., 2001); Oracle SQLPlus Pocket Reference (O'Reilly Media, Inc., 2000); Oracle SQL*Plus: