Index

Symbols Numerics A B C D E F G H I J L M N O P Q R S T U V W X

Symbols

_CONNECT_IDENTIFIER predefined variable 2.2.2.1, 13.19.1
_DATE predefined variable 13.19.1
_EDITOR, in EDIT command 5.1.1, 13.19.1, 13.23
_EDITOR predefined variable 5.1.1, 13.19.1, 13.23
_EDITOR substitution variable 13.19.1
_O_RELEASE predefined variable 13.19.1
_O_VERSION predefined variable 13.19.1
_PRIVILEGE predefined variable 13.19.1
_RC predefined variable 13.29
_SQLPLUS_RELEASE predefined variable 13.19.1
_USER predefined variable 13.19.1
; (semicolon) 4.4, 5.2, 13.31
/*...*/ (comment delimiters) 5.3.2
~ infinity sign 13.14
-~ negative infinity sign 13.14
((amp)) (ampersand)
- disabling substitution variables 6.4
- substitution variables 6.3
((colon)) (colon)
- bind variables 6.7
((colon))BindVariable clause
- EXIT command 13.25
((nbsp))/ (slash) command
- default logon 3.5.2, 13.17
- entered at buffer line-number prompt 4.4.1.2, 13.4
- entered at command prompt 13.4
- executing current PL/SQL block 4.5
- similar to RUN 13.4, 13.42
- usage 13.4
((nbsp)). (period) 4.5
((nbsp))-- (comment delimiter) 5.3.3
((nbsp))- (hyphen)
- clause 3.5.1.1, 3.5.1.9
- continuing a long SQL*Plus command 4.6.1.1, 13
@ (at sign)
- command 2.2.3.1, 5.4, 13.2
- command arguments 13.2, 13.3
- in CONNECT command 13.17
- in COPY command B.1, B.2.1
- in SQLPLUS command 3.5
- passing parameters to a script 13.2, 13.3
- script 5.4, 13.2
- similar to START 5.4, 13.49
@@ (double at sign) command 2.2.3.1, 13.3
- script 13.3
- similar to START 13.3, 13.49
@ at sign)
- similar to START 13.2
$ number format 7.1.2.2
* (asterisk)
- in DEL command 5.2, 13.21
- in LIST command 5.2, 13.31
# pound sign
- overflow indication 13.14
- SET SQLPREFIX character 13.45.58
-MARKUP 3.5.1.6, 8.1
- SQLPLUS command clause 3.5.1.6, 13.45.38
-SILENT option 3.5.1.11, 8.1.3

Numerics

0, number format 7.1.2.2
9, number format 7.1.2.2

A

ABORT mode 13.47
abort query 4.8
ACCEPT command 6.6.1, 13.5
- and DEFINE command 13.19
- BINARY_DOUBLE clause 13.5, 13.55
- BINARY_FLOAT clause 13.5, 13.55
- customizing prompts for value 6.6.2
- DATE clause 13.5
- DEFAULT clause 13.5
- FORMAT clause 13.5
- HIDE clause 13.5
- NOPROMPT clause 13.5
- NUMBER clause 6.6.2
- PROMPT clause 6.6.1, 13.5
alias 3.2.3
ALIAS clause 13.14
- in ATTRIBUTE command 13.9
ALL clause 13.46
ampersands (((amp)))
- in parameters 6.5, 13.2, 13.3, 13.49
- substitution variables 6.3
APPEND clause
- in COPY command B.1.1, B.2.2
- in SAVE command 13.43, 13.48
APPEND command 5.2, 5.2.3, 13.6
APPINFO clause 9.5.2, 13.45.1
ARCHIVE LOG
- command 11.3.1, 13.7
- mode 11.3.1
argument
- in START command 6.5
ARGUMENT
- command 13.8
ARRAYSIZE variable 9.5.3, 13.45, 13.45.2
- relationship to COPY command B.1.2, B.2.3
ATTRIBUTE command 13.9
- ALIAS clause 13.9
- and CLEAR COLUMN command 13.9
- CLEAR clause 13.9
- clearing columns 13.13, 13.14
- controlling display characteristics 13.9
- display characteristics 13.9
- entering multiple 13.9
- FORMAT clause 13.9
- LIKE clause 13.9
- listing attribute display characteristics 13.9
- OFF clause 13.9
- ON clause 13.9
- restoring column display attributes 13.9
- suppressing column display attributes 13.9
AUTOCOMMIT variable 4.11, 13.45, 13.45.3
AUTOMATIC clause 13.38
AUTOPRINT variable 13.45, 13.45.4
AUTORECOVERY variable 13.45, 13.45.5
autotrace report 9.1.1
AUTOTRACE variable 9.1.1, 13.45.6

B

background process 13.47
BASEURI variable 13.45
BASEURI XQUERY option 13.45.73
basic OCI package D.1.1
batch jobs, authenticating users in 3.1.1
batch mode 13.25
BEGIN command 4.5
BINARY_DOUBLE clause
- ACCEPT command 13.5, 13.55
- VARIABLE command 13.55
BINARY_FLOAT clause
- ACCEPT command 13.5, 13.55
- VARIABLE command 13.55
bind variables 6.7
- creating 13.55
- displaying 13.36
- displaying automatically 13.45.4, 13.55
- in PL/SQL blocks 13.55
- in SQL statements 13.55
- in the COPY command 13.55
blank line
- in PL/SQL blocks 4.5
- in SQL commands 4.4.1.2
- preserving in SQL commands 13.45, 13.45.53
BLOB
- column width 7.1.3.1
- formating in reports 7.1.3
BLOB columns
- default format 13.14
- setting maximum width 13.45, 13.45.36
- setting retrieval position 13.45, 13.45.33
- setting retrieval size 9.5.7, 13.45, 13.45.37
blocks, PL/SQL
- continuing 4.5
- editing in buffer 5.2
- editing with system editor 5.1, 13.23
- entering and executing 4.5
- listing current in buffer 5.2.1
- saving current 13.43
- setting character used to end 13.45, 13.45.7
- stored in SQL buffer 4.5
- timing statistics 13.45.66
- within SQL commands 4.5.1
BLOCKTERMINATOR 13.45, 13.45.7, 13.45.53, 13.45.60
BODY clause 3.5.1.6
BODY option 3.5.1.6
BOLD clause 13.41, 13.53
BOOLEAN
- column definition from DESCRIBE 13.20
BOOLEAN clause
- VARIABLE command 13.55
break columns 7.2, 13.10
- inserting space when value changes 7.2.2
- specifying multiple 7.2.4
- suppressing duplicate values in 7.2.1
BREAK command 7.2, 13.10
- and SQL ORDER BY clause 7.2, 7.2.1, 7.2.4, 13.10
- clearing BREAKS 7.2.5
- displaying column values in titles 7.3.4
- DUPLICATES clause 13.10
- inserting space after every row 7.2.3
- inserting space when break column changes 7.2.2
- listing current break definition 7.2.5, 13.10
- ON column clause 7.2.1, 13.10
- ON expr clause 13.10
- ON REPORT clause 7.2.7, 13.10
- ON ROW clause 7.2.3, 13.10
- printing grand and sub summaries 7.2.7
- printing summary lines at ends of reports 7.2.7
- removing definition 13.13
- SKIP clause 7.2.3, 13.10
- SKIP PAGE clause 7.2.2, 7.2.3, 13.10
- specifying multiple break columns 7.2.4, 13.10
- suppressing duplicate values 7.2.1
- used in conjunction with COMPUTE 7.2.6
- used in conjunction with SET COLSEP 13.45.10
- used to format a REFCURSOR variable 13.55
- used with COMPUTE 13.10, 13.15
break definition
- listing current 7.2.5, 13.10
- removing current 7.2.5, 13.13
BREAKS clause 7.2.5, 13.13
browser, web 8.1.1
BTITLE clause 13.46
BTITLE command 7.3.1, 13.11
- aligning title elements 13.53
- BOLD clause 13.53
- CENTER clause 13.53
- COL clause 13.53
- FORMAT clause 13.53
- indenting titles 13.53
- LEFT clause 13.53
- OFF clause 13.53
- old form C.2
- printing blank lines before bottom title 7.3.1.1
- referencing column value variable 13.14
- RIGHT clause 13.53
- SKIP clause 13.53
- suppressing current definition 13.53
- TAB clause 13.53
- TTITLE command 13.11
buffer 4.1.1
- appending text to a line in 5.2.3, 13.6
- delete a single line 5.2
- delete the current line 5.2
- delete the last line 5.2
- deleting all lines 5.2, 13.13, 13.21
- deleting a range of lines 5.2, 13.21
- deleting a single line 13.21
- deleting lines from 5.2.5, 13.21
- deleting the current line 13.21
- deleting the last line 13.21
- executing contents 13.4, 13.42
- inserting new line in 5.2.4, 13.30
- listing all lines 5.2, 13.31
- listing a range of lines 5.2, 13.31
- listing a single line 5.2, 13.31
- listing contents 5.2.1, 13.31
- listing the current line 5.2, 13.31
- listing the last line 5.2, 13.31
- loading into system editor 13.23
- saving contents 13.43
BUFFER clause 5.1.1, 5.2, 13.13
BUFFER variable C.6

