Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Database SQL*Plus User's Guide and Reference
- Introduction to SQL*Plus
-
Part I Introduction to SQL*Plus
- 1 SQL*Plus User Interface
- 2 Configuring SQL*Plus
- 3 Starting SQL*Plus
-
Part II Using SQL*Plus
-
4
SQL*Plus Basics
- 4.1 About Entering and Executing Commands
- 4.2 About Listing a Table Definition
- 4.3 About Listing PL/SQL Definitions
- 4.4 Running SQL Commands
- 4.5 About Running PL/SQL Blocks
- 4.6 Running SQL*Plus Commands
- 4.7 System Variables that Affect How Commands Run
- 4.8 About Stopping a Command while it is Running
- 4.9 About Running Operating System Commands
- 4.10 About Pausing the Display
- 4.11 About Saving Changes to the Database Automatically
- 5 Using Scripts in SQL*Plus
-
6
Using Substitution Variables
- 6.1 Defining Substitution Variables
- 6.2 About Using Predefined Variables
-
6.3
Referencing Substitution Variables
- 6.3.1 Where and How to Use Substitution Variables
- 6.3.2 Difference Between "&" and "&&" Prefixes
- 6.3.3 Storing a Query Column Value in a Substitution Variable
- 6.3.4 Restrictions
- 6.3.5 How Substitution Variables are Handled in SQL*Plus
- 6.3.6 Substitution Variable Commands
- 6.3.7 Substitution Variable Namespace, Types, Formats and Limits
- 6.3.8 Assigning Substitution Variables to Bind Variables
- 6.3.9 Assigning Bind Variables to Substitution Variables
-
6.3.10
Substitution Variable Examples
- 6.3.10.1 Setting a Substitution Variable's Value
- 6.3.10.2 Using a Substitution Variable
- 6.3.10.3 Finding All Defined Substitution Variables
- 6.3.10.4 Inserting Data Containing "&" Without Being Prompted
- 6.3.10.5 Putting the Current Date in a Spool File Name
- 6.3.10.6 Appending Alphanumeric Characters Immediately After a Substitution Variable
- 6.3.10.7 Putting a Period After a Substitution Variable
- 6.3.10.8 Using a Fixed Value Variable in a TTITLE, BTITLE, REPHEADER or REPFOOTER
- 6.3.10.9 Using a Changing Value Variable in a TTITLE, BTITLE, REPHEADER or REPFOOTER
- 6.3.10.10 Using the Value of a Bind Variable in a SQL*Plus Command Like SPOOL
- 6.3.10.11 Passing Parameters to SQL*Plus Substitution Variables
- 6.3.10.12 Passing Operating System Variables to SQL*Plus
- 6.3.10.13 Passing a Value to a PL/SQL Procedure From the Command Line
- 6.3.10.14 Allowing Script Parameters to be Optional and Have a Default Value
- 6.3.10.15 Using a Variable for the SQL*Plus Return Status
- 6.3.10.16 Putting the Username and Database in the Prompt
- 6.4 System Variables Influencing Substitution Variables
- 6.5 Passing Parameters through the START Command
- 6.6 About Communicating with the User
- 6.7 About Using Bind Variables
- 6.8 Using REFCURSOR Bind Variables
- 6.9 Fetching Iterative Results from a SELECT inside a PL/SQL Block
-
7
Formatting SQL*Plus Reports
-
7.1
About Formatting Columns
- 7.1.1 About Changing Column Headings
- 7.1.2 About Formatting NUMBER Columns
- 7.1.3 About Formatting Datatypes
- 7.1.4 Copying Column Display Attributes
- 7.1.5 Listing and Resetting Column Display Attributes
- 7.1.6 About Suppressing and Restoring Column Display Attributes
- 7.1.7 Printing a Line of Characters after Wrapped Column Values
-
7.2
About Clarifying Your Report with Spacing and Summary Lines
- 7.2.1 Suppressing Duplicate Values in Break Columns
- 7.2.2 Inserting Space when a Break Column's Value Changes
- 7.2.3 Inserting Space after Every Row
- 7.2.4 Using Multiple Spacing Techniques
- 7.2.5 Listing and Removing Break Definitions
- 7.2.6 Computing Summary Lines when a Break Column's Value Changes
- 7.2.7 Computing Summary Lines at the End of the Report
- 7.2.8 Computing Multiple Summary Values and Lines
- 7.2.9 Listing and Removing COMPUTE Definitions
-
7.3
About Defining Page and Report Titles and Dimensions
- 7.3.1 Setting the Top and Bottom Titles and Headers and Footers
- 7.3.2 Displaying System-Maintained Values in Titles
- 7.3.3 Listing, Suppressing, and Restoring Page Title Definitions
- 7.3.4 Displaying Column Values in Titles
- 7.3.5 About Displaying the Current Date in Titles
- 7.3.6 Setting Page Dimensions
- 7.4 About Storing and Printing Query Results
-
7.1
About Formatting Columns
- 8 Generating Reports from SQL*Plus
-
9
Tuning SQL*Plus
- 9.1 About Tracing Statements
- 9.2 About Collecting Timing Statistics
- 9.3 Tracing Parallel and Distributed Queries
- 9.4 Execution Plan Output in Earlier Databases
-
9.5
About SQL*Plus Script Tuning
- 9.5.1 COLUMN NOPRINT
- 9.5.2 SET APPINFO OFF
- 9.5.3 SET ARRAYSIZE
- 9.5.4 SET DEFINE OFF
- 9.5.5 SET FLUSH OFF
- 9.5.6 SET LINESIZE
- 9.5.7 SET LONGCHUNKSIZE
- 9.5.8 SET PAGESIZE
- 9.5.9 SET SERVEROUTPUT
- 9.5.10 SET SQLPROMPT
- 9.5.11 SET TAB
- 9.5.12 SET TERMOUT
- 9.5.13 SET TRIMOUT ON SET TRIMSPOOL ON
- 9.5.14 UNDEFINE
- 9.5.15 SET ROWPREFETCH
- 9.5.16 SET STATEMENTCACHE
- 9.5.17 SET LOBPREFETCH
- 9.5.18 Command Line -FAST Option
- 10 SQL*Plus Security
- 11 Database Administration with SQL*Plus
- 12 SQL*Plus Globalization Support
-
4
SQL*Plus Basics
-
Part III SQL*Plus Reference
-
13
SQL*Plus Command Reference
- 13.1 SQL*Plus Command Summary
- 13.2 @ (at sign)
- 13.3 @@ (double at sign)
- 13.4 / (slash)
- 13.5 ACCEPT
- 13.6 APPEND
- 13.7 ARCHIVE LOG
- 13.8 ARGUMENT
- 13.9 ATTRIBUTE
- 13.10 BREAK
- 13.11 BTITLE
- 13.12 CHANGE
- 13.13 CLEAR
- 13.14 COLUMN
- 13.15 COMPUTE
- 13.16 CONFIG
- 13.17 CONNECT
- 13.18 COPY
- 13.19 DEFINE
- 13.20 DESCRIBE
- 13.21 DEL
- 13.22 DISCONNECT
- 13.23 EDIT
- 13.24 EXECUTE
- 13.25 EXIT
- 13.26 GET
- 13.27 HELP
- 13.28 HISTORY
- 13.29 HOST
- 13.30 INPUT
- 13.31 LIST
- 13.32 OERR
- 13.33 PASSWORD
- 13.34 PAUSE
- 13.35 PING
- 13.36 PRINT
- 13.37 PROMPT
- 13.38 RECOVER
- 13.39 REMARK
- 13.40 REPFOOTER
- 13.41 REPHEADER
- 13.42 RUN
- 13.43 SAVE
- 13.44 SET
-
13.45
SET System Variable Summary
- 13.45.1 SET APPINFO
- 13.45.2 SET ARRAYSIZE
- 13.45.3 SET AUTOCOMMIT
- 13.45.4 SET AUTOPRINT
- 13.45.5 SET AUTORECOVERY
- 13.45.6 SET AUTOTRACE
- 13.45.7 SET BLOCKTERMINATOR
- 13.45.8 SET CMDSEP
- 13.45.9 SET COLINVISIBLE
- 13.45.10 SET COLSEP
- 13.45.11 SET CONCAT
- 13.45.12 SET COPYCOMMIT
- 13.45.13 SET COPYTYPECHECK
- 13.45.14 SET DEFINE
- 13.45.15 SET DESCRIBE
- 13.45.16 SET ECHO
- 13.45.17 SET EDITFILE
- 13.45.18 SET EMBEDDED
- 13.45.19 SET ERRORDETAILS
- 13.45.20 SET ERRORLOGGING
- 13.45.21 SET ESCAPE
- 13.45.22 SET ESCCHAR
- 13.45.23 SET EXITCOMMIT
- 13.45.24 SET FEEDBACK
- 13.45.25 SET FLAGGER
- 13.45.26 SET FLUSH
- 13.45.27 SET HEADING
- 13.45.28 SET HEADSEP
- 13.45.29 SET HISTORY
- 13.45.30 SET INSTANCE
- 13.45.31 SET JSONPRINT
- 13.45.32 SET LINESIZE
- 13.45.33 SET LOBOFFSET
- 13.45.34 SET LOBPREFETCH
- 13.45.35 SET LOGSOURCE
- 13.45.36 SET LONG
- 13.45.37 SET LONGCHUNKSIZE
- 13.45.38 SET MARKUP
- 13.45.39 SET NEWPAGE
- 13.45.40 SET NULL
- 13.45.41 SET NUMFORMAT
- 13.45.42 SET NUMWIDTH
- 13.45.43 SET PAGESIZE
- 13.45.44 SET PAUSE
- 13.45.45 SET RECSEP
- 13.45.46 SET RECSEPCHAR
- 13.45.47 SET ROWLIMIT
- 13.45.48 SET ROWPREFETCH
- 13.45.49 SET SECUREDCOL
- 13.45.50 SET SERVEROUTPUT
- 13.45.51 SET SHIFTINOUT
- 13.45.52 SET SHOWMODE
- 13.45.53 SET SQLBLANKLINES
- 13.45.54 SET SQLCASE
- 13.45.55 SET SQLCONTINUE
- 13.45.56 SET SQLNUMBER
- 13.45.57 SET SQLPLUSCOMPATIBILITY
- 13.45.58 SET SQLPREFIX
- 13.45.59 SET SQLPROMPT
- 13.45.60 SET SQLTERMINATOR
- 13.45.61 SET STATEMENTCACHE
- 13.45.62 SET SUFFIX
- 13.45.63 SET TAB
- 13.45.64 SET TERMOUT
- 13.45.65 SET TIME
- 13.45.66 SET TIMING
- 13.45.67 SET TRIMOUT
- 13.45.68 SET TRIMSPOOL
- 13.45.69 SET UNDERLINE
- 13.45.70 SET VERIFY
- 13.45.71 SET WRAP
- 13.45.72 SET XMLOPTIMIZATIONCHECK
- 13.45.73 SET XQUERY BASEURI
- 13.45.74 SET XQUERY ORDERING
- 13.45.75 SET XQUERY NODE
- 13.45.76 SET XQUERY CONTEXT
- 13.46 SHOW
- 13.47 SHUTDOWN
- 13.48 SPOOL
- 13.49 START
- 13.50 STARTUP
- 13.51 STORE
- 13.52 TIMING
- 13.53 TTITLE
- 13.54 UNDEFINE
- 13.55 VARIABLE
- 13.56 WHENEVER OSERROR
- 13.57 WHENEVER SQLERROR
- 13.58 XQUERY
-
13
SQL*Plus Command Reference
- Part IV SQL*Plus Appendixes
- A SQL*Plus Limits
- B SQL*Plus COPY Command
- C Obsolete SQL*Plus Commands
-
D
SQL*Plus Instant Client
- D.1 About Choosing the SQL*Plus Instant Client to Install
- D.2 List of Files Required for SQL*Plus Instant Client
- D.3 Installing SQL*Plus Instant Client by Downloading Installation Files from OTN
- D.4 Installing SQL*Plus Instant Client from the 21c Client Release Media
- D.5 Configuring SQL*Plus Instant Client
- D.6 About Connecting to a Database with SQL*Plus Instant Client
- D.7 AS SYSDBA or AS SYSOPER Connections with SQL*Plus Instant Client
- D.8 About Uninstalling Instant Client
- Index