Publisher: O'Reilly Media Released: November 2004 Pages: 592
Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQL*Plus. This bestselling book--now updated for Oracle 10g--is the only in-depth guide to this interactive query tool for writing SQL scripts. It's an essential resource for any Oracle user. The new second edition of Oracle SQLPlus: The Definitive Guide clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQLPlus--and maybe some you didn't realize you could perform. With Oracle SQLPlus: The Definitive Guide , you'll expertly: - write and execute script files
- generate ad hoc reports
- extract data from the database
- query the data dictionary tables
- customize an SQLPlus environment
- and much more
It also includes a handy quick reference to all of its syntax options and an often-requested chapter on SQL itself, along with a clear, concise, and complete introduction. This book is truly the definitive guide to SQLPlus. It's an indispensable resource for those who are new to SQLPlus, a task-oriented learning tool for those who are already using it, and an immediately useful quick reference for every user. If you want to leverage the full power and flexibility of this popular Oracle tool, you'll need this book. |
- Title:
- Oracle SQL*Plus: The Definitive Guide, 2nd Edition
- By:
- Jonathan Gennick
- Publisher:
- O'Reilly Media
- Formats:
-
- Print
- Ebook
- Safari Books Online
- Print:
- November 2004
- Ebook:
- February 2009
- Pages:
- 592
- Print ISBN:
- 978-0-596-00746-1
- | ISBN 10:
- 0-596-00746-9
- Ebook ISBN:
- 978-0-596-10453-5
- | ISBN 10:
- 0-596-10453-7
|
-
Jonathan Gennick Jonathan Gennick is an O'Reilly & Associates editor specializing in database and programming titles. Prior to joining O'Reilly, Jonathan amassed some 17 years of programming and database management experience. During the latter part of his career he specialized in relational database programming, and more recently in database management. Jonathan got his start with relational database systems in 1990, first working with Ingres, and later with Digital's Rdb software. 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. Recent projects include Oracle SQLLoader (O'Reilly & Associates, 2001); Oracle SQLPlus Pocket Reference (O'Reilly & Associates, 2000); Oracle SQL*Plus: The Definitive Guide (O'Reilly & Associates, 1999); More recently, Jonathan has made forays into other database products, coauthoring Transact-SQL Cookbook (O'Reilly & Associates, 2002) and editing Practical PostgreSQL (O'Reilly & Associates, 2002). Jonathan is certified as an Oracle DBA and is a member of MENSA and the Oracle Technology Network. He holds a Bachelor of Arts degree in Information and Computer Science, with a Business Administration minor, from Andrews University in Berrien Springs, Michigan. Jonathan currently resides in Munising, Michigan with his wife Donna and their two children: Jenny and Jeff. Jonathan may be contacted by email at jonathan@gennick.com, and you can learn more about him personally by visiting his website at http://gennick.com. View Jonathan Gennick's full profile page. |
Colophon Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animal on the cover of Oracle SQLPlus: The Definitive Guide , Second Edition is a moving leaf (Phyllium giganteum), a large (about 10 cm in length) Malaysian leaf insect related to stickinsects; together these constitute the order Phasmatida, derived from the Greekword for "ghost." These stunning insects imitate local foliage with intricate detail, down to the leaf-like veins on their legs and tattered brown edges to mimic dead leaves. Moving leaf insects feed on bramble and other plant material. Kept by many entymologists as exotic pets, they require high temperature and humidity. Matt Hutchinson was the production editor for Oracle SQLPlus: The Definitive Guide, Second Edition. GEX, Inc. provided production services. Darren Kelly and Marlowe Shaeffer provided quality control. Edie Freedman designed the cover of this book. The cover image is a 19th-century engraving from the Dover Pictorial Archive. Clay Fernald produced the cover layout with QuarkXPress 4.1 using Adobe's ITC Garamond font. David Futato designed the interior layout. This bookwas converted by Julie Hawks to FrameMaker 5.5.6 with a format conversion tool created by Erik Ray, Jason McIntosh, Neil Walls, and Mike Sierra that uses Perl and XML technologies. The text font is Linotype Birka; the heading font is Adobe Myriad Condensed; and the code font is LucasFont's TheSans Mono Condensed. The illustrations that appear in the book were produced by Robert Romano and Jessamyn Read using Macromedia FreeHand MX and Adobe Photoshop CS (except for Figure 4-1, which was provided by Matt Williams). The tip and warning icons were drawn by Christopher Bing. This colophon was written by Nancy Kotary. |
|
Description
|
Table of Contents
|
Product Details
|
About the Author
|
Colophon
|
 |
|
 |
|
|
|
Recommended for You
|
Recently Viewed
|
 |
|
By John Kim
February 2007
By Dave Thomas, Chad Fowler, Andy Hunt
October 2004
By Bill Loguidice, Matt Barton
|
Customer Reviews
1/14/2005 (1 of 1 customers found this review helpful) By Doroszlai Attila from Undisclosed
|
|
|