Book description
Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQLPlus. 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 SQLPlus: The Definitive Guide clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQLPlus--and maybe some you didn't realize you could perform.With Oracle SQLPlus: 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 SQLPlus environment
- and much more
Publisher resources
Table of contents
-
Oracle SQL*Plus: The Definitive Guide, 2nd Edition
- SPECIAL OFFER: Upgrade this ebook with OâReilly
- A Note Regarding Supplemental Files
-
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
- 1. Introduction to SQL*Plus
-
2. Command-Line SQL*Plus
- 2.1. Starting Command-Line SQL*Plus
- 2.2. Starting Windows SQL*Plus
- 2.3. Some Basic SQL*Plus Commands
- 2.4. Running SQL Queries
- 2.5. Working with PL/SQL
- 2.6. The SQL Buffer
- 2.7. Line Editing
- 2.8. Executing the Statement in the Buffer
- 2.9. Saving and Retrieving the Buffer
- 2.10. The EDIT Command
- 2.11. Executing a Script
- 2.12. The Working Directory
- 3. Browser-Based SQL*Plus
- 4. A Lightning SQL Tutorial
-
5. Generating Reports with SQL*Plus
- 5.1. Following a Methodology
- 5.2. Saving Your Work
- 5.3. Designing a Simple Report
- 5.4. Master/Detail Reports
- 6. Creating HTML Reports
- 7. Advanced Reports
-
8. Writing SQL*Plus Scripts
- 8.1. Why Write Scripts?
- 8.2. Using Substitution Variables
- 8.3. Prompting for Values
- 8.4. Cleaning Up the Display
- 8.5. Executing a Script
- 8.6. Controlling Variable Substitution
- 8.7. Commenting Your Scripts
- 8.8. Resetting Your SQL*Plus Environment
- 8.9. Scripting Issues with iSQL*Plus
- 9. Extracting and Loading Data
- 10. Exploring Your Database
-
11. Advanced Scripting
- 11.1. Bind Variables
- 11.2. Branching in SQL*Plus
- 11.3. Looping in SQL*Plus
- 11.4. Validating and Parsing User Input
- 11.5. Error Handling
- 11.6. Returning Values to Unix
- 12. Tuning and Timing
- 13. The Product User Profile
- 14. Customizing Your SQL*Plus Environment
-
A. SQL*Plus Command Reference
- A.1. The Command to Invoke SQL*Plus
-
A.2. Commands You Can Issue Within SQL*Plus
- Comment Delimiters (/* . . . */)
- Double Hyphen (- -)
- At Sign (@)
- Double At Sign (@@)
- Forward Slash (/)
- ACCEPT
- APPEND
- ARCHIVE LOG
- ATTRIBUTE
- BREAK
- BTITLE
- CHANGE
- CLEAR
- COLUMN
- COMPUTE
- CONNECT
- COPY
- DEFINE
- DEL
- DESCRIBE
- DISCONNECT
- EDIT
- EXECUTE
- EXIT
- GET
- HELP
- HOST
- INPUT
- LIST
- PASSWORD
- PAUSE
- PROMPT
- QUIT
- RECOVER
- REMARK
- REPFOOTER
- REPHEADER
- RUN
- SAVE
- SET APPINFO
- SET ARRAYSIZE
- SET AUTOCOMMIT
- SET AUTOPRINT
- SET AUTORECOVERY
- SET AUTOTRACE
- SET BLOCKTERMINATOR
- SET BUFFER
- SET CLOSECURSOR
- SET CMDSEP
- SET COLSEP
- SET COMPATIBILITY
- SET CONCAT
- SET COPYCOMMIT
- SET COPYTYPECHECK
- SET DEFINE
- SET DESCRIBE
- SET DOCUMENT
- SET ECHO
- SET EDITFILE
- SET EMBEDDED
- SET ESCAPE
- SET FEEDBACK
- SET FLAGGER
- SET FLUSH
- SET HEADING
- SET HEADSEP
- SET INSTANCE
- SET LINESIZE
- SET LOBOFFSET
- SET LOGSOURCE
- SET LONG
- SET LONGCHUNKSIZE
- SET MARKUP
- SET MAXDATA
- SET NEWPAGE
- SET NULL
- SET NUMFORMAT
- SET NUMWIDTH
- SET PAGESIZE
- SET PAUSE
- SET RECSEP
- SET RECSEPCHAR
- SET SCAN
- SET SERVEROUTPUT
- SET SHIFTINOUT
- SET SHOWMODE
- SET SPACE
- SET SQLBLANKLINES
- SQLCASE
- SET SQLCONTINUE
- SET SQLNUMBER
- SET SQLPLUSCOMPATIBILITY
- SET SQLPREFIX
- SET SQLPROMPT
- SET SQLTERMINATOR
- SET SUFFIX
- SET TAB
- SET TERMOUT
- SET TIME
- SET TIMING
- SET TRIMOUT
- SET TRIMSPOOL
- SET TRUNCATE
- SET UNDERLINE
- SET VERIFY
- SET WRAP
- SHOW
- SHUTDOWN
- SPOOL
- START
- STARTUP
- STORE
- TIMING
- TTITLE
- UNDEFINE
- VARIABLE
- WHENEVER
- B. SQL*Plus Format Elements
- About the Author
- Colophon
- SPECIAL OFFER: Upgrade this ebook with OâReilly
Product information
- Title: Oracle SQL*Plus: The Definitive Guide, 2nd Edition
- Author(s):
- Release date: November 2004
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596552619
You might also like
book
Oracle SQL*Plus: The Definitive Guide
This book is the definitive guide to SQL*Plus. If you want to take best advantage of …
book
Oracle PL/SQL Programming, Third Edition
Nearly a quarter-million PL/SQL programmers--novices and experienced developers alike--have found the first and second editions of …
book
Advanced Oracle PL/SQL Developer's Guide - Second Edition
Master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle …
book
Oracle PL/SQL Programming, 5th Edition
This book is the definitive reference on PL/SQL, considered throughout the database community to be the …