C

CANCEL clause 13.38
Cancel key 4.8
cancel query 4.8
CENTER clause 7.3.1.1, 13.41, 13.53
CHANGE command 5.2, 5.2.2, 13.12
CHAR clause
- VARIABLE command 13.55
CHAR columns
- changing format 13.14
- default format 7.1.3.1
- definition from DESCRIBE 13.20
charset
- SQL*Plus Instant Client D.1.2
CLEAR clause 7.1.5, 13.14, 13.28
- in ATTRIBUTE command 13.9
CLEAR command 13.13
- BREAKS clause 7.2.5, 13.13
- BUFFER clause 5.1.1, 5.2, 13.13
- COLUMNS clause 13.13
- COMPUTES clause 13.13
- SCREEN clause 6.6.4, 13.13
- SQL clause 13.13
- TIMING clause 13.13
CLOB clause
- VARIABLE command 13.55
CLOB columns
- changing format 13.14
- default format 13.14
- setting maximum width 13.45, 13.45.36
- setting retrieval position 13.45, 13.45.33
- setting retrieval size 9.5.7, 13.45, 13.45.37
CLOSECURSOR variable C.1, C.8
CMDSEP variable 13.45, 13.45.8
COL clause 7.3.1.2, 13.41, 13.53
COLINVISIBLE variable 13.45.9
colons (((colon)))
- bind variables 6.7
COLSEP variable 13.45, 13.45.10
COLUMN command 7.1, 13.14
- ALIAS clause 13.14
- and BREAK command 13.10
- and DEFINE command 13.19
- CLEAR clause 7.1.5, 13.14
- DEFAULT clause C.3
- displaying column values in bottom titles 7.3.4, 13.14
- displaying column values in top titles 7.3.4, 13.14
- entering multiple 13.14
- ENTMAP clause 13.14
- FOLD_AFTER clause 13.14
- FOLD_BEFORE clause 13.14
- FORMAT clause 7.1.2.2, 7.1.3.2, 13.14
- formatting a REFCURSOR variable 13.55
- formatting NUMBER columns 7.1.2.1, 13.14
- HEADING clause 7.1.1.2, 13.14
- HEADSEP character 13.14
- JUSTIFY clause 13.14
- LIKE clause 7.1.4, 13.14
- listing column display attributes 7.1.5, 13.14
- NEW_VALUE clause 7.3.4, 13.14
- NEWLINE clause 13.14
- NOPRINT clause 7.3.4, 9.5.1, 13.14
- NULL clause 13.14
- OFF clause 7.1.6, 13.14
- OLD_VALUE clause 7.3.4, 13.14
- ON clause 7.1.6, 13.14
- PRINT clause 13.14
- resetting a column to default display C.1
- resetting to default display 7.1.5, 13.14, C.1
- restoring column display attributes 7.1.6, 13.14
- storing current date in variable for titles 13.14
- suppressing column display attributes 7.1.6, 13.14
- TRUNCATED clause 7.1.3.2, 13.14
- WORD_WRAPPED clause 7.1.3.2, 7.1.7, 13.14
- WRAPPED clause 7.1.3.2, 13.14
column headings
- aligning 13.14
- changing 7.1.1.1, 13.14
- changing character used to underline 13.45, 13.45.69
- changing to two or more words 7.1.1.2, 13.14
- displaying on more than one line 7.1.1.2, 13.14
- suppressing printing in a report 13.45, 13.45.27
- when truncated 13.14
- when truncated for CHAR and LONG columns 7.1.3.2
- when truncated for DATE columns 7.1.3.2
- when truncated for NUMBER columns 7.1.2.1
columns
- assigning aliases 13.14
- computing summary lines 7.2.6, 13.15
- copying display attributes 7.1.4, 13.9, 13.14
- copying values between tables B.1, B.2, B.3
- displaying values in bottom titles 7.3.4, 13.14
- displaying values in top titles 7.3.4, 13.14
- formatting CHAR, VARCHAR, LONG, and DATE 13.14
- formatting in reports 7.1, 13.14
- formatting MLSLABEL, RAW MLSLABEL, ROWLABEL 13.14
- formatting NUMBER 7.1.2.1, 13.14
- listing display attributes for all 7.1.5, 13.14
- listing display attributes for one 7.1.5, 13.14
- names in destination table when copying B.1.1, B.2.1
- printing line after values that overflow 7.1.7, 13.45, 13.45.46
- resetting a column to default display 7.1.5, 13.14, C.1
- resetting all columns to default display 13.13
- restoring display attributes 7.1.6, 13.9, 13.14
- setting printing to off or on 7.3.4, 9.5.1, 13.14
- starting new lines 13.14
- storing values in variables 7.3.4, 13.14
- suppressing display attributes 7.1.6, 13.9, 13.14
- truncating display for all when value overflows 7.1.3.2, 13.45.71
- truncating display for one when value overflows 7.1.3.2, 13.14
- wrapping display for all when value overflows 7.1.3.2, 13.45.71
- wrapping display for one when value overflows 7.1.3.2, 13.14
- wrapping whole words for one 7.1.7
COLUMNS clause 13.13
column separator 13.45, 13.45.10, C.1
comma, number format 7.1.2.2
command files
- aborting and exiting with a return code 5.6, 13.56, 13.57
- creating with a system editor 5.1.1
- creating with SAVE 13.43, 13.45.17
- editing with system editor 13.23
- in @ (at sign) command 5.4, 13.2
- including comments in 5.3, 13.39
- including more than one PL/SQL block 5.1.1
- including more than one SQL command 5.1.1
- in EDIT command 13.23
- in GET command 13.26
- in SAVE command 5.1.1, 13.43
- in SQLPLUS command 3.5.3, 5.4.1
- in START command 5.4, 13.49
- nesting 5.5
- passing parameters to 6.5, 13.2, 13.3, 13.49
- registering 13.45, 13.45.1
- retrieving 13.26
- running 5.4, 13.2, 13.49
- running a series in sequence 5.5
- running as you start SQL*Plus 3.5.3, 5.4.1
- running in batch mode 5.6, 13.25
- uniform resource locator 13.2, 13.3, 13.49
command history
- SQL*Plus 13.28
command-line
- configuring globalization support 12.1
- installing help 2.2.4
command-line interface
- changing face and size 1.2
command prompt
- SET SQLPROMPT 9.5.10, 13.45, 13.45.59
- SQL*Plus 3.3.1
commands
- collecting timing statistics on 9.2, 13.52
- disabling 10.1
- echo on screen 13.45.16
- host, running from SQL*Plus 4.9, 13.29
- listing current in buffer 13.31
- re-enabling 10.1
- spaces 4.1
- SQL
  - continuing on additional lines 4.4.1.1
  - editing in buffer 5.2
  - editing with system editor 13.23
  - ending 4.4.1.2
  - entering and executing 4.4
  - entering without executing 4.4.1.2
  - executing current 13.4, 13.42
  - following syntax 4.4.1
  - listing current in buffer 5.2.1
  - saving current 13.43
  - setting character used to end and run 13.45
- SQL*Plus
  - command summary 13.1
  - continuing on additional lines 4.6.1.1, 13
  - ending 4.6.1, 13
  - entering and executing 4.6
  - entering during SQL command entry 13.45.58
  - obsolete command alternatives C.1
