Oracle SQL Plus: The Definitive Guide
The Definitive Guide
Published on 13. April 1999
Book
512 pages
978-1-56592-578-6 (ISBN)
Description
This book is the definitive guide to SQL*Plus. If you want to take best advantage of the power and flexibility of this popular Oracle tool, you need this book. SQL*Plus is an interactive query tool that is ubiquitous in the Oracle world. It is present in every Oracle installation and is available to almost every Oracle developer and database administrator. SQL*Plus has been shipped with Oracle since at least version 6. It continues to be supported and enhanced with each new version of Oracle, including Oracle8 and Oracle8i. It is still the only widely available tool for writing SQL scripts. Despite this wide availability and usage, few developers and DBAs know how powerful SQL*Plus really is. This book introduces SQL*Plus, includes a quick reference to all of its syntax options, and, most important, provides chapters that describe, in step-by-step fashion, how to perform all of the tasks that Oracle developers and DBAs want to perform with SQL*Plus -- and maybe some they didn't realize they COULD perform with SQL*Plus.
You will learn how to write and execute script files, generate ad hoc reports, extract data from the database, query the data dictionary tables, customize your SQL*Plus environment, and use the SQL*Plus administrative features (new in Oracle8i). This book is an indispensable resource for readers who are new to SQL*Plus, a task-oriented learning tool for those who are already using it, and a quick reference for every user.
You will learn how to write and execute script files, generate ad hoc reports, extract data from the database, query the data dictionary tables, customize your SQL*Plus environment, and use the SQL*Plus administrative features (new in Oracle8i). This book is an indispensable resource for readers who are new to SQL*Plus, a task-oriented learning tool for those who are already using it, and a quick reference for every user.
Reviews / Votes
'One puzzling aspect of the O'Reilly series is how the publishers have managed to find such competent authors when other companies seem unable to get anyone who can string a sentence together. You really get the feeling that the authors want to tell you how to solve a problem rather than demonstrate how clever they are. ... Oracle SQL*Plus is a strong candidate for the bookshelf, with information you'd otherwise have to check in four of the Oracle manuals, and There's a human voice helping you.' Computer Shopper, July 2000More details
Other editions
New editions
Book
12/2004
2nd Edition
O'Reilly
€37.50
Article not available at the moment
Person
Jonathan Gennick is an independent consultant and computer book author specializing in Oracle technologies. He got his start with relational database systems in 1990, first working with Ingres, and later with Digital's Rdb software. In 1994 he made the leap to Oracle, and hasn't looked back yet. Much of his time is spent providing database administration services, as well as server-side PL/SQL support, to clients and internal project teams. When he is not working with Oracle, Jonathan can often be found writing about it. Recent projects include Oracle SQL*Plus Pocket Reference (O'Reilly & Associates, 2000); Oracle SQL*Plus: The Definitive Guide (O'Reilly & Associates, 1999); Oracle8i DBA's Bible (IDG Books, 2000); and Teach Yourself PL/SQL in 21 Days, Second Edition (SAMS Publishing, 1999). Writing has given Jonathan the opportunity to pursue several interests outside of his normal day-to-day work. He is a member of the technology committee for the Greater Lansing Adventist School, and he manages the web site for his local church. This satisfies his gnawing need to learn, and also his desire to help others. Jonathan is a member of MENSA. 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 Lansing, Michigan with his wife Donna and their two children: Jenny and Jeff. Jonathan may be contacted by email at jonathan@gennick.com.
Content
Preface 1. Introduction to SQL*Plus 2. Interacting with SQL*Plus 3. Generating Reports with SQL*Plus 4. Writing SQL*Plus Scripts 5. Extracting Data with SQL*Plus 6. Exploring Your Database with SQL*Plus 7. Advanced Scripting 8. Tuning and Timing 9. The Product User Profile 10. Administration with SQL*Plus 11. Customizing Your SQL*Plus Environment