Oracle SQL*Plus: The Definitive Guide, 2nd Edition
What's New in the Second Edition?
Obtaining the Scripts and Sample Data
Acknowledgments from the First Edition
Second Edition Acknowledgments
Chapter 1. Introduction to SQL*Plus
1.4 Creating and Loading the Sample Tables
Chapter 2. Command-Line SQL*Plus
2.1 Starting Command-Line SQL*Plus
2.3 Some Basic SQL*Plus Commands
2.8 Executing the Statement in the Buffer
2.9 Saving and Retrieving the Buffer
Chapter 3. Browser-Based SQL*Plus
3.2 Executing SQL*Plus Commands
Chapter 4. A Lightning SQL Tutorial
4.1 Data Manipulation Statements
Chapter 5. Generating Reports with SQL*Plus
Chapter 6. Creating HTML Reports
6.1 Getting the Data into an HTML Table
6.2 Generating the Entire Page
6.3 Another Approach to Headers
6.4 Master/Detail Reports in HTML
7.2 Getting the Current Date into a Header
7.3 Report Headers and Footers
7.6 Taking Advantage of Unions
Chapter 8. Writing SQL*Plus Scripts
8.2 Using Substitution Variables
8.6 Controlling Variable Substitution
8.8 Resetting Your SQL*Plus Environment
8.9 Scripting Issues with iSQL*Plus
Chapter 9. Extracting and Loading Data
9.4 An Excel-Specific HTML Hack
Chapter 10. Exploring Your Database
10.2 Oracle's Data Dictionary Views
10.9 Scripting the Data Dictionary
Chapter 11. Advanced Scripting
11.2.1 Simulating Branching by Adjusting the WHERE Clause
11.4 Validating and Parsing User Input
12.4 Improving on EXPLAIN PLAN Results
12.5 Where to Find More Tuning Information
Chapter 13. The Product User Profile
13.1 What Is the Product User Profile?
13.2 Using the Product User Profile
Chapter 14. Customizing Your SQL*Plus Environment
14.1 SQL*Plus Settings You Can Control
14.2 The Site and User Profiles
14.3 Environment Variables That Affect SQL*Plus
14.5 iSQL*Plus User Preferences
Appendix A. SQL*Plus Command Reference
A.1 The Command to Invoke SQL*Plus
A.2 Commands You Can Issue Within SQL*Plus
Appendix B. SQL*Plus Format Elements
B.2 Formatting Character Strings