• Table of Contents
• Index
• Reviews
• Reader Reviews
• Errata
• Academic
Oracle SQL*Plus: The Definitive Guide, 2nd Edition By Jonathan Gennick Publisher : O''''Reilly Pub Date : November 2004 ISBN : 0-596-00746-9 Pages : 582 Copyright
Preface
Why I Wrote This Book
Objectives of This Book
What''''s New in the Second Edition?
Which Platform and Version?
Structure of This Book
Obtaining the Scripts and Sample Data
What About Those Names?
Conventions Used in This Book
Using Code Examples
Comments and Questions
Acknowledgments from the First Edition
Second Edition Acknowledgments
Chapter 1. Introduction to SQL*Plus
Section 1.1. What Is SQL*Plus?
Section 1.2. History of SQL*Plus
Section 1.3. Why Master SQL*Plus?
Section 1.4. Creating and Loading the Sample Tables
Chapter 2. Command-Line SQL*Plus
Section 2.1. Starting Command-Line SQL*Plus
Section 2.2. Starting Windows SQL*Plus
Section 2.3. Some Basic SQL*Plus Commands
Section 2.4. Running SQL Queries
Section 2.5. Working with PL/SQL
Section 2.6. The SQL Buffer
Section 2.7. Line Editing
Section 2.8. Executing the Statement in the Buffer
Section 2.9. Saving and Retrieving the Buffer
Section 2.10. The EDIT Command
Section 2.11. Executing a Script
Section 2.12. The Working Directory
Chapter 3. Browser-Based SQL*Plus
Section 3.1. Starting iSQL*Plus
Section 3.2. Executing SQL*Plus Commands
Section 3.3. Running SQL Queries
Section 3.4. Working with PL/SQL
Section 3.5. Executing Scripts
Section 3.6. iSQL*Plus Command History
Chapter 4. A Lightning SQL Tutorial
Section 4.1. Data Manipulation Statements
Section 4.2. Transactions
Section 4.3. The Concept of Null
Section 4.4. Table Joins
Section 4.5. Sorting Query Results
Section 4.6. Grouping and Summarizing
Section 4.7. Subqueries
Section 4.8. Unions
Section 4.9. To Learn More
Chapter 5. Generating Reports with SQL*Plus
Section 5.1. Following a Methodology
Section 5.2. Saving Your Work
Section 5.3. Designing a Simple Report
Section 5.4. Master/Detail Reports
Chapter 6. Creating HTML Reports
Section 6.1. Getting the Data into an HTML Table
Section 6.2. Generating the Entire Page
Section 6.3. Another Approach to Headers
Section 6.4. Master/Detail Reports in HTML
Chapter 7. Advanced Reports
Section 7.1. Totals and Subtotals
Section 7.2. Getting the Current Date into a Header
Section 7.3. Report Headers and Footers
Section 7.4. Formatting Object Columns
Section 7.5. Summary Reports
Section 7.6. Taking Advantage of Unions
Chapter 8. Writing SQL*Plus Scripts
Section 8.1. Why Write Scripts?
Section 8.2. Using Substitution Variables
Section 8.3. Prompting for Values
Section 8.4. Cleaning Up the Display
Section 8.5. Executing a Script
Section 8.6. Controlling Variable Substitution
Section 8.7. Commenting Your Scripts
Section 8.8. Resetting Your SQL*Plus Environment
Section 8.9. Scripting Issues with iSQL*Plus
Chapter 9. Extracting and Loading Data
Section 9.1. Types of Output Files
Section 9.2. Limitations of SQL*Plus
Section 9.3. Extracting the Data
Section 9.4. An Excel-Specific HTML Hack
Section 9.5. Reloading the Data
Chapter 10. Exploring Your Database
Section 10.1. The DESCRIBE Command
Section 10.2. Oracle''''s Data Dictionary Views
Section 10.3. Tables
Section 10.4. Table Constraints
Section 10.5. Indexes
Section 10.6. Triggers
Section 10.7. Synonyms
Section 10.8. Table Security
Section 10.9. Scripting the Data Dictionary
Section 10.10. Using SQL to Write SQL
Section 10.11. The Master Key
Chapter 11. Advanced Scripting
Section 11.1. Bind Variables
Section 11.2. Branching in SQL*Plus
Section 11.3. Looping in SQL*Plus
Section 11.4. Validating and Parsing User Input
Section 11.5. Error Handling
Section 11.6. Returning Values to Unix
Chapter 12. Tuning and Timing
Section 12.1. Using SQL*Plus Timers
Section 12.2. Using EXPLAIN PLAN
Section 12.3. Using AUTOTRACE
Section 12.4. Improving on EXPLAIN PLAN Results
Section 12.5. Where to Find More Tuning Information
Chapter 13. The Product User Profile
Section 13.1. What Is the Product User Profile?
Section 13.2. Using the Product User Profile
Chapter 14. Customizing Your SQL*Plus Environment
Section 14.1. SQL*Plus Settings You Can Control
Section 14.2. The Site and User Profiles
Section 14.3. Environment Variables That Affect SQL*Plus
Section 14.4. Windows GUI SQL*Plus
Section 14.5. iSQL*Plus User Preferences
Appendix A. SQL*Plus Command Reference
Section A.1. The Command to Invoke SQL*Plus
Section A.2. Commands You Can Issue Within SQL*Plus
Appendix B. SQL*Plus Format Elements
Section B.1. Formatting Numbers
Section B.2. Formatting Character Strings
Section B.3. Formatting Dates
Colophon
Index