- stopping while running 4.8
- tabs 4.1
- types of 4.1
- variables that affect running 4.7
comments
- including in command files C.1
- including in scripts 5.3, 13.39, C.1
- using /*...*/ to create 5.3.2
- using REMARK C.1
- using REMARK to create 5.3.1, 13.39, C.1
- using -- to create 5.3.3
COMMIT clause 13.25
- WHENEVER OSERROR 13.56
- WHENEVER SQLERROR 13.57
COMMIT command 4.11
communication between tiers
COMPATIBILITY variable C.1, C.7
compilation errors 4.5.1, 13.46
COMPUTE command 7.2, 13.15
- computing a summary on different columns 7.2.8
- LABEL clause 7.2.6, 7.2.7, 13.15
- listing all definitions 7.2.9, 13.15
- maximum LABEL length 13.15
- OF clause 7.2.6
- ON 13.15
- ON column clause 7.2.6, 13.15
- ON expr clause 13.15
- ON REPORT clause 7.2.7, 13.15
- printing grand and sub summaries 7.2.7
- printing multiple summaries on same column 7.2.8
- printing summary lines at ends of reports 7.2.7
- printing summary lines on a break 7.2.6
- referencing a SELECT expression in OF 13.15
- referencing a SELECT expression in ON 13.15
- removing definitions 7.2.9, 13.13
- used to format a REFCURSOR variable 13.55
COMPUTES clause 13.13
CON_ID clause 13.46
CON_NAME clause 13.46
CONCAT variable 6.4, 13.45, 13.45.11
CONFIG command 13.16
configuration
- globalization support 12.1
configuring
- Oracle Net 2.2.5
- SQL*Plus 2
CONNECT / feature 3.1.1
CONNECT command 3.1, 13.17
- and @ (at sign) 13.17
- changing password 13.17, 13.33
- SYSASM clause 13.17
- SYSBACKUP clause 13.17
- SYSDBA clause 13.17
- SYSDG clause 13.17
- SYSKM clause 13.17
- SYSOPER clause 13.17
- SYSRAC clause 13.17
- username/password 13.17
connect identifier 13.17
- in CONNECT command 13.17
- in COPY command B.1
- in DESCRIBE command 13.20
- in SQLPLUS command 3.5.2
CONNECTION clause 13.46
connection identifier 3.2.2
- easy or abbreviated 3.2.1
- full 3.2.3
- net service name 3.2.3
CONTEXT variable 13.45
CONTEXT XQUERY option 13.45.76
CONTINUE clause
- WHENEVER OSERROR 13.56
- WHENEVER SQLERROR 13.57
continuing a long SQL*Plus command 4.6.1.1, 13
COPY command 13.18, B.1, B.2
- and @ (at sign) B.1, B.2.1
- and ARRAYSIZE variable B.1.2, B.2.3
- and COPYCOMMIT variable B.1.2, B.2.3
- and LONG variable B.1.2, B.2.3
- APPEND clause B.1.1, B.2.2
- copying data between databases B.2
- copying data between tables on one database B.3
- CREATE clause B.1.1, B.2.2
- creating a table B.1.1, B.2.2
- destination table B.1.1, B.2.1
- determining actions B.2.1
- determining source rows and columns B.1.1, B.2.1
- FROM clause B.2.1
- INSERT clause B.1.1, B.2.2
- inserting data in a table B.1.1, B.2.2
- interpreting messages B.2.3
- mandatory connect identifier B.1.1
- naming the source table with SELECT B.1.1, B.2.1
- query B.1.1, B.2.1
- referring to another user’s table B.2.4
- REPLACE clause B.1.1, B.2.2
- replacing data in a table B.1.1, B.2.2
- sample command B.2.1
- service name B.2.1, B.2.2, B.3
- specifying columns for destination B.1.1, B.2.1
- specifying the data to copy B.1.1, B.2.1
- TO clause B.2.1
- username/password B.1.1, B.2.1, B.2.2, B.3
- USING clause B.1.1, B.2.1
COPYCOMMIT variable 13.45, 13.45.12
- relationship to COPY command B.1.2, B.2.3
COPYTYPECHECK variable 13.45, 13.45.13
CREATE clause
- in COPY command B.1.1, B.2.2
CREATE command
- entering PL/SQL 4.5.1
creating a PLAN_TABLE 9.1.1
creating flat files 7.4.1
creating PLUSTRACE role 9.1.1
creating sample tables
CSV 8.1.2
- clause 3.5.1.6, 13.45.38
- option 3.5.1.6
csv, outputting reports 8.1
cursor variables 13.55

D

database
- administrator 11.1
- connect identifier 13.17
- mounting 13.50
- opening 13.50
database changes, saving automatically 13.45, 13.45.3
DATABASE clause 13.38
database files
- recovering 13.38
database name at startup 13.50
databases
- connecting to default 13.17
- connecting to remote 13.17
- copying data between B.1, B.2
- copying data between tables on a single B.3
- disconnecting without leaving SQL*Plus 3.1, 13.22
- mounting 11.2.1
- opening 11.2.1
- recovering 11.4, 13.38
- shutting down 11.2, 11.2.3
- starting 11.2
database schema 9.1.1
- DESCRIBE parameter 13.20
- SHOW 13.46
DATAFILE clause 13.38
DATE
- column definition from DESCRIBE 13.20
date, storing current in variable for titles 7.3.5, 13.14
DATE clause 13.5
DATE columns
- changing format 13.14
- default format 7.1.3.1
DB2 13.45.13
DBA 11.1
- mode 13.50
- privilege 13.50
DBMS_APPLICATION_INFO package 9.5.2, 13.45, 13.45.1
DBMS output 9.5.9, 13.45.50
DECLARE command
- PL/SQL 4.5
DEFAULT clause 13.5
DEFINE command 6.1, 13.19
- and system editor 5.1.1, 13.19.1
- and UNDEFINE command 6.1, 13.54
- CHAR values 13.19
- SET DEFINE ON|OFF 13.45, 13.45.14
- substitution variables 13.19
DEFINE variable
- See: substitution variable
DEL[ETE] clause 13.28
DEL command 5.2, 5.2.5, 13.21
- using an asterisk 5.2, 13.21
DELIMITER clause 13.45.38
DESCRIBE command (SQL*Plus) 4.2, 13.20
- connect_identifier 13.20
- PL/SQL properties listed by 13.20
- table properties listed by 13.20
disabling
- PL/SQL commands 10.1
- SQL*Plus commands 10.1
- SQL commands 10.1
DISCONNECT command 3.1, 13.22
DOCUMENT command C.1, C.4
- REMARK as newer version of C.4
DOCUMENT variable C.1, C.9
DUPLICATES clause 13.10

E

ECHO
- SET command 13.45.16
ECHO variable 5.4, 13.45, 13.45.16
EDIT clause 13.28
EDIT command 5.1.1, 13.19.1, 13.23
- creating scripts with 5.1.1
- defining _EDITOR 13.23
- modifying scripts 13.23
- setting default file name 13.45, 13.45.17
EDITFILE variable 13.45, 13.45.17
edition 3.5.2, 13.17
- in CONNECT command 13.17
- in SQLPLUS command 3.5.2
EDITOR operating system variable 13.19.1
Ed on UNIX 13.19.1
EMBEDDED variable 13.45, 13.45.18
entities, HTML 8.1.1.1
ENTMAP 3.5.1.6
ENTMAP clause 3.5.1.6, 8.1.1.1, 13.14
environment variables
- LD_LIBRARY_PATH 2.1
- LOCAL 2.1
- NLS_LANG 2.1
- ORA_EDITION 2.1
- ORA_NLS10 2.1
- ORACLE_HOME 2.1
- ORACLE_PATH 2.1
- ORACLE_SID 2.1
- PATH 2.1
- SQL*Plus 2.1
- SQLPATH 2.1
- TNS_ADMIN 2.1
- TWO_TASK 2.1
error
- SQL*Plus Instant Client unsupported charset D.1.2.1
ERRORLOGGING variable 13.45.20
errors
- compilation errors 4.5.1, 13.46
- making line containing current 5.2.2
escape characters, definition of 13.45, 13.45.21
ESCAPE variable 6.4, 13.45, 13.45.21
ESCCHAR variable 13.45.22
example
- CSV report 8.1.2
- interactive HTML report 8.1.1
EXECUTE command 13.24
executing
- a CREATE command 4.5.1
execution plan 9.1.2
execution statistics
- including in report 13.45.6
exit, conditional 13.56
EXIT clause
- WHENEVER OSERROR 13.56
- WHENEVER SQLERROR 13.57
EXIT command 3.4, 13.25
- ((colon))BindVariable clause 13.25
- COMMIT clause 13.25
- FAILURE clause 13.25
- in a script 13.49
- ROLLBACK clause 13.25
- use with SET MARKUP 8.1.1
- WARNING clause 13.25
EXITCOMMIT variable 13.45.23
extension 13.43, 13.45.62, 13.51

