Want it by Wednesday, October 24?
Order by 12:00 PM Eastern and choose Expedited Shipping at checkout.
Same Day shipping in Manhattan. See Details
Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQL Plus. This bestselling booknow updated for Oracle 10gis 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 SQL Plus: The Definitive Guide clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQL Plusand maybe some you didn't realize you could perform.With Oracle SQL Plus: 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 SQL Plus environment
- and much more
About the Author
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 SQL Loader (O'Reilly & Associates, 2001); Oracle SQL Plus 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 email@example.com, and you can learn more about him personally by visiting his website at http://gennick.com.
Table of Contents
Chapter 1: Introduction to SQL*Plus
Chapter 2: Command-Line SQL*Plus
Chapter 3: Browser-Based SQL*Plus
Chapter 4: A Lightning SQL Tutorial
Chapter 5: Generating Reports with SQL*Plus
Chapter 6: Creating HTML Reports
Chapter 7: Advanced Reports
Chapter 8: Writing SQL*Plus Scripts
Chapter 9: Extracting and Loading Data
Chapter 10: Exploring Your Database
Chapter 11: Advanced Scripting
Chapter 12: Tuning and Timing
Chapter 13: The Product User Profile
Chapter 14: Customizing Your SQL*Plus Environment
Appendix A: SQL*Plus Command Reference
Appendix B: SQL*Plus Format Elements
Most Helpful Customer Reviews
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.