Oracle SQL*Plus: The Definitive Guide, 2nd Edition View Larger Image | Jonathan Gennick
O'Reilly Media, Paperback, 2nd edition, Published November 2004, 554 pages, ISBN 0596007469 | List Price: $39.95
Our Price: $23.95
You Save: $16.00 (40% Off)
| | | Availability: Out-Of-Stock |
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: - Oracle PL/SQL Programming, 4th Edition; Steven Feuerstein, et al, $38.95, 40% Off!
- Oracle SQL*Plus Pocket Reference, 3rd Edition; Jonathan Gennick, $5.95, 40% Off!
- Mastering Oracle SQL, 2nd Edition; Sanjay Mishra, et al, $23.95, 40% Off!
- Oracle Database 10g: The Complete Reference; Kevin Loney, $44.95, 39% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
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 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*Plus--and 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
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 SQL*Plus. It's an indispensable resource for those who are new to SQL*Plus, 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.
Table of Contents
Preface
1. Introduction to SQL*Plus
What Is SQL*Plus?
History of SQL*Plus
Why Master SQL*Plus?
Creating and Loading the Sample Tables
2. Command-Line SQL*Plus
Starting Command-Line SQL*Plus
Starting Windows SQL*Plus
Some Basic SQL*Plus Commands
Running SQL Queries
Working With PL/SQL
The SQL Buffer
Line Editing
Executing the Statement in the Buffer
Saving and Retrieving the Buffer
The EDIT Command
Executing a Script
The Working Directory
3. Browser-Based SQL*Plus
Starting iSQL*Plus
Executing SQL*Plus Commands
Running SQL Queries
Working with PL/SQL
Executing Scripts
iSQL*Plus Command History
4. A Lightning SQL Tutorial
Data Manipulation Statements
Transactions
The Concept of Null
Table Joins
Sorting Query Results
Grouping and Summarizing
Subqueries
Unions
To Learn More
5. Generating Reports with SQL*Plus
Following a Methodology
Saving Your Work
Designing a Simple Report
Master/Detail Reports
6. Creating HTML Reports
Getting the Data into an HTML Table
Generating the Entire Page
Another Approach to Headers
Master/Detail Reports in HTML
7. Advanced Reports
Totals and Subtotals
Getting the Current Date into a Header
Report Headers and Footers
Formatting Object Columns
Summary Reports
Taking Advantage of Unions
8. Writing SQL*Plus Scripts
Why Write Scripts?
Using Substitution Variables
Prompting for Values
Cleaning Up the Display
Executing a Script
Controlling Variable Substitution
Commenting Your Scripts
Resetting Your SQL*Plus Environment
Scripting Issues with iSQL*Plus
9. Extracting and Loading Data
Types of Output Files
Limitations of SQL*Plus
Extracting the Data
An Excel-Specific HTML Hack
Reloading the Data
10. Exploring Your Database
The DESCRIBE Command
Oracle's Data Dictionary Views
Tables
Table Constraints
Indexes
Triggers
Synonyms
Table Security
Scripting the Data Dictionary
Using SQL to Write SQL
The Master Key
11. Advanced Scripting
Bind Variables
Branching in SQL*Plus
Looping in SQL*Plus
Validating and Parsing User Input
Error Handling
Returning Values to Unix
12. Tuning and Timing
Using SQL*Plus Timers
Using EXPLAIN PLANstatements
Using AUTOTRACE
Improving on EXPLAIN PLAN Results
Where to Find More Tuning Information
13. The Product User Profile
What Is the Product User Profile?
Using the Product User Profile
14. Customizing Your SQL*Plus Environment
SQL*Plus Settings You Can Control
The Site and User Profiles
Environment Variables That Affect SQL*Plus
Windows GUI SQL*Plus
iSQL*Plus User Preferences
A. SQL*Plus Command Reference
B. SQL*Plus Format Elements
Index
ABOUT THE AUTHOR:
Jonathan Gennick is an O'Reilly Media, Inc. 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 Media, Inc., 2001); Oracle SQL*Plus Pocket Reference (O'Reilly Media, Inc., 2000); Oracle SQL*Plus: The Definitive Guide (O'Reilly Media, Inc., 1999); More recently, Jonathan has made forays into other database products, coauthoring Transact-SQL Cookbook (O'Reilly Media, Inc., 2002) and editing Practical PostgreSQL (O'Reilly Media, Inc., 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.
|