F

FAILURE clause 13.25
FEEDBACK variable 13.45, 13.45.24
file extensions 2.2.3, 13.43, 13.45.62, 13.51
file names
- in @ (at sign) command 13.2
- in @@ (double at sign) command 13.3
- in EDIT command 13.23
- in GET command 13.26
- in SAVE command 13.43
- in SPOOL command 7.4.2, 13.48
- in SQLPLUS command 3.5.3
files
- flat 7.4.1
FLAGGER variable 13.45, 13.45.25
flat file 7.4.1
FLUSH variable 9.5.5, 13.45, 13.45.26
FOLD_AFTER clause 13.14
FOLD_BEFORE clause 13.14
font
- changing face and size in command-line 1.2
footers
- aligning elements 13.41
- displaying at bottom of page 13.40
- displaying system-maintained values 13.41
- formatting elements 13.41
- indenting 13.41
- listing current definition 13.40
- setting at the end of reports 7.3
- suppressing definition 13.41
FORCE clause 13.50
FORMAT clause 13.5, 13.14
- in ATTRIBUTE command 13.9
- in COLUMN command 7.1.2.2, 7.1.3.2
- in REPHEADER and REPFOOTER commands 13.41
- in TTITLE and BTITLE commands 7.3.2, 13.53
format models, number 7.1.2.2, 13.14
formfeed, to begin a new page 7.3.6, 13.45.39
FROM clause 13.38, B.2.1

G

GET command 13.26
- LIST clause 13.26
- NOLIST clause 13.26
- retrieving scripts 13.26
globalization support
- Oracle10g 12.3
glogin 2.2.1
- See also: login.sql
- profile 13.45.57.1
- site profile 2.2, 2.2.1, 2.2.2.1, 3.5.1.10, 13.45.57.1

H

HEAD clause 3.5.1.6
headers
- aligning elements 7.3.1.1
- displaying at top of page 13.41
- displaying system-maintained values 13.41
- setting at the start of reports 7.3
- suppressing 7.3.1
HEADING clause 7.1.1.2, 13.14
headings
- aligning elements 13.41
- column headings 13.45.27
- formatting elements 13.41
- indenting 13.41
- listing current definition 13.41
- suppressing definition 13.41
HEADING variable 13.45.27
HEAD option 3.5.1.6
HEADSEP variable 13.45, 13.45.28
- use in COLUMN command 7.1.1.2
help
- installing command-line 2.2.4
- online 3.3.2, 13.27
HELP command, ? command 13.27
HIDE clause 13.5
HISTORY clause 13.46
HISTORY command 13.28
- CLEAR clause 13.28
- DEL[ETE] clause 13.28
- EDIT clause 13.28
- LIST clause 13.28
- RUN clause 13.28
HISTORY variable 13.45
HOST command 4.9, 13.29
HTML 8.1.1
- clause 3.5.1.6
- entities 8.1.1.1
- option 3.5.1.6
- spooling to file 3.5.1.6
- tag 8.1
hyphen
- continuing a long SQL*Plus command 4.6.1.1, 13

I

IMMEDIATE mode 13.47
infinity sign (~) 13.14
INIT.ORA file
- parameter file 13.50
initialization parameters
- displaying 13.46
input
- accepting [Return] 6.6.3
- accepting values from the user 6.6.1, 13.5
INPUT command 5.2, 5.2.4, 13.30
- entering several lines 13.30
INSERT clause B.1.1, B.2.2
installation
- SQL*Plus Instant Client D
- SQL*Plus Instant Client by copying D.1
- SQL*Plus Instant Client by download from OTN D.1
installation by copying D.1
installation by download from OTN D.1
instances
- shutting down 13.47
- starting 13.50
INSTANCE variable 13.45, 13.45.30
Instant Client
- SQL*Plus D
Instant Client packages D.1

J

Japanese 12.1
JUSTIFY clause 13.14

L

labels
- in COMPUTE command 7.2.6, 13.15
LABEL variable
- SHOW command C.1
language
- SQL*Plus Instant Client D.1.2
LD_LIBRARY_PATH
- environment variables 2.1
LEFT clause 7.3.1.1, 13.41, 13.53
lightweight OCI package D.1.2
LIKE clause 7.1.4, 13.9, 13.14
limits, SQL*Plus A
lines
- adding at beginning of buffer 13.30
- adding at end of buffer 13.30
- adding new after current 5.2.4, 13.30
- appending text to 5.2.3, 13.6
- changing width 7.3.6, 9.5.6, 13.45, 13.45.32
- deleting all in buffer 13.21
- deleting from buffer 5.2.5, 13.21
- determining which is current 5.2.2
- editing current 5.2.2
- listing all in buffer 5.2, 13.31
- removing blanks at end 13.45.67
LINESIZE variable 7.3.1.1, 7.3.6, 13.45, 13.45.32
LIST clause 13.7, 13.26, 13.28
LIST command 5.2, 13.31
- determining current line 5.2.2, 13.31
- making last line current 5.2.2, 13.31
- using an asterisk 5.2, 13.31
LNO clause 13.46
LOB data
- setting prefetch size 13.45
LOBOFFSET variable 13.45, 13.45.33
LOBPREFETCH clause 13.46
LOBPREFETCH variable 13.45
LOCAL
- environment variables 2.1
LOG_ARCHIVE_DEST parameter 13.7
LOGFILE clause 13.38
logging off
- conditionally 13.56, 13.57
- Oracle Database 3.1, 13.22
- SQL*Plus 3.4, 13.25
logging on
- Oracle Database 13.17
- SQL*Plus 3.3.1
login
- user profile 2.2.2.1
login.sql 2.2.2
LONG
- column definition from DESCRIBE 13.20
LONGCHUNKSIZE variable 7.1.3.1, 13.14, 13.45, 13.45.37, 13.45.38
LONG columns
- changing format 13.14
- default format 13.14
- setting maximum width 13.45, 13.45.36
- setting retrieval size 9.5.7, 13.45, 13.45.37
LONGRAW
- column definition from DESCRIBE 13.20
LONG variable 13.45, 13.45.36
- effect on COPY command B.1.2, B.2.3

M

MARKUP 3.5.1.6, 8.1, 13.45.38
- BODY clause 3.5.1.6
- DELIMITER clause 13.45.38
- ENTMAP clause 3.5.1.6
- HEAD clause 3.5.1.6
- PREFORMAT clause 3.5.1.6
- QUOTE clause 13.45.38
- TABLE clause 3.5.1.6
MAXDATA variable C.1, C.10
media recovery 13.50
message, sending to screen 6.6.1, 13.37
MOUNT clause 13.50
mounting a database 13.50

N

national language support 12.1
- See also: globalization support
NCHAR clause
- VARIABLE command 13.55
NCHAR columns
- changing format 13.14
- default format 7.1.3.1, 13.14
NCLOB clause
- VARIABLE command 13.55
NCLOB columns
- changing format 13.14
- default format 13.14
- setting maximum width 13.45, 13.45.36
- setting retrieval position 13.45, 13.45.33
- setting retrieval size 9.5.7, 13.45, 13.45.37
negative infinity sign (-~) 13.14
net service name 3.2.2, 3.2.3
NEW_VALUE clause 7.3.4, 13.14
- storing current date in variable for titles 13.14
NEWLINE clause 13.14
NEWPAGE command C.1, C.5
NEWPAGE variable 7.3.6, 13.45, 13.45.39
NLS 12.1
NLS_DATE_FORMAT 13.5, 13.14
NLS_LANG
- charset parameter for Instant Client D.1.2
- environment variables 2.1
- language parameter for Instant Client D.1.2
- SQL*Plus Instant Client D.1.2
- territory parameter for Instant Client D.1.2
NODE variable 13.45
NODE XQUERY option 13.45.75
NOLIST clause 13.26
NOLOG 3.2.4, 3.5.2
nolongontime 3.5.1.8
NOMOUNT clause 13.50
NONE clause
- WHENEVER OSERROR 13.56
- WHENEVER SQLERROR 13.57
NOPARALLEL clause 13.38
NOPRINT clause 7.2.6, 7.3.4, 9.5.1, 13.14
NOPROMPT clause 13.5
NORMAL mode 13.47
Notepad on Windows 13.19.1
NULL clause 13.14
null values
- setting text displayed 13.14, 13.45, 13.45.40
NULL variable 13.45, 13.45.40
NUMBER
- column definition from DESCRIBE 13.20
NUMBER clause 6.6.2
- VARIABLE command 13.55
NUMBER columns
- changing format 7.1.2.1, 13.14
- default format 7.1.2.1, 13.14
number formats
- $ 7.1.2.2
- 0 7.1.2.2
- 9 7.1.2.2
- comma 7.1.2.2
- setting default 6.4, 13.45, 13.45.41
NUMFORMAT clause
- in LOGIN.SQL 2.2.2.1
NUMFORMAT variable 13.45, 13.45.41
NUMWIDTH variable 13.45, 13.45.42
- effect on NUMBER column format 7.1.2.1, 13.14
NVARCHAR2 columns
- changing format 13.14
- default format 7.1.3.1, 13.14

