Buying Options
Oracle SQL*Plus: The Definitive Guide
This product is no longer available.

Please consider the latest edition.

Oracle SQL*Plus: The Definitive Guide

By
Jonathan Gennick
Publisher:
O'Reilly Media
Released:
March 1999
Pages:
528

Product Editions

  1. Oracle SQL*Plus: The Definitive Guide, Second Edition - November 2004
  2. Oracle SQL*Plus: The Definitive Guide - March 1999 (out of print)
Description
This book is the definitive guide to SQL*Plus, Oracle's interactive query tool. Despite the wide availability and usage of SQL*Plus, few developers and DBAs know how powerful it really is. This book introduces SQL*Plus, provides a syntax quick reference, and describes how to write and execute script files, generate ad hoc reports, extract data from the database, query the data dictionary tables, use the SQL*Plus administrative features (new in Oracle8i), and much more.
Full Description
Table of Contents

  1. Chapter 1 Introduction to SQL*Plus

    1. What Is SQL*Plus?

    2. History of SQL*Plus

    3. Why Master SQL*Plus?

    4. Creating and Loading the Sample Tables

  2. Chapter 2 Interacting with SQL*Plus

    1. Starting SQL*Plus

    2. Some Basic SQL*Plus Commands

    3. Running SQL Queries

    4. Working with PL/SQL

    5. The SQL Buffer

    6. Line Editing

    7. Executing the Statement in the Buffer

    8. Saving and Retrieving the Buffer

    9. The EDIT Command

    10. Executing a Script

    11. The Working Directory

  3. Chapter 3 Generating Reports with SQL*Plus

    1. Following a Methodology

    2. Saving Your Work

    3. Designing a Simple Report

    4. Advanced Report Formatting

    5. Totals and Subtotals

    6. Other Reporting Topics

  4. Chapter 4 Writing SQL*Plus Scripts

    1. Why Write Scripts?

    2. Using Substitution Variables

    3. Prompting for Values

    4. Cleaning Up the Display

    5. Packaging Your Script

    6. The DEFINE and UNDEFINE Commands

    7. Controlling Variable Substitution

    8. Commenting Your Scripts

  5. Chapter 5 Extracting and Loading Data

    1. Types of Output Files

    2. Limitations of SQL*Plus

    3. Extracting the Data

    4. Reloading the Data

  6. Chapter 6 Exploring Your Database

    1. The DESCRIBE Command

    2. Oracle's Data Dictionary Views

    3. Tables

    4. Table Constraints

    5. Indexes

    6. Triggers

    7. Synonyms

    8. Table Security

    9. Finding More Information

  7. Chapter 7 Advanced Scripting

    1. Bind Variables

    2. Branching in SQL*Plus

    3. Looping in SQL*Plus

    4. Validating and Parsing User Input

    5. Error Handling

  8. Chapter 8 Tuning and Timing

    1. Using SQL*Plus Timers

    2. Using EXPLAIN PLAN

    3. Using AUTOTRACE

    4. Improving on EXPLAIN PLAN Results

    5. Where to Find More Tuning Information

  9. Chapter 9 The Product User Profile

    1. What Is the Product User Profile?

    2. Using the Product User Profile

  10. Chapter 10 Administration with SQL*Plus

    1. Connecting for Administrative Purposes

    2. Starting and Stopping a Database

    3. Looking at Your Database

    4. Database Backup and Recovery

  11. Chapter 11 Customizing Your SQL*Plus Environment

    1. SQL*Plus Settings You Can Control

    2. The Site and User Profiles

    3. Environment Variable Settings

    4. The SET Command

    5. The SHOW Command

  1. Appendix A SQL*Plus Command Reference

    1. SQLPLUS

    2. Comment Delimiters (/*...*/)

    3. Double Hyphen (- -)

    4. At Sign (@)

    5. Double At Sign (@@)

    6. Forward Slash (/)

    7. ACCEPT

    8. APPEND

    9. ARCHIVE LOG

    10. ATTRIBUTE

    11. BREAK

    12. BTITLE

    13. CHANGE

    14. CLEAR

    15. COPY

    16. COLUMN

    17. COMPUTE

    18. CONNECT

    19. DEFINE

    20. DEL

    21. DESCRIBE

    22. DISCONNECT

    23. EDIT

    24. EXECUTE

    25. EXIT

    26. GET

    27. HELP

    28. HOST

    29. INPUT

    30. LIST

    31. PASSWORD

    32. PAUSE

    33. PRINT

    34. PROMPT

    35. QUIT

    36. RECOVER

    37. REMARK

    38. REPFOOTER

    39. REPHEADER

    40. RUN

    41. SAVE

    42. SET

    43. SHOW

    44. SHUTDOWN

    45. SPOOL

    46. START

    47. STARTUP

    48. STORE

    49. TIMING

    50. TTITLE

    51. UNDEFINE

    52. VARIABLE

    53. WHENEVER

  2. Appendix B SQL*Plus Format Elements

    1. Formatting Numbers

    2. Formatting Character Strings

    3. Formatting Dates

  3. Colophon

View Full Table of Contents
Product Details
Title:
Oracle SQL*Plus: The Definitive Guide
By:
Jonathan Gennick
Publisher:
O'Reilly Media
Formats:
  • Print
Print Release:
March 1999
Pages:
528
Print ISBN:
978-1-56592-578-6
| ISBN 10:
1-56592-578-5
Customer Reviews
About the Author

  1. Jonathan Gennick

    Jonathan Gennick is an O'Reilly & Associates 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 & Associates, 2001); Oracle SQL*Plus Pocket Reference (O'Reilly & Associates, 2000); Oracle SQL*Plus: The Definitive Guide (O'Reilly & Associates, 1999); More recently, Jonathan has made forays into other database products, coauthoring Transact-SQL Cookbook (O'Reilly & Associates, 2002) and editing Practical PostgreSQL (O'Reilly & Associates, 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. Jonathan may be contacted by email at jonathan@gennick.com, and you can learn more about him personally by visiting his website at http://gennick.com.

    View Jonathan Gennick's full profile page.

Colophon

Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animal on the cover of Oracle SQLPlus: The Definitive Guide is a moving leaf (Phyllium giganteum), a large (about 10 cm in length) Malaysian leaf insect related to stick insects; together these constitute the order Phasmatida, derived from the Greek word for "ghost." These stunning insects imitate local foliage with intricate detail, down to the leaf-like veins on their legs and tattered brown edges to mimic dead leaves. Moving leaf insects feed on bramble and other plant material. Kept by many entymologists as exotic pets, they require high temperature and humidity. Ellie Fountain Maden was the production editor and project manager for Oracle SQLPlus: The Definitive Guide, and also copyedited the book. Quality assurance was provided by Madeleine Newell, Sarah Jane Shangraw, and Sheryl Avruch, who was also the production manager. Ellie Cutler proofread the book, and Seth Maislin wrote the index.

Edie Freedman designed the cover of this book, using a 19th-century engraving from the Dover Pictorial Archive. The cover layout was produced by Kathleen Wilson with Quark XPress 3.32 using the ITC Garamond font.

The inside layout was designed by Nancy Priest and implemented in FrameMaker 5.5 by Mike Sierra. The text and heading fonts are ITC Garamond Light and Garamond Book. The illustrations that appear in the book were created in Macromedia FreeHand 8 and Adobe Photoshop 5 by Robert Romano. This colophon was written by Nancy Kotary.

  • Book cover of Oracle SQL*Plus: The Definitive Guide
Got a Question?
icons
Favicon Service and support by Satisfaction