This quick reference is an excellent, portable resource for every Oracle administrator and developer. It summarizes the syntax of SQLPlus, Oracle's ubiquitous interactive query tool, including new Oracle8i release 8.1.6 features. It also summarizes how to interact with SQLPlus and presents the basics of selecting data, formatting reports, and tuning SQL.

This pocket reference provides quick reference information that will help you use SQLPlus, Oracle's interactive query tool. It summarizes all of the SQLPlus syntax, including the syntax for new Oracle8i release 8.1.6 features.

SQLPlus is available at every Oracle site--from the largest data warehouse to the smallest single-user system--and it's a critical tool for virtually every Oracle user. Despite its wide use, few developers and DBAs know how powerful a tool SQLPlus can be.

This book boils down the most vital information from Gennick's best-selling book, Oracle SQLPlus: The Definitive Guide, into an accessible summary. It concisely describes interacting with SQLPlus, selecting data, formatting reports with SQLPlus, and tuning SQL queries. It also contains quick references to the SQLPlus commands and format elements.

This book is an indispensable companion to O'Reilly bestselling book, Oracle SQLPlus: The Definitive Guide, but it does not replace it; the larger book is truly the definitive guide, suitable for readers at all levels of expertise. The definitive guide describes the many tasks that SQLPlus can perform, and provides a tutorial on many SQLPlus topics. But this quick reference is an excellent, portable resource for readers who want a pocket-sized summary of SQLPlus capabilities and a reminder of how to issue specific commands and formatting options for SQL*Plus.

Table of Contents:

1. Interacting with SQLPlus
2. Selecting Data
3. Formatting Reports
4. Tuning SQL
5. SQLPlus Format Elements
6. SQL*Plus Command Reference