O

objects, describing 13.45.15
obsolete commands
- BTITLE C.2
- COLUMN command DEFAULT clause C.3
- DOCUMENT C.1, C.4
- NEWPAGE C.1, C.5
- SET command BUFFER variable C.6
- SET command CLOSECURSOR variable C.1, C.8
- SET command COMPATIBILITY variable C.1, C.7
- SET command DOCUMENT variable C.1, C.9
- SET command MAXDATA variable C.1, C.10
- SET command SCAN variable C.1, C.11
- SET command SPACE variable C.1, C.12
- SET command TRUNCATE variable C.1, C.13
- SHOW command LABEL variable C.1
- TTITLE command old form C.14
OCI Instant Client D
OCI package
- basic D.1.1
- lightweight D.1.2
OERR
- command 13.32
OERR command 13.32
OF clause 7.2.6
OFF clause 13.14
- in ATTRIBUTE command 13.9
- in COLUMN command 7.1.6, 13.14
- in REPFOOTER commands 13.41
- in REPHEADER commands 13.41
- in SPOOL command 7.4, 13.48
- in TTITLE and BTITLE commands 7.3.3, 13.53
OLD_VALUE clause 7.3.4, 13.14
ON clause
- in ATTRIBUTE command 13.9
- in COLUMN command 7.1.6, 13.14
- in TTITLE and BTITLE commands 7.3.3
ON column clause
- in BREAK command 13.10
- in COMPUTE command 7.2.6, 13.15
ON expr clause
- in BREAK command 13.10
- in COMPUTE command 13.15
online help 3.3.2, 13.27
ON REPORT clause
- in BREAK command 7.2.7, 13.10
- in COMPUTE command 7.2.7, 13.15
ON ROW clause
- in BREAK command 7.2.3, 13.10
- in COMPUTE command 13.15
OPEN clause 13.50
opening a database 13.50
operating system
- editor 5.1.1, 13.19.1, 13.23
- file, loading into buffer 13.26
- running commands from SQL*Plus 4.9, 13.29
- text editor 5.1.1
ORA_EDITION
- environment variables 2.1
ORA_NLS10
- environment variables 2.1
ORACLE_HOME
- environment variables 2.1
ORACLE_PATH
- environment variables 2.1
ORACLE_SID
- environment variables 2.1
Oracle10g
- globalization support 12.3
Oracle Application Editions
- edition 3.5.2
Oracle Database Client D
Oracle Net
- configuring 2.2.5
- connect identifier 13.17
Oracle Session Editions
- edition 13.17
ORDER BY clause
- displaying column values in titles 7.3.4
- displaying values together in output 7.2
ORDERING variable 13.45
ORDERING XQUERY option 13.45.74
OUT clause 7.4.3, 13.48
output
- formatting white space in 9.5.11, 13.45.63
- pausing during display 4.10, 13.45.44

P

