Table of Contents
- Title and Copyright Information
- Preface
- SQL*Plus Quick Start
-
Part I SQL*Plus Getting Started
- 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
- 4.12 About Interpreting Error Messages
- 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
- 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 ATTRIBUTE
- 13.9 BREAK
- 13.10 BTITLE
- 13.11 CHANGE
- 13.12 CLEAR
- 13.13 COLUMN
- 13.14 COMPUTE
- 13.15 CONNECT
- 13.16 COPY
- 13.17 DEFINE
- 13.18 DEL
- 13.19 DESCRIBE
- 13.20 DISCONNECT
- 13.21 EDIT
- 13.22 EXECUTE
- 13.23 EXIT
- 13.24 GET
- 13.25 HELP
- 13.26 HISTORY
- 13.27 HOST
- 13.28 INPUT
- 13.29 LIST
- 13.30 PASSWORD
- 13.31 PAUSE
- 13.32 PRINT
- 13.33 PROMPT
- 13.34 RECOVER
- 13.35 REMARK
- 13.36 REPFOOTER
- 13.37 REPHEADER
- 13.38 RUN
- 13.39 SAVE
- 13.40 SET
-
13.41
SET System Variable Summary
- 13.41.1 SET APPINFO
- 13.41.2 SET ARRAYSIZE
- 13.41.3 SET AUTOCOMMIT
- 13.41.4 SET AUTOPRINT
- 13.41.5 SET AUTORECOVERY
- 13.41.6 SET AUTOTRACE
- 13.41.7 SET BLOCKTERMINATOR
- 13.41.8 SET CMDSEP
- 13.41.9 SET COLINVISIBLE
- 13.41.10 SET COLSEP
- 13.41.11 SET CONCAT
- 13.41.12 SET COPYCOMMIT
- 13.41.13 SET COPYTYPECHECK
- 13.41.14 SET DEFINE
- 13.41.15 SET DESCRIBE
- 13.41.16 SET ECHO
- 13.41.17 SET EDITFILE
- 13.41.18 SET EMBEDDED
- 13.41.19 SET ERRORLOGGING
- 13.41.20 SET ESCAPE
- 13.41.21 SET ESCCHAR
- 13.41.22 SET EXITCOMMIT
- 13.41.23 SET FEEDBACK
- 13.41.24 SET FLAGGER
- 13.41.25 SET FLUSH
- 13.41.26 SET HEADING
- 13.41.27 SET HEADSEP
- 13.41.28 SET HISTORY
- 13.41.29 SET INSTANCE
- 13.41.30 SET JSONPRINT
- 13.41.31 SET LINESIZE
- 13.41.32 SET LOBOFFSET
- 13.41.33 SET LOBPREFETCH
- 13.41.34 SET LOGSOURCE
- 13.41.35 SET LONG
- 13.41.36 SET LONGCHUNKSIZE
- 13.41.37 SET MARKUP
- 13.41.38 SET NEWPAGE
- 13.41.39 SET NULL
- 13.41.40 SET NUMFORMAT
- 13.41.41 SET NUMWIDTH
- 13.41.42 SET PAGESIZE
- 13.41.43 SET PAUSE
- 13.41.44 SET RECSEP
- 13.41.45 SET RECSEPCHAR
- 13.41.46 SET ROWLIMIT
- 13.41.47 SET ROWPREFETCH
- 13.41.48 SET SECUREDCOL
- 13.41.49 SET SERVEROUTPUT
- 13.41.50 SET SHIFTINOUT
- 13.41.51 SET SHOWMODE
- 13.41.52 SET SQLBLANKLINES
- 13.41.53 SET SQLCASE
- 13.41.54 SET SQLCONTINUE
- 13.41.55 SET SQLNUMBER
- 13.41.56 SET SQLPLUSCOMPATIBILITY
- 13.41.57 SET SQLPREFIX
- 13.41.58 SET SQLPROMPT
- 13.41.59 SET SQLTERMINATOR
- 13.41.60 SET STATEMENTCACHE
- 13.41.61 SET SUFFIX
- 13.41.62 SET TAB
- 13.41.63 SET TERMOUT
- 13.41.64 SET TIME
- 13.41.65 SET TIMING
- 13.41.66 SET TRIMOUT
- 13.41.67 SET TRIMSPOOL
- 13.41.68 SET UNDERLINE
- 13.41.69 SET VERIFY
- 13.41.70 SET WRAP
- 13.41.71 SET XMLOPTIMIZATIONCHECK
- 13.41.72 SET XQUERY BASEURI
- 13.41.73 SET XQUERY ORDERING
- 13.41.74 SET XQUERY NODE
- 13.41.75 SET XQUERY CONTEXT
- 13.42 SHOW
- 13.43 SHUTDOWN
- 13.44 SPOOL
- 13.45 START
- 13.46 STARTUP
- 13.47 STORE
- 13.48 TIMING
- 13.49 TTITLE
- 13.50 UNDEFINE
- 13.51 VARIABLE
- 13.52 WHENEVER OSERROR
- 13.53 WHENEVER SQLERROR
- 13.54 XQUERY
- 14 SQL*Plus Error Messages
-
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