Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for SQL*Plus
- 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
- 5.1 About Editing Scripts
- 5.2 About Editing Scripts in SQL*Plus Command-Line
- 5.3 About Placing Comments in Scripts
- 5.4 Running Scripts
- 5.5 Nesting Scripts
- 5.6 About Exiting from a Script with a Return Code
- 5.7 Defining Substitution Variables
- 5.8 About Using Predefined Variables
- 5.9 Using Substitution Variables
- 5.10 Passing Parameters through the START Command
- 5.11 About Communicating with the User
- 5.12 About Using Bind Variables
- 5.13 Using REFCURSOR Bind Variables
- 5.14 Fetching Iterative Results from a SELECT inside a PL/SQL Block
-
6
Formatting SQL*Plus Reports
-
6.1
About Formatting Columns
- 6.1.1 About Changing Column Headings
- 6.1.2 About Formatting NUMBER Columns
- 6.1.3 About Formatting Datatypes
- 6.1.4 Copying Column Display Attributes
- 6.1.5 Listing and Resetting Column Display Attributes
- 6.1.6 About Suppressing and Restoring Column Display Attributes
- 6.1.7 Printing a Line of Characters after Wrapped Column Values
-
6.2
About Clarifying Your Report with Spacing and Summary Lines
- 6.2.1 Suppressing Duplicate Values in Break Columns
- 6.2.2 Inserting Space when a Break Column's Value Changes
- 6.2.3 Inserting Space after Every Row
- 6.2.4 Using Multiple Spacing Techniques
- 6.2.5 Listing and Removing Break Definitions
- 6.2.6 Computing Summary Lines when a Break Column's Value Changes
- 6.2.7 Computing Summary Lines at the End of the Report
- 6.2.8 Computing Multiple Summary Values and Lines
- 6.2.9 Listing and Removing COMPUTE Definitions
-
6.3
About Defining Page and Report Titles and Dimensions
- 6.3.1 Setting the Top and Bottom Titles and Headers and Footers
- 6.3.2 Displaying System-Maintained Values in Titles
- 6.3.3 Listing, Suppressing, and Restoring Page Title Definitions
- 6.3.4 Displaying Column Values in Titles
- 6.3.5 About Displaying the Current Date in Titles
- 6.3.6 Setting Page Dimensions
- 6.4 About Storing and Printing Query Results
-
6.1
About Formatting Columns
- 7 Generating Reports from SQL*Plus
- 8 Tuning SQL*Plus
- 9 SQL*Plus Security
- 10 Database Administration with SQL*Plus
- 11 SQL*Plus Globalization Support
-
4
SQL*Plus Basics
-
Part III SQL*Plus Reference
-
12
SQL*Plus Command Reference
- 12.1 SQL*Plus Command Summary
- 12.2 @ (at sign)
- 12.3 @@ (double at sign)
- 12.4 / (slash)
- 12.5 ACCEPT
- 12.6 APPEND
- 12.7 ARCHIVE LOG
- 12.8 ATTRIBUTE
- 12.9 BREAK
- 12.10 BTITLE
- 12.11 CHANGE
- 12.12 CLEAR
- 12.13 COLUMN
- 12.14 COMPUTE
- 12.15 CONNECT
- 12.16 COPY
- 12.17 DEFINE
- 12.18 DEL
- 12.19 DESCRIBE
- 12.20 DISCONNECT
- 12.21 EDIT
- 12.22 EXECUTE
- 12.23 EXIT
- 12.24 GET
- 12.25 HELP
- 12.26 HISTORY
- 12.27 HOST
- 12.28 INPUT
- 12.29 LIST
- 12.30 PASSWORD
- 12.31 PAUSE
- 12.32 PRINT
- 12.33 PROMPT
- 12.34 RECOVER
- 12.35 REMARK
- 12.36 REPFOOTER
- 12.37 REPHEADER
- 12.38 RUN
- 12.39 SAVE
- 12.40 SET
-
12.41
SET System Variable Summary
- 12.41.1 SET APPI[NFO]{ON | OFF | text}
- 12.41.2 SET ARRAY[SIZE] {15 | n}
- 12.41.3 SET AUTO[COMMIT]{ON | OFF | IMM[EDIATE] | n}
- 12.41.4 SET AUTOP[RINT] {ON | OFF}
- 12.41.5 SET AUTORECOVERY [ON | OFF]
- 12.41.6 SET AUTOT[RACE] {ON | OFF | TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]]
- 12.41.7 SET BLO[CKTERMINATOR] {. | c | ON | OFF}
- 12.41.8 SET CMDS[EP] {; | c | ON | OFF}
- 12.41.9 SET COLINVI[SIBLE] [ON | OFF]
- 12.41.10 SET COLSEP { | text}
- 12.41.11 SET CON[CAT] {. | c | ON | OFF}
- 12.41.12 SET COPYC[OMMIT] {0 | n}
- 12.41.13 SET COPYTYPECHECK {ON | OFF}
- 12.41.14 SET DEF[INE] {& | c | ON | OFF}
- 12.41.15 SET DESCRIBE [DEPTH {1 | n | ALL}] [LINENUM {ON | OFF}] [INDENT {ON | OFF}]
- 12.41.16 SET ECHO {ON | OFF}
- 12.41.17 SET EDITF[ILE] file_name[.ext]
- 12.41.18 SET EMB[EDDED] {ON | OFF}
- 12.41.19 SET ERRORL[OGGING] {ON | OFF} [TABLE [schema.]tablename] [TRUNCATE] [IDENTIFIER identifier]
- 12.41.20 SET ESC[APE] {\ | c | ON | OFF}
- 12.41.21 SET ESCCHAR
- 12.41.22 SET EXITC[OMMIT] {ON | OFF}
- 12.41.23 SET FEED[BACK] {6 | n | ON | OFF | ONLY} [SQL_ID]
- 12.41.24 SET FLAGGER {OFF | ENTRY | INTERMED[IATE] | FULL}
- 12.41.25 SET FLU[SH] {ON | OFF}
- 12.41.26 SET HEA[DING] {ON | OFF}
- 12.41.27 SET HEADS[EP] { | c | ON | OFF}
- 12.41.28 SET HIST[ORY] {ON | OFF | n}
- 12.41.29 SET INSTANCE [instance_path | LOCAL]
- 12.41.30 SET LIN[ESIZE] {80 | n | WINDOW}
- 12.41.31 SET LOBOF[FSET] {1 | n}
- 12.41.32 SET LOBPREFETCH {0 | n}
- 12.41.33 SET LOGSOURCE [pathname]
- 12.41.34 SET LONG {80 | n}
- 12.41.35 SET LONGC[HUNKSIZE] {80 | n}
- 12.41.36 SET MARK[UP]
- 12.41.37 SET NEWP[AGE] {1 | n | NONE}
- 12.41.38 SET NULL text
- 12.41.39 SET NUMF[ORMAT] format
- 12.41.40 SET NUM[WIDTH] {10 | n}
- 12.41.41 SET PAGES[IZE] {14 | n}
- 12.41.42 SET PAU[SE] {ON | OFF | text}
- 12.41.43 SET RECSEP {WR[APPED] | EA[CH] | OFF}
- 12.41.44 SET RECSEPCHAR { | c}
- 12.41.45 SET ROWLIMIT {n | OFF}
- 12.41.46 SET ROWPREFETCH {1 | n}
- 12.41.47 SET SECUREDCOL {OFF | ON} [UNAUTH[ORIZED] text] [UNK[NOWN] text]
- 12.41.48 SET SERVEROUT[PUT] {ON | OFF} [SIZE {n | UNL[IMITED]}] [FOR[MAT] {WRA[PPED] | WOR[D_WRAPPED] | TRU[NCATED]}]
- 12.41.49 SET SHIFT[INOUT] {VIS[IBLE] | INV[ISIBLE]}
- 12.41.50 SET SHOW[MODE] {ON | OFF}
- 12.41.51 SET SQLBL[ANKLINES] {ON | OFF}
- 12.41.52 SET SQLC[ASE] {MIX[ED] | LO[WER] | UP[PER]}
- 12.41.53 SET SQLCO[NTINUE] {> | text}
- 12.41.54 SET SQLN[UMBER] {ON | OFF}
- 12.41.55 SET SQLPLUSCOMPAT[IBILITY] {x.y[.z]}
- 12.41.56 SET SQLPRE[FIX] {# | c}
- 12.41.57 SET SQLP[ROMPT] {SQL> | text}
- 12.41.58 SET SQLT[ERMINATOR] {; | c | ON | OFF}
- 12.41.59 SET STATEMENTC[ACHE] {0 | n}
- 12.41.60 SET SUF[FIX] {SQL | text}
- 12.41.61 SET TAB {ON | OFF}
- 12.41.62 SET TERM[OUT] {ON | OFF}
- 12.41.63 SET TI[ME] {ON | OFF}
- 12.41.64 SET TIMI[NG] {ON | OFF}
- 12.41.65 SET TRIM[OUT] {ON | OFF}
- 12.41.66 SET TRIMS[POOL] {ON | OFF}
- 12.41.67 SET UND[ERLINE] {- | c | ON | OFF}
- 12.41.68 SET VER[IFY] {ON | OFF}
- 12.41.69 SET WRA[P] {ON | OFF}
- 12.41.70 SET XMLOPT[IMIZATIONCHECK] [ON|OFF]
- 12.41.71 SET XQUERY BASEURI {text}
- 12.41.72 SET XQUERY ORDERING {UNORDERED | ORDERED | DEFAULT}
- 12.41.73 SET XQUERY NODE {BYVALUE | BYREFERENCE | DEFAULT}
- 12.41.74 SET XQUERY CONTEXT {text}
- 12.42 SHOW
- 12.43 SHUTDOWN
- 12.44 SPOOL
- 12.45 START
- 12.46 STARTUP
- 12.47 STORE
- 12.48 TIMING
- 12.49 TTITLE
- 12.50 UNDEFINE
- 12.51 VARIABLE
- 12.52 WHENEVER OSERROR
- 12.53 WHENEVER SQLERROR
- 12.54 XQUERY
- 13 SQL*Plus Error Messages
-
12
SQL*Plus Command Reference
- Part IV SQL*Plus Appendixes
- A SQL*Plus Limits
- B SQL*Plus COPY Command
-
C
Obsolete SQL*Plus Commands
- C.1 SQL*Plus Obsolete Command Alternatives
- C.2 BTI[TLE] text (obsolete old form)
- C.3 COL[UMN] {column|expr} DEF[AULT] (obsolete)
- C.4 DOC[UMENT] (obsolete)
- C.5 NEWPAGE [1|n] (obsolete)
- C.6 SET BUF[FER] {buffer|SQL} (obsolete)
- C.7 SET COM[PATIBILITY]{V7 | V8 | NATIVE} (obsolete)
- C.8 SET CLOSECUR[SOR] {ON|OFF} (obsolete)
- C.9 SET DOC[UMENT] {ON|OFF} (obsolete)
- C.10 SET MAXD[ATA] n (obsolete)
- C.11 SET SCAN {ON|OFF} (obsolete)
- C.12 SET SPACE {1|n} (obsolete)
- C.13 SET TRU[NCATE] {ON|OFF} (obsolete)
- C.14 TTI[TLE] text (obsolete old form)
-
D
SQL*Plus Instant Client
- D.1 About Choosing the SQL*Plus Instant Client to Install
- D.2 About Installing SQL*Plus Instant Client by Downloading from OTN
- D.3 Installing SQL*Plus Instant Client from the 19c Client Release Media
- D.4 About Configuring SQL*Plus Instant Client
- D.5 About Connecting to a Database with SQL*Plus Instant Client
- D.6 AS SYSDBA or AS SYSOPER Connections with SQL*Plus Instant Client
- D.7 About Uninstalling Instant Client
- Index