packages
- SQL*Plus and OCI for Instant Client D.1
PAGE clause 13.41
page number, including in titles 7.2.4, 7.3.2
pages
- changing length 7.3.6, 9.5.8, 13.45, 13.45.43
- default dimensions 7.3.6
- matching to screen or paper size 7.3.6
- setting dimensions 7.3.6
PAGESIZE clause
- in LOGIN.SQL 2.2.2.1
PAGESIZE variable 4.4, 7.3.6, 9.5.8, 13.45, 13.45.43
parameter 6.5, 13.2, 13.3, 13.49
- SQLPATH 2.1.1
parameter files (INIT.ORA files)
- specifying alternate 13.50
PARAMETERS clause 13.46
password
- changing with the PASSWORD command 13.33
- in CONNECT command 3.1, 13.17
- in COPY command B.2.1, B.2.2, B.3
- in SQLPLUS command 3.3.1, 3.5.2
- viewable warning 3.5.2
PASSWORD command 13.17, 13.33
PATH
- environment variables 2.1
PAUSE command 6.6.3, 13.34
PAUSE variable 4.10, 13.45, 13.45.44
PDBS clause 13.46
performance
- of SQL statements 9.1
- over dial-up lines 13.45.67
period (.)
- terminating PL/SQL blocks 4.5, 13.45, 13.45.7
PING
- command 13.35
PL/SQL 4.5
- blocks, PL/SQL 4.5
- executing 13.24
- formatting output in SQL*Plus 13.55
- listing definitions 4.3
- mode in SQL*Plus 4.5.1
- within SQL commands 4.5.1
PLAN_TABLE
- creating 9.1.1
- table 9.1.1
PLUGGABLE DATABASE clause 13.50
PLUSTRACE
- creating role 9.1.1
- role 9.1.1
PNO clause 13.46
pound sign (#) 13.14
predefined variable
- _CONNECT_IDENTIFIER 2.2.2.1, 13.19.1
- _DATE 13.19.1
- _EDITOR 5.1.1, 13.19.1, 13.23
- _O_RELEASE 13.19.1
- _O_VERSION 13.19.1
- _PRIVILEGE 13.19.1
- _RC 13.29
- _SQLPLUS_RELEASE 13.19.1
- _USER 13.19.1
PREFORMAT 3.5.1.6
PREFORMAT clause 3.5.1.6
PRINT clause 13.14
PRINT command 13.36
printing
- bind variables automatically 13.45.4
- REFCURSOR variables 13.55
- SPOOL command 13.48
prompt
- SET SQLPROMPT 9.5.10, 13.45, 13.45.59
PROMPT clause 6.6.1, 13.5
PROMPT command 6.6.1, 13.37
- customizing prompts for value 6.6.2
prompts for value
- bypassing with parameters 6.5
- customizing 6.6.2
- through ACCEPT 6.6.1
- through substitution variables 6.3.1

Q

queries
- in COPY command B.1.1, B.2.1
- show number of records retrieved 4.4, 13.45, 13.45.24
- tracing 9.3, 9.4
query execution path
- including in report 13.45.6
query results
- displaying on-screen 4.4
- sending to a printer 7.4.3, 13.48
- storing in a file 7.4.2, 13.48
QUIT command 13.25, 13.49
- See also: EXIT
QUOTE clause 13.45.38

R

RAW
- column definition from DESCRIBE 13.20
record separators, printing 7.1.7, 13.45, 13.45.46
RECOVER clause 13.50
RECOVER command 13.38
- and database recovery 11.4
- AUTOMATIC clause 13.38
- CANCEL clause 13.38
- CONTINUE clause 13.38
- DATABASE clause 13.38
- FROM clause 13.38
- LOGFILE clause 13.38
- NOPARALLEL clause 13.38
- SNAPSHOT TIME date clause 13.38
- STANDBY DATABASE clause 13.38
- STANDBY DATAFILE clause 13.38
- STANDBY TABLESPACE clause 13.38
- UNTIL CANCEL clause 13.38
- UNTIL CONTROLFILE clause 13.38
- UNTIL TIME clause 13.38
- USING BACKUP CONTROL FILE clause 13.38
recovery
- RECOVER command 13.38
RECSEPCHAR variable 7.1.7, 13.45, 13.45.46
RECSEP variable 7.1.7, 13.45, 13.45.46
REFCURSOR bind variables
- in a stored function 6.8
REFCURSOR clause
- VARIABLE command 13.55
registry
- editor 2.1.1
registry entry
- SQLPATH 2.1, 2.1.1
RELEASE clause 13.46
REMARK command 5.3.1, 13.39
removing sample tables
REPFOOTER clause 13.46
REPFOOTER command 7.3.1, 13.40
- aligning footer elements 13.41
- BOLD clause 13.41
- CENTER clause 13.41
- COL clause 13.41
- FORMAT clause 13.41
- indenting report footers 13.41
- LEFT clause 13.41
- OFF clause 13.41
- RIGHT clause 13.41
- SKIP clause 13.41
- suppressing current definition 13.41
- TAB clause 13.41
REPHEADER clause 13.46
REPHEADER command 7.3.1, 13.41
- aligning header elements 7.3.1.1
- aligning heading elements 13.41
- BOLD clause 13.41
- CENTER clause 13.41
- COL clause 13.41
- FORMAT clause 13.41
- indenting headings 13.41
- LEFT clause 13.41
- OFF clause 13.41
- PAGE clause 13.41
- RIGHT clause 13.41
- SKIP clause 13.41
- suppressing current definition 13.41
- TAB clause 13.41
REPLACE clause
- in COPY command B.1.1, B.2.2
- in SAVE command 13.43, 13.48
reports
- autotrace 9.1.1
- breaks 13.10
- clarifying with spacing and summary lines 7.2
- columns 13.14
- creating bottom titles 7.3, 13.11, C.1
- creating footers 13.40
- creating headers 13.41
- creating headers and footers 7.3
- creating primary/detail 7.3.4, 13.14
- creating top titles 7.3, 13.53, C.1
- csv 8.1
- CSV example 8.1.2
- displaying 13.45, 13.45.6
- formatting column headings 7.1.1.2, 13.14
- formatting columns 7.1.2.1, 7.1.3.1, 13.14
- interactive HTML example 8.1.1
- on the web 8.1
- SILENT mode 8.1.3
- starting on a new page 13.45.18
- title 13.53, C.1
RESTRICT 3.5.1.10, 10.3, 13.50
return code, specifying 5.6, 13.25, 13.57
RIGHT clause 7.3.1.1, 13.41, 13.53
roles 10.2
- disabling 10.2.2
- re-enabling 10.2.2
ROLLBACK clause 13.25
- WHENEVER OSERROR 13.56
- WHENEVER SQLERROR 13.57
row data
- setting prefetch size 13.45
ROWID
- column definition from DESCRIBE 13.20
ROWPREFETCH clause 13.46
ROWPREFETCH variable 13.45
rows
- performing computations on 7.2.6, 13.15
- setting number retrieved at one time 9.5.3, 13.45, 13.45.2
- setting the number after which COPY commits 13.45.12
RUN clause 13.28
RUN command 13.42
- executing current PL/SQL block 4.5
- making last line current 5.2.2
- similar to / (slash) command 13.42

S

sample schemas , ,
- see Oracle Database Sample Schemas guide
- using HR in COLUMN example 13.14
- using HR in examples 5, 7
sample tables
- access to
- creating
- removing
- unlocking
SAVE command 13.43
- APPEND clause 13.43
- CREATE clause 13.43
- REPLACE clause 13.43
- storing commands in scripts 13.43
- using with INPUT to create scripts 5.1.1
saving environment attributes 13.51
SCAN variable C.1, C.11
schemas
- database 9.1.1
- DESCRIBE parameter 13.20
- HR sample
- installing own copy of HR
- sample
- SHOW parameter 13.46
- unlocking HR
- using HR in COLUMN example 13.14
- using HR in examples 5, 7
SCREEN clause 6.6.4, 13.13
screens
- clearing 6.6.4, 13.13
scripts
- extension 13.43, 13.45.62, 13.51
- registering 9.5.2
scripts, authenticating users in 3.1.1
SECUREDCOL variable 13.45.49
security
- changing password 13.33
- nolongontime 3.5.1.8
- password viewable 3.5.2
- RESTRICT 3.5.1.10, 10.3
SELECT command
- and BREAK command 7.2, 13.10
- and COLUMN command 13.14
- and COMPUTE command 7.2
- and COPY command B.1.1, B.2.1
- and DEFINE command 13.19
- and ORDER BY clause 7.2
- formatting results 6.8, 6.9
semicolon (;)
- in PL/SQL blocks 4.5
- in SQL*Plus commands 4.6.1, 13
- in SQL commands 4.4, 4.4.1.2
- not stored in buffer 5.2.1
SERVEROUTPUT variable 13.45.50
service name
- in COPY command B.2.1, B.2.2, B.3
Session Editions 13.17
SET AUTOTRACE 9.1.1
SET clause 13.51
SET command 2.2.3, 4.7, 13.44, 13.45
- APPINFO variable 9.5.2, 13.45.1
- ARRAYSIZE variable 9.5.3, 13.45, 13.45.2, B.2.3
- AUTOCOMMIT variable 13.45, 13.45.3
- AUTOPRINT variable 13.45, 13.45.4, 13.55
- AUTORECOVERY variable 13.45, 13.45.5
- AUTOTRACE variable 13.45.6
- BLOCKTERMINATOR variable 13.45, 13.45.7
- BUFFER variable C.6
- CLOSECURSOR variable C.1, C.8
- CMDSEP variable 13.45, 13.45.8
- COLINVISIBLE variable 13.45.9
- COLSEP variable 7.4.1, 13.45, 13.45.10
- COMPATIBILITY variable C.1, C.7
- CONCAT variable 6.4, 13.45, 13.45.11
- COPYCOMMIT variable 13.45, 13.45.12, B.2.3
- COPYTYPECHECK variable 13.45, 13.45.13
- DEFINE clause 6.4
- DEFINE variable 13.45
- DESCRIBE variable 13.45, 13.45.15
- DOCUMENT variable C.1, C.9
- ECHO variable 13.45, 13.45.16
- EDITFILE variable 13.45, 13.45.17
- EMBEDDED variable 13.45, 13.45.18
- ERRORDETAILS variable 13.45
- ERRORLOGGING variable 13.45.20
- ESCAPE variable 6.4, 13.45, 13.45.21
- ESCCHAR variable 13.45.22
- EXITCOMMIT variable 13.45.23
- FEEDBACK variable 13.45, 13.45.24
- FLAGGER variable 13.45, 13.45.25
- FLUSH variable 9.5.5, 13.45, 13.45.26
- HEADING variable 13.45.27
- HEADSEP variable 7.1.1.2, 13.45, 13.45.28
- HISTORY variable 13.45
- INSTANCE variable 13.45, 13.45.30
- LINESIZE variable 7.3.1.1, 7.3.6, 13.45, 13.45.32
- LOBOFFSET variable 13.45, 13.45.33
- LOBPREFETCH variable 13.45
- LOGSOURCE variable 13.45, 13.45.35
- LONGCHUNKSIZE variable 13.45, 13.45.37
- LONG variable 13.45, 13.45.36, B.2.3
- MARKUP clause 13.45.38
- MAXDATA variable C.1, C.10
- NEWPAGE variable 7.3.6, 13.45, 13.45.39
- NULL variable 13.45, 13.45.40
- NUMFORMAT clause 2.2.2.1
- NUMFORMAT variable 13.45, 13.45.41
- NUMWIDTH variable 7.1.2.1, 13.14, 13.45, 13.45.42
- PAGESIZE clause 2.2.2.1
- PAGESIZE variable 4.4, 7.3.6, 9.5.8, 13.45, 13.45.43
- PAUSE variable 13.45, 13.45.44
- RECSEPCHAR variable 7.1.7, 13.45, 13.45.46
- RECSEP variable 7.1.7, 13.45, 13.45.46
- ROWPREFETCH variable 13.45
- SCAN variable C.1, C.11
- SECUREDCOL variable 13.45.49
- SERVEROUTPUT variable 13.45.50
- SHIFTINOUT variable 13.45, 13.45.51
- SPACE variable C.1, C.12
- SQLBLANKLINES variable 13.45.53
- SQLCASE variable 13.45, 13.45.54
- SQLCONTINUE variable 13.45, 13.45.55
- SQLNUMBER variable 13.45, 13.45.56
- SQLPLUSCOMPATIBILITY variable 13.45, 13.45.57
- SQLPREFIX variable 13.45, 13.45.58
- SQLPROMPT variable 9.5.10, 13.45, 13.45.59
- SQLTERMINATOR variable 13.45, 13.45.60
- STATEMENTCACHE variable 13.45
- substitution variable 13.45.14
- SUFFIX variable 13.45, 13.45.62
- TAB variable 9.5.11, 13.45, 13.45.63
- TERMOUT variable 9.5.12, 13.45, 13.45.64
- TIME variable 13.45, 13.45.65
- TIMING variable 13.45, 13.45.66
- TRIMOUT variable 13.45, 13.45.67
- TRIMSPOOL variable 13.45, 13.45.68
- TRUNCATE variable C.1, C.13
- UNDERLINE variable 13.45, 13.45.69
- used to format a REFCURSOR variable 13.55
- VERIFY clause 6.3.1
- VERIFY variable 6.4, 13.45, 13.45.70
- WRAP variable 7.1.3.2, 13.45, 13.45.71
- XMLOPTIMIZATIONCHECK variable 13.45, 13.45.72
- XQUERY BASEURI variable 13.45
- XQUERY CONTEXT variable 13.45
- XQUERY NODE variable 13.45
- XQUERY ORDERING variable 13.45
SET ERRORDETAILS
- command 13.45.19
SET HISTORY command 13.45.29
SET LOBPREFETCH command 13.45.34
SET MARKUP
- BODY clause 3.5.1.6
- CSV 3.5.1.6, 13.45.38
- CSV example 8.1.2
- DELIMITER clause 13.45.38
- ENTMAP clause 3.5.1.6, 8.1.1.1
- HEAD clause 3.5.1.6
- HTML 3.5.1.6
- interactive HTML example 8.1.1
- PREFORMAT clause 3.5.1.6
- QUOTE clause 13.45.38
- TABLE clause 3.5.1.6
SET ROWPREFETCH command 13.45.48
SET STATEMENTCACHE command 13.45.61
SET system variable summary 13.45
SET variables 4.7
- See: system variables
SET XQUERY BASEURI 13.45.73
SET XQUERY CONTEXT 13.45.76
SET XQUERY NODE 13.45.75
SET XQUERY ORDERING 13.45.74
SGA clause 13.46
SHIFTINOUT variable 13.45, 13.45.51
SHOW
- schema parameter 13.46
SHOW clause 13.52
SHOW command 4.7, 13.46
- ALL clause 13.46
- BTITLE clause 13.46
- CON_ID clause 13.46
- CON_NAME clause 13.46
- CONNECTION clause 13.46
- ERRORS clause 13.46
- HISTORY clause 13.46
- LABEL variable C.1
- listing current page dimensions 7.3.6
- LNO clause 13.46
- LOBPREFETCH clause 13.46
- PDBS clause 13.46
- PNO clause 13.46
- RELEASE clause 13.46
- REPFOOTER clause 13.46
- REPHEADER clause 13.46
- ROWPREFETCH clause 13.46
- SPOOL clause 13.46
- SQLCODE clause 13.46
- STATEMENTCACHE clause 13.46
- TTITLE clause 13.46
- USER clause 13.46
- XQUERY clause 13.46
SHOWMODE variable 13.45, 13.45.52
SHUTDOWN command 13.47
- ABORT 13.47
- IMMEDIATE 13.47
- NORMAL 13.47
- TRANSACTIONAL LOCAL 13.47
site profile
- glogin 2.2, 2.2.1, 2.2.2.1, 3.5.1.10, 13.45.57.1
SKIP clause
- in BREAK command 7.2.2, 7.2.3, 13.10
- in REPHEADER and REPFOOTER commands 13.41
- in TTITLE and BTITLE commands 7.3.1.1, 13.53
- used to place blank lines before bottom title 7.3.1.1
SKIP PAGE clause 7.2.2, 7.2.3, 13.10
slash (/) command 13.4
- files loaded with GET command 13.26
SPACE variable C.1, C.12
SPOOL clause 3.5.1.6, 13.46
SPOOL command 7.3.6, 13.48
- APPEND clause 13.48
- CREATE clause 13.48
- file name 7.4.2, 13.48
- OFF clause 7.4, 13.48
- OUT clause 7.4.3, 13.48
- REPLACE clause 13.48
- to HTML file 3.5.1.6
- turning spooling off 7.4, 13.48
- use with SET MARKUP 8.1.1
SQL.PNO, referencing in report titles 7.3.2
SQL.SQLCODE
- using in EXIT command 13.25
SQL*Plus
- command history 13.28
- command prompt 3.3.1
- command summary 13.1
- configuring globalization support 12.1
- configuring Oracle Net 2.2.5
- database administration 11.1
- environment variables 2.1
- execution plan 9.1.2
- exiting 3.4, 13.25
- limits A
- obsolete command alternatives C.1
- setting up environment 2.2
- starting 3.3, 3.3.1, 3.5
- statistics 9.1.3
- system variables affecting performance 9.5
- tuning 9.1
- who can use
SQL*Plus and OCI packages D.1
SQL*Plus command-line vs SQL*Plus Instant Client D
SQL*Plus Instant Client D, D.1
- basic D.1.1
- installation D
- lightweight D.1.2
- NLS_LANG D.1.2
- NLS_LANG charset parameter D.1.2
- NLS_LANG language parameter D.1.2
- NLS_LANG territory parameter D.1.2
- unsupported charset error D.1.2.1
SQLBLANKLINES variable 13.45, 13.45.53
SQLCASE variable 13.45, 13.45.54
SQL clause 13.13
SQLCODE clause 13.46
- SHOW command 13.46
SQLCONTINUE variable 13.45, 13.45.55
SQL DML statements
- reporting on 13.45, 13.45.6
SQLNUMBER variable 13.45, 13.45.56, 13.45.57
SQL optimizer 9.1.2
SQLPATH
- environment variables 2.1
- registry entry 2.1, 2.1.1
SQLPLUS command 3.3.1
- -? clause 3.5.1.2
- /NOLOG clause 3.5.2
- and @ (at sign) 3.5
- and EXIT FAILURE 3.4
- Application Editions 3.5.2
- BODY option 3.5.1.6
- - clause 3.5.1.1, 3.5.1.9
- commands
  - SQLPLUS 3.5
- connect identifier 3.5.2
- CSV option 3.5.1.6
- display syntax 3.5.1.1
- edition 3.5.2
- ENTMAP option 3.5.1.6
- HEAD option 3.5.1.6
- HTML option 3.5.1.6
- -MARKUP clause 3.5.1.6, 13.45.38
- -MARKUP option 3.5.1.6
- nolongontime 3.5.1.8
- PREFORMAT option 3.5.1.6
- RESTRICT 3.5.1.10, 10.3
- service name 3.5.2
- -SILENT clause 3.5.1.11
- -SILENT option 3.5.1.11, 8.1.3
- SPOOL clause 3.5.1.6
- syntax 3.5
- SYSASM clause 3.5.2
- SYSBACKUP clause 3.5.2
- SYSDBA clause 3.5.2
- SYSDG clause 3.5.2
- SYSKM clause 3.5.2
- SYSOPER clause 3.5.2
- SYSRAC clause 3.5.2
- TABLE option 3.5.1.6
- unsuccessful connection 3.4
- username/password 3.3.1, 3.5.2
SQLPREFIX variable 13.45, 13.45.58
SQLPROMPT variable 9.5.10, 13.45, 13.45.59
SQLTERMINATOR variable 13.29, 13.45, 13.45.53, 13.45.60
STANDBY DATAFILE clause 13.38
STANDBY TABLESPACE clause 13.38
START clause 13.52
START command 5.4, 13.49
- arguments 6.5
- passing parameters to a script 6.5
- script 5.4, 13.49
- similar to @ (at sign) command 5.4, 13.2, 13.49
- similar to @@ (double at sign) command 13.49
starting
- SQL*Plus 1.1, 3.3, 3.3.1
STARTUP command 13.50
- DOWNGRADE clause 13.50
- FORCE clause 13.50
- MOUNT clause 13.50
- NOMOUNT clause 13.50
- OPEN clause 13.50
- PFILE clause 13.50
- PLUGGABLE DATABASE clause 13.50
- RECOVER clause 13.50
- RESTRICT clause 13.50
- specifying a database 13.50
- UPGRADE clause 13.50
statement cache
- setting size 13.45
STATEMENTCACHE clause 13.46
STATEMENTCACHE variable 13.45
statistics 9.1.3
- collecting TIMING statistics 9.2
STOP clause 13.52
stop query 4.8
STORE command 2.2.3, 13.51
- SET clause 13.51
stored functions 6.8
stored procedures
- creating 4.5.1
subkey, registry 2.1.1
substitution variables 6.1, 6.3, 6.4, 13.45, 13.45.14
- _EDITOR 13.19.1
- appending characters immediately after 6.3.1
- concatenation character 13.45, 13.45.11
- DEFINE command 13.19
- defining 6.1, 13.19
- deleting 6.1, 13.54
- displaying in headers and footers 13.41
- displaying in titles 13.53
- in ACCEPT command 6.6.1, 13.5
- listing definitions 6.1, 13.19
- parsing 9.5.4
- prefixing 13.45.14, C.1
- related system variables 6.4
- restrictions 6.3.4
- system variables used with 6.4
- undefined 6.3.1
- where and how to use 6.3.1
SUFFIX variable 13.45, 13.45.62
- used with EDIT command 13.23
- used with GET command 13.26
- used with SAVE command 13.43
- used with START command 13.49
SUM function 7.2.6
summary lines
- computing and printing 7.2.6, 13.15
- computing and printing at ends of reports 7.2.7
- computing same type on different columns 7.2.8
- printing grand and sub summaries (totals) 7.2.7
- printing multiple on same break column 7.2.8
syntax
- COPY command B.2.1
syntax rules
- SQL*Plus commands 4.6.1
- SQL commands 4.4.1
SYSASM clause 3.5.2, 13.17
SYSBACKUP clause 3.5.2, 13.17
SYSDBA clause 3.5.2, 13.17
SYSDG clause 3.5.2, 13.17
SYSKM clause 3.5.2, 13.17
SYSOPER clause 3.5.2, 13.17
SYSRAC clause 3.5.2, 13.17
system-maintained values
- displaying in headers and footers 13.41
- displaying in titles 7.3.2, 13.53
- formatting in titles 7.3.2
system variables 4.7, 13.44
- affecting SQL*Plus performance 9.5
- affecting substitution variables 6.4
- listing current settings 4.7, 13.46
- listing old and new values 13.45, 13.45.52
- storing and restoring 2.2.3
- summary of SET commands 13.45

T

TAB clause 13.41, 13.53
TABLE clause 3.5.1.6
TABLE option 3.5.1.6
tables
- access to sample
- controlling destination when copying B.1.1, B.2.2
- copying values between B.2, B.3
- listing column definitions 4.2, 13.20
- referring to another user’s when copying B.2.4
TABLESPACE clause 13.38
tablespaces, recovering 13.38
TAB variable 9.5.11, 13.45, 13.45.63
tag, HTML 8.1
TERMOUT variable 9.5.12, 13.45, 13.45.64
- using with SPOOL command 13.48
territory
- SQL*Plus Instant Client D.1.2
text 3.5.1.6
- adding to current line with APPEND 5.2.3, 13.6
- changing old to new with CHANGE 5.2.2, 13.12
- clearing from buffer 5.2, 13.13
text editor
- operating system 5.1.1, 13.23
TIME variable 13.45, 13.45.65
TIMING clause 13.13
TIMING command 9.2, 13.52
- deleting all areas created by 13.13
- deleting current area 13.52
- SHOW clause 13.52
- START clause 13.52
- STOP clause 13.52
TIMING variable 13.45, 13.45.66
titles
- aligning elements 7.3.1.1, 13.53
- displaying at bottom of page 7.3, 13.11, C.1
- displaying at top of page 7.3, 13.53, C.1
- displaying column values 7.3.4, 13.14
- displaying current date 7.3.5, 13.14
- displaying page number 7.3.2, 13.53
- displaying system-maintained values 7.3.2, 13.53
- formatting elements 13.53
- formatting system-maintained values in 7.3.2
- indenting 7.3.1.2, 13.53
- listing current definition 7.3.3, 13.11, 13.53
- restoring definition 7.3.3
- setting at start or end of report 7.3
- setting lines from top of page to top title 7.3.6, 13.45, 13.45.39, C.1
- setting lines from top title to end of page 9.5.8, 13.45, 13.45.43
- setting top and bottom 7.3, 13.11, 13.53, C.1
- spacing between last row and bottom title 7.3.1.1
- suppressing definition 7.3.3, 13.53
TNS_ADMIN
- environment variables 2.1
TO clause B.2.1
tracing queries 9.3, 9.4
tracing statements
- for performance statistics 9.1.3
- for query execution path 9.1.3
- with parallel query option 9.3
TRIMOUT variable 13.45, 13.45.67
TRIMSPOOL variable 13.45, 13.45.68
TRUNCATED clause 7.1.3.2, 13.14
TRUNCATE variable C.1, C.13
TTITLE clause 13.46
TTITLE command 7.3.1, 13.53
- aligning title elements 7.3.1.1, 13.53
- BOLD clause 13.53
- CENTER clause 7.3.1.1, 13.53
- COL clause 7.3.1.2, 13.53
- FORMAT clause 7.3.2, 13.53
- indenting titles 7.3.1.2, 13.53
- LEFT clause 7.3.1.1, 13.53
- listing current definition 7.3.3, 13.53
- OFF clause 7.3.3, 13.53
- old form C.14
- ON clause 7.3.3
- referencing column value variable 7.3.4, 13.14
- restoring current definition 7.3.3
- RIGHT clause 7.3.1.1, 13.53
- SKIP clause 7.3.1.1, 13.53
- suppressing current definition 7.3.3, 13.53
- TAB clause 13.53
tuning
- SET APPINFO OFF 9.5.2
- SET ARRAYSIZE 9.5.3
- SET DEFINE OFF 9.5.4
- SET FLUSH OFF 9.5.5
- SET TRIMOUT ON 9.5.13
- SET TRIMSPOOL ON 9.5.13
- SQL*Plus 9.1
- system variables 9.5
TWO_TASK
- environment variables 2.1

U

UNDEFINE command 6.1, 13.54
- and DEFINE command 13.19
UNDERLINE variable 13.45, 13.45.69
unicode 12.1
UNIX
- ed 13.19.1
unlocking sample tables
UNTIL CANCEL clause 13.38
UNTIL CHANGE clause 13.38
UNTIL CONTROLFILE clause 13.38
UNTIL TIME clause 13.38
USER clause 13.46
username 3.1
- connecting under different 3.1, 13.17
- in CONNECT command 3.1, 13.17
- in COPY command B.2.1, B.2.2, B.3
- in SQLPLUS command 3.3.1, 3.5.2
user profile 2.2.2
- See also: site profile
- glogin.sql 2.2.2
- login.sql 2.2.2, 2.2.2.1
user variable
- See: substitution variable
USING BACKUP CONTROL FILE clause 13.38
USING clause B.1.1, B.2.1
UTF-8 12.1

V

V$SESSION virtual table 13.45.1
V$SQLAREA virtual table 13.45.1
VARCHAR2
- column definition from DESCRIBE 13.20
VARCHAR2 clause
- VARIABLE command 13.55
VARCHAR2 columns
- changing format 13.14
- default format 7.1.3.1
VARCHAR columns
- default format 7.1.3.1
VARIABLE command 13.55
- BINARY_DOUBLE clause 13.55
- BINARY_FLOAT clause 13.55
- BOOLEAN clause 13.55
- CHAR clause 13.55
- CLOB clause 13.55
- NCHAR clause 13.55
- NCLOB clause 13.55
- NUMBER clause 13.55
- REFCURSOR clause 13.55
- value clause 13.55
- VARCHAR2 clause 13.55
- variable clause 13.55
- VECTOR clause 13.55
variables
- bind variables 6.7
- substitution variables 13.19
- system variables 4.7
VECTOR clause
- VARIABLE command 13.55
VERIFY clause 6.3.1
VERIFY variable 6.4, 13.45, 13.45.70

W

WARNING clause 13.25
web, outputting reports 8.1
web browser 8.1.1
WHENEVER OSERROR command 13.56
- COMMIT clause 13.56
- CONTINUE clause 13.56
- EXIT clause 13.56
- NONE clause 13.56
- ROLLBACK clause 13.56
WHENEVER SQLERROR command 13.57
- COMMIT clause 13.57
- CONTINUE clause 13.57
- EXIT clause 13.57
- NONE clause 13.57
- ROLLBACK clause 13.57
Windows
- notepad 13.19.1
WORD_WRAPPED clause 7.1.3.2, 7.1.7, 13.14
WRAPPED clause 7.1.3.2, 13.14
WRAP variable 7.1.3.2, 13.45, 13.45.71

X

XMLOPTIMIZATIONCHECK variable 13.45, 13.45.72
XMLType
- column definition from DESCRIBE 13.20
- column formatting 7.1.3.2
- column width 7.1.3.1
- creating 7.1.3.2
- formatting in reports 7.1.3
- inserting values 7.1.3.2
- selecting data 7.1.3.2
- setting column retrieval size 9.5.7, 13.45.37
- setting maximum column width 13.45.36
XQUERY clause 13.46
XQUERY command 13.58
XQUERY options
- BASEURI 13.45.73
- CONTEXT 13.45.76
- NODE 13.45.75
- ORDERING 13.45.74