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, 12.17.1
_DATE predefined variable 12.17.1
_EDITOR, in EDIT command 5.1.1, 12.17.1, 12.21
_EDITOR predefined variable 5.1.1, 12.17.1, 12.21
_EDITOR substitution variable 12.17.1
_O_RELEASE predefined variable 12.17.1
_O_VERSION predefined variable 12.17.1
_PRIVILEGE predefined variable 12.17.1
_RC predefined variable 12.27
_SQLPLUS_RELEASE predefined variable 12.17.1
_USER predefined variable 12.17.1
; (semicolon) 4.4, 5.2, 12.29
/*...*/ (comment delimiters) 5.3.2
~ infinity sign 12.13
-~ negative infinity sign 12.13
((amp))((amp)) 5.9.2
((amp)) (ampersand)
- disabling substitution variables 5.9.4
- substitution variables 5.9
((colon)) (colon)
- bind variables 5.12
((colon))BindVariable clause
- EXIT command 12.23
((nbsp))/ (slash) command
- default logon 3.5.2, 12.15
- entered at buffer line-number prompt 4.4.1.2, 12.4
- entered at command prompt 12.4
- executing current PL/SQL block 4.5
- similar to RUN 12.4, 12.38
- usage 12.4
((nbsp)). (period) 4.5
((nbsp))-- (comment delimiter) 5.3.3
((nbsp))- (hyphen)
- clause 3.5.1.1
- continuing a long SQL*Plus command 4.6.1.1, 12
@ (at sign)
- command 2.2.3.1, 5.4, 12.2
- command arguments 12.2, 12.3
- in CONNECT command 12.15
- in COPY command B.1, B.2.1
- in SQLPLUS command 3.5
- passing parameters to a script 12.2, 12.3
- script 5.4, 12.2
- similar to START 5.4, 12.45
@@ (double at sign) command 2.2.3.1, 12.3
- script 12.3
- similar to START 12.3, 12.45
@ at sign)
- similar to START 12.2
$ number format 6.1.2.2
* (asterisk)
- in DEL command 5.2, 12.18
- in LIST command 5.2, 12.29
# pound sign
- overflow indication 12.13
- SET SQLPREFIX character 12.41.56
-MARKUP 3.5.1.6, 7.1
- SQLPLUS command clause 3.5.1.6, 12.41.36
-SILENT option 3.5.1.10, 7.1.3

Numerics

0, number format 6.1.2.2
9, number format 6.1.2.2

A

ABORT mode 12.43
abort query 4.8
ACCEPT command 5.11.1, 12.5
- and DEFINE command 12.17
- BINARY_DOUBLE clause 12.5, 12.51
- BINARY_FLOAT clause 12.5, 12.51
- customizing prompts for value 5.11.2
- DATE clause 12.5
- DEFAULT clause 12.5
- FORMAT clause 12.5
- HIDE clause 12.5
- NOPROMPT clause 12.5
- NUMBER clause 5.11.2
- PROMPT clause 5.11.1, 12.5
alias 3.2.2
ALIAS clause 12.13
- in ATTRIBUTE command 12.8
ALL clause 12.42
ampersands (((amp)))
- in parameters 5.10, 12.2, 12.3, 12.45
- substitution variables 5.9
APPEND clause
- in COPY command B.1.1, B.2.2
- in SAVE command 12.39, 12.44
APPEND command 5.2, 5.2.3, 12.6
APPINFO clause 8.5.2, 12.41.1
ARCHIVE LOG
- command 10.3.1, 12.7
- mode 10.3.1
argument
- in START command 5.10
ARRAYSIZE variable 8.5.3, 12.41, 12.41.2
- relationship to COPY command B.1.2, B.2.3
ATTRIBUTE command 12.8
- ALIAS clause 12.8
- and CLEAR COLUMN command 12.8
- CLEAR clause 12.8
- clearing columns 12.12, 12.13
- controlling display characteristics 12.8
- display characteristics 12.8
- entering multiple 12.8
- FORMAT clause 12.8
- LIKE clause 12.8
- listing attribute display characteristics 12.8
- OFF clause 12.8
- ON clause 12.8
- restoring column display attributes 12.8
- suppressing column display attributes 12.8
AUTOCOMMIT variable 4.11, 12.41, 12.41.3
AUTOMATIC clause 12.34
AUTOPRINT variable 12.41, 12.41.4
AUTORECOVERY variable 12.41, 12.41.5
autotrace report 8.1.1
AUTOTRACE variable 8.1.1, 12.41.6

B

background process
- startup after abnormal termination 12.43
BASEURI variable 12.41
BASEURI XQUERY option 12.41.71
basic OCI package D.1.1
batch jobs, authenticating users in 3.1.1
batch mode 12.23
BEGIN command 4.5
BINARY_DOUBLE clause
- ACCEPT command 12.5, 12.51
- VARIABLE command 12.51
BINARY_FLOAT clause
- ACCEPT command 12.5, 12.51
- VARIABLE command 12.51
bind variables 5.12
- creating 12.51
- displaying 12.32
- displaying automatically 12.41.4, 12.51
- in PL/SQL blocks 12.51
- in SQL statements 12.51
- in the COPY command 12.51
blank line
- in PL/SQL blocks 4.5
- in SQL commands 4.4.1.2
- preserving in SQL commands 12.41, 12.41.51
BLOB
- column width 6.1.3.1
- formating in reports 6.1.3
BLOB columns
- default format 12.13
- setting maximum width 12.41, 12.41.34
- setting retrieval position 12.41, 12.41.31
- setting retrieval size 8.5.7, 12.41, 12.41.35
blocks, PL/SQL
- continuing 4.5
- editing in buffer 5.2
- editing with system editor 5.1, 12.21
- entering and executing 4.5
- listing current in buffer 5.2.1
- saving current 12.39
- setting character used to end 12.41, 12.41.7
- stored in SQL buffer 4.5
- timing statistics 12.41.64
- within SQL commands 4.5.1
BLOCKTERMINATOR 12.41, 12.41.7, 12.41.51, 12.41.58
BODY clause 3.5.1.6
BODY option 3.5.1.6
BOLD clause 12.37, 12.49
break columns 6.2, 12.9
- inserting space when value changes 6.2.2
- specifying multiple 6.2.4
- suppressing duplicate values in 6.2.1
BREAK command 6.2, 12.9
- and SQL ORDER BY clause 6.2, 6.2.1, 6.2.4, 12.9
- clearing BREAKS 6.2.5
- displaying column values in titles 6.3.4
- DUPLICATES clause 12.9
- inserting space after every row 6.2.3
- inserting space when break column changes 6.2.2
- listing current break definition 6.2.5, 12.9
- ON column clause 6.2.1, 12.9
- ON expr clause 12.9
- ON REPORT clause 6.2.7, 12.9
- ON ROW clause 6.2.3, 12.9
- printing grand and sub summaries 6.2.7
- printing summary lines at ends of reports 6.2.7
- removing definition 12.12
- SKIP clause 6.2.3, 12.9
- SKIP PAGE clause 6.2.2, 6.2.3, 12.9
- specifying multiple break columns 6.2.4, 12.9
- suppressing duplicate values 6.2.1
- used in conjunction with COMPUTE 6.2.6
- used in conjunction with SET COLSEP 12.41.10
- used to format a REFCURSOR variable 12.51
- used with COMPUTE 12.9, 12.14
break definition
- listing current 6.2.5, 12.9
- removing current 6.2.5, 12.12
BREAKS clause 6.2.5, 12.12
browser, web 7.1.1
BTITLE clause 12.42
BTITLE command 6.3.1, 12.10
- aligning title elements 12.49
- BOLD clause 12.49
- CENTER clause 12.49
- COL clause 12.49
- FORMAT clause 12.49
- indenting titles 12.49
- LEFT clause 12.49
- OFF clause 12.49
- old form C.2
- printing blank lines before bottom title 6.3.1.1
- referencing column value variable 12.13
- RIGHT clause 12.49
- SKIP clause 12.49
- suppressing current definition 12.49
- TAB clause 12.49
- TTITLE command 12.10
buffer 4.1.1
- appending text to a line in 5.2.3, 12.6
- delete a single line 5.2
- delete the current line 5.2
- delete the last line 5.2
- deleting all lines 5.2, 12.12, 12.18
- deleting a range of lines 5.2, 12.18
- deleting a single line 12.18
- deleting lines from 5.2.5, 12.18
- deleting the current line 12.18
- deleting the last line 12.18
- executing contents 12.4, 12.38
- inserting new line in 5.2.4, 12.28
- listing all lines 5.2, 12.29
- listing a range of lines 5.2, 12.29
- listing a single line 5.2, 12.29
- listing contents 5.2.1, 12.29
- listing the current line 5.2, 12.29
- listing the last line 5.2, 12.29
- loading into system editor 12.21
- saving contents 12.39
BUFFER clause 5.1.1, 5.2, 12.12
BUFFER variable C.6

C

CANCEL clause 12.34
Cancel key 4.8
cancel query 4.8
CENTER clause 6.3.1.1, 12.37, 12.49
CHANGE command 5.2, 5.2.2, 12.11
CHAR clause
- VARIABLE command 12.51
CHAR columns
- changing format 12.13
- default format 6.1.3.1
- definition from DESCRIBE 12.19
charset
- SQL*Plus Instant Client D.1.2
CLEAR clause 6.1.5, 12.13, 12.26
- in ATTRIBUTE command 12.8
CLEAR command 12.12
- BREAKS clause 6.2.5, 12.12
- BUFFER clause 5.1.1, 5.2, 12.12
- COLUMNS clause 12.12
- COMPUTES clause 12.12
- SCREEN clause 5.11.4, 12.12
- SQL clause 12.12
- TIMING clause 12.12
CLOB clause
- VARIABLE command 12.51
CLOB columns
- changing format 12.13
- default format 12.13
- setting maximum width 12.41, 12.41.34
- setting retrieval position 12.41, 12.41.31
- setting retrieval size 8.5.7, 12.41, 12.41.35
CLOSECURSOR variable C.1, C.8
CMDSEP variable 12.41, 12.41.8
COL clause 6.3.1.2, 12.37, 12.49
COLINVISIBLE variable 12.41.9
colons (((colon)))
- bind variables 5.12
COLSEP variable 12.41, 12.41.10
COLUMN command 6.1, 12.13
- ALIAS clause 12.13
- and BREAK command 12.9
- and DEFINE command 12.17
- CLEAR clause 6.1.5, 12.13
- DEFAULT clause C.3
- displaying column values in bottom titles 6.3.4, 12.13
- displaying column values in top titles 6.3.4, 12.13
- entering multiple 12.13
- ENTMAP clause 12.13
- FOLD_AFTER clause 12.13
- FOLD_BEFORE clause 12.13
- FORMAT clause 6.1.2.2, 6.1.3.2, 12.13
- formatting a REFCURSOR variable 12.51
- formatting NUMBER columns 6.1.2.1, 12.13
- HEADING clause 6.1.1.2, 12.13
- HEADSEP character 12.13
- JUSTIFY clause 12.13
- LIKE clause 6.1.4, 12.13
- listing column display attributes 6.1.5, 12.13
- NEW_VALUE clause 6.3.4, 12.13
- NEWLINE clause 12.13
- NOPRINT clause 6.3.4, 8.5.1, 12.13
- NULL clause 12.13
- OFF clause 6.1.6, 12.13
- OLD_VALUE clause 6.3.4, 12.13
- ON clause 6.1.6, 12.13
- PRINT clause 12.13
- resetting a column to default display C.1
- resetting to default display 6.1.5, 12.13, C.1
- restoring column display attributes 6.1.6, 12.13
- storing current date in variable for titles 12.13
- suppressing column display attributes 6.1.6, 12.13
- TRUNCATED clause 6.1.3.2, 12.13
- WORD_WRAPPED clause 6.1.3.2, 6.1.7, 12.13
- WRAPPED clause 6.1.3.2, 12.13
column headings
- aligning 12.13
- changing 6.1.1.1, 12.13
- changing character used to underline 12.41, 12.41.67
- changing to two or more words 6.1.1.2, 12.13
- displaying on more than one line 6.1.1.2, 12.13
- suppressing printing in a report 12.41, 12.41.26
- when truncated 12.13
- when truncated for CHAR and LONG columns 6.1.3.2
- when truncated for DATE columns 6.1.3.2
- when truncated for NUMBER columns 6.1.2.1
columns
- assigning aliases 12.13
- computing summary lines 6.2.6, 12.14
- copying display attributes 6.1.4, 12.8, 12.13
- copying values between tables B.1, B.2, B.3
- displaying values in bottom titles 6.3.4, 12.13
- displaying values in top titles 6.3.4, 12.13
- formatting CHAR, VARCHAR, LONG, and DATE 12.13
- formatting in reports 6.1, 12.13
- formatting MLSLABEL, RAW MLSLABEL, ROWLABEL 12.13
- formatting NUMBER 6.1.2.1, 12.13
- listing display attributes for all 6.1.5, 12.13
- listing display attributes for one 6.1.5, 12.13
- names in destination table when copying B.1.1, B.2.1
- printing line after values that overflow 6.1.7, 12.41, 12.41.44
- resetting a column to default display 6.1.5, 12.13, C.1
- resetting all columns to default display 12.12
- restoring display attributes 6.1.6, 12.8, 12.13
- setting printing to off or on 6.3.4, 8.5.1, 12.13
- starting new lines 12.13
- storing values in variables 6.3.4, 12.13
- suppressing display attributes 6.1.6, 12.8, 12.13
- truncating display for all when value overflows 6.1.3.2, 12.41.69
- truncating display for one when value overflows 6.1.3.2, 12.13
- wrapping display for all when value overflows 6.1.3.2, 12.41.69
- wrapping display for one when value overflows 6.1.3.2, 12.13
- wrapping whole words for one 6.1.7
COLUMNS clause 12.12
column separator 12.41, 12.41.10, C.1
comma, number format 6.1.2.2
command files
- aborting and exiting with a return code 5.6, 12.52, 12.53
- creating with a system editor 5.1.1
- creating with SAVE 12.39, 12.41.17
- editing with system editor 12.21
- in @ (at sign) command 5.4, 12.2
- including comments in 5.3, 12.35
- including more than one PL/SQL block 5.1.1
- including more than one SQL command 5.1.1
- in EDIT command 12.21
- in GET command 12.24
- in SAVE command 5.1.1, 12.39
- in SQLPLUS command 3.5.3, 5.4.1
- in START command 5.4, 12.45
- nesting 5.5
- passing parameters to 5.10, 12.2, 12.3, 12.45
- registering 12.41, 12.41.1
- retrieving 12.24
- running 5.4, 12.2, 12.45
- 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, 12.23
- uniform resource locator 12.2, 12.3, 12.45
command history
- SQL*Plus 12.26
command-line
- configuring globalization support 11.1
- installing help 2.2.4
command-line interface
- changing face and size 1.2
command prompt
- SET SQLPROMPT 8.5.10, 12.41, 12.41.57
- SQL*Plus 3.3.1
commands
- collecting timing statistics on 8.2, 12.48
- disabled in schema 13.1
- disabling 9.1
- echo on screen 12.41.16
- host, running from SQL*Plus 4.9, 12.27
- listing current in buffer 12.29
- re-enabling 9.1
- spaces 4.1
- SQL
  - continuing on additional lines 4.4.1.1
  - editing in buffer 5.2
  - editing with system editor 12.21
  - ending 4.4.1.2
  - entering and executing 4.4
  - entering without executing 4.4.1.2
  - executing current 12.4, 12.38
  - following syntax 4.4.1
  - listing current in buffer 5.2.1
  - saving current 12.39
  - setting character used to end and run 12.41
- SQL*Plus
  - command summary 12.1
  - continuing on additional lines 4.6.1.1, 12
  - ending 4.6.1, 12
  - entering and executing 4.6
  - entering during SQL command entry 12.41.56
  - 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, 12.35, C.1
- using /*...*/ to create 5.3.2
- using REMARK C.1
- using REMARK to create 5.3.1, 12.35, C.1
- using -- to create 5.3.3
COMMIT clause 12.23
- WHENEVER OSERROR 12.52
- WHENEVER SQLERROR 12.53
COMMIT command 4.11
communication between tiers
COMPATIBILITY variable C.1, C.7
compilation errors 4.5.1, 12.42, 13.1
COMPUTE command 6.2, 12.14
- computing a summary on different columns 6.2.8
- LABEL clause 6.2.6, 6.2.7, 12.14
- listing all definitions 6.2.9, 12.14
- maximum LABEL length 12.14
- OF clause 6.2.6
- ON 12.14
- ON column clause 6.2.6, 12.14
- ON expr clause 12.14
- ON REPORT clause 6.2.7, 12.14
- printing grand and sub summaries 6.2.7
- printing multiple summaries on same column 6.2.8
- printing summary lines at ends of reports 6.2.7
- printing summary lines on a break 6.2.6
- referencing a SELECT expression in OF 12.14
- referencing a SELECT expression in ON 12.14
- removing definitions 6.2.9, 12.12
- used to format a REFCURSOR variable 12.51
COMPUTES clause 12.12
CON_ID clause 12.42
CON_NAME clause 12.42
CONCAT variable 5.9.4, 12.41, 12.41.11
configuration
- globalization support 11.1
configuring
- Oracle Net 2.2.5
- SQL*Plus 2
CONNECT / feature 3.1.1
CONNECT command 3.1, 12.15
- and @ (at sign) 12.15
- changing password 12.15, 12.30
- SYSASM clause 12.15
- SYSBACKUP clause 12.15
- SYSDBA clause 12.15
- SYSDG clause 12.15
- SYSKM clause 12.15
- SYSOPER clause 12.15
- SYSRAC clause 12.15
- username/password 12.15
connect identifier 12.15
- in CONNECT command 12.15
- in COPY command B.1
- in DESCRIBE command 12.19
- in SQLPLUS command 3.5.2
connection identifier 3.2.1
- easy or abbreviated 3.2.3
- full 3.2.2
- net service name 3.2.2
CONTEXT variable 12.41
CONTEXT XQUERY option 12.41.74
CONTINUE clause
- WHENEVER OSERROR 12.52
- WHENEVER SQLERROR 12.53
continuing a long SQL*Plus command 4.6.1.1, 12
COPY command 12.16, 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
- error messages 13.2
- 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 12.41, 12.41.12
- relationship to COPY command B.1.2, B.2.3
COPYTYPECHECK variable 12.41, 12.41.13
CREATE clause
- in COPY command B.1.1, B.2.2
CREATE command
- entering PL/SQL 4.5.1
creating a PLAN_TABLE 8.1.1
creating flat files 6.4.1
creating PLUSTRACE role 8.1.1
creating sample tables
CSV 7.1.2
- clause 3.5.1.6, 12.41.36
- option 3.5.1.6
csv, outputting reports 7.1
cursor variables 12.51

D

database
- administrator 10.1
- connect identifier 12.15
- mounting 12.46
- opening 12.46
database changes, saving automatically 12.41, 12.41.3
DATABASE clause 12.34
database files
- recovering 12.34
database name at startup 12.46
databases
- connecting to default 12.15
- connecting to remote 12.15
- copying data between B.1, B.2
- copying data between tables on a single B.3
- disconnecting without leaving SQL*Plus 3.1, 12.20
- mounting 10.2.1
- opening 10.2.1
- recovering 10.4, 12.34
- shutting down 10.2, 10.2.3
- starting 10.2
database schema 8.1.1
- DESCRIBE parameter 12.19
- SHOW 12.42
DATAFILE clause 12.34
DATE
- column definition from DESCRIBE 12.19
date, storing current in variable for titles 6.3.5, 12.13
DATE clause 12.5
DATE columns
- changing format 12.13
- default format 6.1.3.1
DB2 12.41.13
DBA 10.1
- mode 12.46
- privilege 12.46
DBMS_APPLICATION_INFO package 8.5.2, 12.41, 12.41.1
DBMS output 8.5.9, 12.41.48
DECLARE command
- PL/SQL 4.5
DEFAULT clause 12.5
DEFINE command 5.7, 12.17
- and system editor 5.1.1, 12.17.1
- and UNDEFINE command 5.7, 12.50
- CHAR values 12.17
- SET DEFINE ON|OFF 12.41, 12.41.14
- substitution variables 12.17
DEFINE variable
- See: substitution variable
DEL[ETE] clause 12.26
DEL command 5.2, 5.2.5, 12.18
- using an asterisk 5.2, 12.18
DELIMITER clause 12.41.36
DESCRIBE command (SQL*Plus) 4.2, 12.19
- connect_identifier 12.19
- PL/SQL properties listed by 12.19
- table properties listed by 12.19
disabling
- PL/SQL commands 9.1
- SQL*Plus commands 9.1
- SQL commands 9.1
DISCONNECT command 3.1, 12.20
DOCUMENT command C.1, C.4
- REMARK as newer version of C.4
DOCUMENT variable C.1, C.9
DUPLICATES clause 12.9

E

ECHO
- SET command 12.41.16
ECHO variable 5.4, 12.41, 12.41.16
EDIT clause 12.26
EDIT command 5.1.1, 12.17.1, 12.21
- creating scripts with 5.1.1
- defining _EDITOR 12.21
- modifying scripts 12.21
- setting default file name 12.41, 12.41.17
EDITFILE variable 12.41, 12.41.17
edition 3.5.2, 12.15
- in CONNECT command 12.15
- in SQLPLUS command 3.5.2
EDITOR operating system variable 12.17.1
Ed on UNIX 12.17.1
EMBEDDED variable 12.41, 12.41.18
entities, HTML 7.1.1.1
ENTMAP 3.5.1.6
ENTMAP clause 3.5.1.6, 7.1.1.1, 12.13
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 12.41.19
error messages
- COPY command 13.2
- interpreting 4.12
- sqlplus 13.1
errors
- compilation errors 4.5.1, 12.42, 13.1
- making line containing current 5.2.2
escape characters, definition of 12.41, 12.41.20
ESCAPE variable 5.9.4, 12.41, 12.41.20
ESCCHAR variable 12.41.21
example
- CSV report 7.1.2
- interactive HTML report 7.1.1
EXECUTE command 12.22
executing
- a CREATE command 4.5.1
execution plan 8.1.2
execution statistics
- including in report 12.41.6
exit, conditional 12.52
EXIT clause
- WHENEVER OSERROR 12.52
- WHENEVER SQLERROR 12.53
EXIT command 3.4, 12.23
- ((colon))BindVariable clause 12.23
- COMMIT clause 12.23
- FAILURE clause 12.23
- in a script 12.45
- ROLLBACK clause 12.23
- use with SET MARKUP 7.1.1
- WARNING clause 12.23
EXITCOMMIT variable 12.41.22
extension 12.39, 12.41.60, 12.47

F

FAILURE clause 12.23
FEEDBACK variable 12.41, 12.41.23
file extensions 2.2.3, 12.39, 12.41.60, 12.47
file names
- in @ (at sign) command 12.2
- in @@ (double at sign) command 12.3
- in EDIT command 12.21
- in GET command 12.24
- in SAVE command 12.39
- in SPOOL command 6.4.2, 12.44
- in SQLPLUS command 3.5.3
files
- flat 6.4.1
- required for SQL*Plus Instant Client D.2.3
FLAGGER variable 12.41, 12.41.24
flat file 6.4.1
FLUSH variable 8.5.5, 12.41, 12.41.25
FOLD_AFTER clause 12.13
FOLD_BEFORE clause 12.13
font
- changing face and size in command-line 1.2
footers
- aligning elements 12.37
- displaying at bottom of page 12.36
- displaying system-maintained values 12.37
- formatting elements 12.37
- indenting 12.37
- listing current definition 12.36
- setting at the end of reports 6.3
- suppressing definition 12.37
FORCE clause 12.46
FORMAT clause 12.5, 12.13
- in ATTRIBUTE command 12.8
- in COLUMN command 6.1.2.2, 6.1.3.2
- in REPHEADER and REPFOOTER commands 12.37
- in TTITLE and BTITLE commands 6.3.2, 12.49
format models, number 6.1.2.2, 12.13
formfeed, to begin a new page 6.3.6, 12.41.37
FROM clause 12.34, B.2.1

G

GET command 12.24
- LIST clause 12.24
- NOLIST clause 12.24
- retrieving scripts 12.24
globalization support
- Oracle10g 11.3
glogin 2.2.1
- See also: login.sql
- profile 12.41.55.1
- site profile 2.2, 2.2.1, 2.2.2.1, 3.5.1.9, 12.41.55.1

H

HEAD clause 3.5.1.6
headers
- aligning elements 6.3.1.1
- displaying at top of page 12.37
- displaying system-maintained values 12.37
- setting at the start of reports 6.3
- suppressing 6.3.1
HEADING clause 6.1.1.2, 12.13
headings
- aligning elements 12.37
- column headings 12.41.26
- formatting elements 12.37
- indenting 12.37
- listing current definition 12.37
- suppressing definition 12.37
HEADING variable 12.41.26
HEAD option 3.5.1.6
HEADSEP variable 12.41, 12.41.27
- use in COLUMN command 6.1.1.2
help
- installing command-line 2.2.4
- online 3.3.2, 12.25
HELP command, ? command 12.25
HIDE clause 12.5
HISTORY clause 12.42
HISTORY command 12.26
- CLEAR clause 12.26
- DEL[ETE] clause 12.26
- EDIT clause 12.26
- LIST clause 12.26
- RUN clause 12.26
HISTORY variable 12.41
HOST command 4.9, 12.27
HTML 7.1.1
- clause 3.5.1.6
- entities 7.1.1.1
- option 3.5.1.6
- spooling to file 3.5.1.6
- tag 7.1
hyphen
- continuing a long SQL*Plus command 4.6.1.1, 12

I

IMMEDIATE mode 12.43
infinity sign (~) 12.13
INIT.ORA file
- parameter file 12.46
initialization parameters
- displaying 12.42
input
- accepting [Return] 5.11.3
- accepting values from the user 5.11.1, 12.5
INPUT command 5.2, 5.2.4, 12.28
- entering several lines 12.28
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 copying from 10g Client D.3
- SQL*Plus Instant Client by download from OTN D.1, D.2
- SQL*Plus Instant Client on Linux D.2.1
- SQL*Plus Instant Client on UNIX or Windows D.2.2
- SQL*Plus Instant Client UNIX and Linux files to copy D.3.1
- SQL*Plus Instant Client Windows files to copy D.3.2
installation, UNIX and Linux files to copy D.3.1
installation, Windows files to copy D.3.2
installation by copying D.1
installation by copying from 10g Client D.3
installation by download from OTN D.1, D.2
installation on Linux D.2.1
installation on UNIX or Windows D.2.2
instances
- shutting down 12.43
- starting 12.46
INSTANCE variable 12.41, 12.41.29
Instant Client
- SQL*Plus D
Instant Client packages D.1

J

Japanese 11.1
JUSTIFY clause 12.13

L

labels
- in COMPUTE command 6.2.6, 12.14
LABEL variable
- SHOW command C.1
language
- SQL*Plus Instant Client D.1.2
LD_LIBRARY_PATH
- environment variables 2.1
LEFT clause 6.3.1.1, 12.37, 12.49
lightweight OCI package D.1.2
LIKE clause 6.1.4, 12.8, 12.13
limits, SQL*Plus A
lines
- adding at beginning of buffer 12.28
- adding at end of buffer 12.28
- adding new after current 5.2.4, 12.28
- appending text to 5.2.3, 12.6
- changing width 6.3.6, 8.5.6, 12.41, 12.41.30
- deleting all in buffer 12.18
- deleting from buffer 5.2.5, 12.18
- determining which is current 5.2.2
- editing current 5.2.2
- listing all in buffer 5.2, 12.29
- removing blanks at end 12.41.65
LINESIZE variable 6.3.1.1, 6.3.6, 12.41, 12.41.30
Linux
- installing SQL*Plus Instant Client D.2.1
- SQL*Plus Instant Client files to copy D.3.1
LIST clause 12.7, 12.24, 12.26
LIST command 5.2, 12.29
- determining current line 5.2.2, 12.29
- making last line current 5.2.2, 12.29
- using an asterisk 5.2, 12.29
LNO clause 12.42
LOB data
- setting prefetch size 12.41
LOBOFFSET variable 12.41, 12.41.31
LOBPREFETCH clause 12.42
LOBPREFETCH variable 12.41
LOCAL
- environment variables 2.1
LOG_ARCHIVE_DEST parameter 12.7
LOGFILE clause 12.34
logging off
- conditionally 12.52, 12.53
- Oracle Database 3.1, 12.20
- SQL*Plus 3.4, 12.23
logging on
- Oracle Database 12.15
- SQL*Plus 3.3.1
login
- user profile 2.2.2.1
login.sql 2.2.2
LONG
- column definition from DESCRIBE 12.19
LONGCHUNKSIZE variable 6.1.3.1, 12.13, 12.41, 12.41.35, 12.41.36
LONG columns
- changing format 12.13
- default format 12.13
- setting maximum width 12.41, 12.41.34
- setting retrieval size 8.5.7, 12.41, 12.41.35
LONGRAW
- column definition from DESCRIBE 12.19
LONG variable 12.41, 12.41.34
- effect on COPY command B.1.2, B.2.3

M

MARKUP 3.5.1.6, 7.1, 12.41.36
- BODY clause 3.5.1.6
- DELIMITER clause 12.41.36
- ENTMAP clause 3.5.1.6
- HEAD clause 3.5.1.6
- PREFORMAT clause 3.5.1.6
- QUOTE clause 12.41.36
- TABLE clause 3.5.1.6
MAXDATA variable C.1, C.10
media recovery 12.46
message, sending to screen 5.11.1, 12.33
MOUNT clause 12.46
mounting a database 12.46

N

national language support 11.1
- See also: globalization support
NCHAR clause
- VARIABLE command 12.51
NCHAR columns
- changing format 12.13
- default format 6.1.3.1, 12.13
NCLOB clause
- VARIABLE command 12.51
NCLOB columns
- changing format 12.13
- default format 12.13
- setting maximum width 12.41, 12.41.34
- setting retrieval position 12.41, 12.41.31
- setting retrieval size 8.5.7, 12.41, 12.41.35
negative infinity sign (-~) 12.13
net service name 3.2.1, 3.2.2
NEW_VALUE clause 6.3.4, 12.13
- storing current date in variable for titles 12.13
NEWLINE clause 12.13
NEWPAGE command C.1, C.5
NEWPAGE variable 6.3.6, 12.41, 12.41.37
NLS 11.1
NLS_DATE_FORMAT 12.5, 12.13
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 12.41
NODE XQUERY option 12.41.73
NOLIST clause 12.24
NOLOG 3.2.4, 3.5.2
nolongontime 3.5.1.8
NOMOUNT clause 12.46
NONE clause
- WHENEVER OSERROR 12.52
- WHENEVER SQLERROR 12.53
NOPARALLEL clause 12.34
NOPRINT clause 6.2.6, 6.3.4, 8.5.1, 12.13
NOPROMPT clause 12.5
NORMAL mode 12.43
Notepad on Windows 12.17.1
NULL clause 12.13
null values
- setting text displayed 12.13, 12.41, 12.41.38
NULL variable 12.41, 12.41.38
NUMBER
- column definition from DESCRIBE 12.19
NUMBER clause 5.11.2
- VARIABLE command 12.51
NUMBER columns
- changing format 6.1.2.1, 12.13
- default format 6.1.2.1, 12.13
number formats
- $ 6.1.2.2
- 0 6.1.2.2
- 9 6.1.2.2
- comma 6.1.2.2
- setting default 5.9.4, 12.41, 12.41.39
NUMFORMAT clause
- in LOGIN.SQL 2.2.2.1
NUMFORMAT variable 12.41, 12.41.39
NUMWIDTH variable 12.41, 12.41.40
- effect on NUMBER column format 6.1.2.1, 12.13
NVARCHAR2 columns
- changing format 12.13
- default format 6.1.3.1, 12.13

O

objects, describing 12.41.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
OF clause 6.2.6
OFF clause 12.13
- in ATTRIBUTE command 12.8
- in COLUMN command 6.1.6, 12.13
- in REPFOOTER commands 12.37
- in REPHEADER commands 12.37
- in SPOOL command 6.4, 12.44
- in TTITLE and BTITLE commands 6.3.3, 12.49
OLD_VALUE clause 6.3.4, 12.13
ON clause
- in ATTRIBUTE command 12.8
- in COLUMN command 6.1.6, 12.13
- in TTITLE and BTITLE commands 6.3.3
ON column clause
- in BREAK command 12.9
- in COMPUTE command 6.2.6, 12.14
ON expr clause
- in BREAK command 12.9
- in COMPUTE command 12.14
online help 3.3.2, 12.25
ON REPORT clause
- in BREAK command 6.2.7, 12.9
- in COMPUTE command 6.2.7, 12.14
ON ROW clause
- in BREAK command 6.2.3, 12.9
- in COMPUTE command 12.14
OPEN clause 12.46
opening a database 12.46
operating system
- editor 5.1.1, 12.17.1, 12.21
- file, loading into buffer 12.24
- running commands from SQL*Plus 4.9, 12.27
- 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 11.3
Oracle Application Editions
- edition 3.5.2
Oracle Database Client D
Oracle Net
- configuring 2.2.5
- connect identifier 12.15
Oracle Session Editions
- edition 12.15
ORDER BY clause
- displaying column values in titles 6.3.4
- displaying values together in output 6.2
ORDERING variable 12.41
ORDERING XQUERY option 12.41.72
OUT clause 6.4.3, 12.44
output
- formatting white space in 8.5.11, 12.41.61
- pausing during display 4.10, 12.41.42

P

packages
- SQL*Plus and OCI for Instant Client D.1
PAGE clause 12.37
page number, including in titles 6.2.4, 6.3.2
pages
- changing length 6.3.6, 8.5.8, 12.41, 12.41.41
- default dimensions 6.3.6
- matching to screen or paper size 6.3.6
- setting dimensions 6.3.6
PAGESIZE clause
- in LOGIN.SQL 2.2.2.1
PAGESIZE variable 4.4, 6.3.6, 8.5.8, 12.41, 12.41.41
parameter 5.10, 12.2, 12.3, 12.45
- SQLPATH 2.1.1
parameter files (INIT.ORA files)
- specifying alternate 12.46
PARAMETERS clause 12.42
password
- changing with the PASSWORD command 12.30
- in CONNECT command 3.1, 12.15
- 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 12.15, 12.30
PATH
- environment variables 2.1
PAUSE command 5.11.3, 12.31
PAUSE variable 4.10, 12.41, 12.41.42
PDBS clause 12.42
performance
- of SQL statements 8.1
- over dial-up lines 12.41.65
period (.)
- terminating PL/SQL blocks 4.5, 12.41, 12.41.7
PL/SQL 4.5
- blocks, PL/SQL 4.5
- executing 12.22
- formatting output in SQL*Plus 12.51
- listing definitions 4.3
- mode in SQL*Plus 4.5.1
- within SQL commands 4.5.1
PLAN_TABLE
- creating 8.1.1
- table 8.1.1
PLUGGABLE DATABASE clause 12.46
PLUSTRACE
- creating role 8.1.1
- role 8.1.1
PNO clause 12.42
pound sign (#) 12.13
predefined variable
- _CONNECT_IDENTIFIER 2.2.2.1, 12.17.1
- _DATE 12.17.1
- _EDITOR 5.1.1, 12.17.1, 12.21
- _O_RELEASE 12.17.1
- _O_VERSION 12.17.1
- _PRIVILEGE 12.17.1
- _RC 12.27
- _SQLPLUS_RELEASE 12.17.1
- _USER 12.17.1
PREFORMAT 3.5.1.6
PREFORMAT clause 3.5.1.6
PRINT clause 12.13
PRINT command 12.32
printing
- bind variables automatically 12.41.4
- REFCURSOR variables 12.51
- SPOOL command 12.44
prompt
- SET SQLPROMPT 8.5.10, 12.41, 12.41.57
PROMPT clause 5.11.1, 12.5
PROMPT command 5.11.1, 12.33
- customizing prompts for value 5.11.2
prompts for value
- bypassing with parameters 5.10
- customizing 5.11.2
- through ACCEPT 5.11.1
- through substitution variables 5.9.1

Q

queries
- in COPY command B.1.1, B.2.1
- show number of records retrieved 4.4, 12.41, 12.41.23
- tracing 8.3, 8.4
query execution path
- including in report 12.41.6
query results
- displaying on-screen 4.4
- sending to a printer 6.4.3, 12.44
- storing in a file 6.4.2, 12.44
QUIT command 12.23, 12.45
- See also: EXIT
QUOTE clause 12.41.36

R

RAW
- column definition from DESCRIBE 12.19
record separators, printing 6.1.7, 12.41, 12.41.44
RECOVER clause 12.46
RECOVER command 12.34
- and database recovery 10.4
- AUTOMATIC clause 12.34
- CANCEL clause 12.34
- CONTINUE clause 12.34
- DATABASE clause 12.34
- FROM clause 12.34
- LOGFILE clause 12.34
- NOPARALLEL clause 12.34
- SNAPSHOT TIME date clause 12.34
- STANDBY DATABASE clause 12.34
- STANDBY DATAFILE clause 12.34
- STANDBY TABLESPACE clause 12.34
- UNTIL CANCEL clause 12.34
- UNTIL CONTROLFILE clause 12.34
- UNTIL TIME clause 12.34
- USING BACKUP CONTROL FILE clause 12.34
recovery
- RECOVER command 12.34
RECSEPCHAR variable 6.1.7, 12.41, 12.41.44
RECSEP variable 6.1.7, 12.41, 12.41.44
REFCURSOR bind variables
- in a stored function 5.13
REFCURSOR clause
- VARIABLE command 12.51
registry
- editor 2.1.1
registry entry
- SQLPATH 2.1, 2.1.1
RELEASE clause 12.42
REMARK command 5.3.1, 12.35
removing sample tables
REPFOOTER clause 12.42
REPFOOTER command 6.3.1, 12.36
- aligning footer elements 12.37
- BOLD clause 12.37
- CENTER clause 12.37
- COL clause 12.37
- FORMAT clause 12.37
- indenting report footers 12.37
- LEFT clause 12.37
- OFF clause 12.37
- RIGHT clause 12.37
- SKIP clause 12.37
- suppressing current definition 12.37
- TAB clause 12.37
REPHEADER clause 12.42
REPHEADER command 6.3.1, 12.37
- aligning header elements 6.3.1.1
- aligning heading elements 12.37
- BOLD clause 12.37
- CENTER clause 12.37
- COL clause 12.37
- FORMAT clause 12.37
- indenting headings 12.37
- LEFT clause 12.37
- OFF clause 12.37
- PAGE clause 12.37
- RIGHT clause 12.37
- SKIP clause 12.37
- suppressing current definition 12.37
- TAB clause 12.37
REPLACE clause
- in COPY command B.1.1, B.2.2
- in SAVE command 12.39, 12.44
reports
- autotrace 8.1.1
- breaks 12.9
- clarifying with spacing and summary lines 6.2
- columns 12.13
- creating bottom titles 6.3, 12.10, C.1
- creating footers 12.36
- creating headers 12.37
- creating headers and footers 6.3
- creating master/detail 6.3.4, 12.13
- creating top titles 6.3, 12.49, C.1
- csv 7.1
- CSV example 7.1.2
- displaying 12.41, 12.41.6
- formatting column headings 6.1.1.2, 12.13
- formatting columns 6.1.2.1, 6.1.3.1, 12.13
- interactive HTML example 7.1.1
- on the web 7.1
- SILENT mode 7.1.3
- starting on a new page 12.41.18
- title 12.49, C.1
RESTRICT 3.5.1.9, 9.3, 12.46
return code, specifying 5.6, 12.23, 12.53
RIGHT clause 6.3.1.1, 12.37, 12.49
roles 9.2
- disabling 9.2.2
- re-enabling 9.2.2
ROLLBACK clause 12.23
- WHENEVER OSERROR 12.52
- WHENEVER SQLERROR 12.53
row data
- setting prefetch size 12.41
ROWID
- column definition from DESCRIBE 12.19
ROWPREFETCH clause 12.42
ROWPREFETCH variable 12.41
rows
- performing computations on 6.2.6, 12.14
- setting number retrieved at one time 8.5.3, 12.41, 12.41.2
- setting the number after which COPY commits 12.41.12
RUN clause 12.26
RUN command 12.38
- executing current PL/SQL block 4.5
- making last line current 5.2.2
- similar to / (slash) command 12.38

S

sample schemas , ,
- see Oracle Database Sample Schemas guide
- using HR in COLUMN example 12.13
- using HR in examples 5, 6
sample tables
- access to
- creating
- removing
- unlocking
SAVE command 12.39
- APPEND clause 12.39
- CREATE clause 12.39
- REPLACE clause 12.39
- storing commands in scripts 12.39
- using with INPUT to create scripts 5.1.1
saving environment attributes 12.47
SCAN variable C.1, C.11
schemas
- command 13.1
- database 8.1.1
- DESCRIBE parameter 12.19
- disabled commands 13.1
- HR sample
- installing own copy of HR
- sample
- SHOW parameter 12.42
- unlocking HR
- using HR in COLUMN example 12.13
- using HR in examples 5, 6
SCREEN clause 5.11.4, 12.12
screens
- clearing 5.11.4, 12.12
scripts
- extension 12.39, 12.41.60, 12.47
- registering 8.5.2
scripts, authenticating users in 3.1.1
SECUREDCOL variable 12.41.47
security
- changing password 12.30
- nolongontime 3.5.1.8
- password viewable 3.5.2
- RESTRICT 3.5.1.9, 9.3
SELECT command
- and BREAK command 6.2, 12.9
- and COLUMN command 12.13
- and COMPUTE command 6.2
- and COPY command B.1.1, B.2.1
- and DEFINE command 12.17
- and ORDER BY clause 6.2
- formatting results 5.13, 5.14
semicolon (;)
- in PL/SQL blocks 4.5
- in SQL*Plus commands 4.6.1, 12
- in SQL commands 4.4, 4.4.1.2
- not stored in buffer 5.2.1
SERVEROUTPUT variable 12.41.48
service name
- in COPY command B.2.1, B.2.2, B.3
Session Editions 12.15
SET AUTOTRACE 8.1.1
SET clause 12.47
SET command 2.2.3, 4.7, 12.40, 12.41
- APPINFO variable 8.5.2, 12.41.1
- ARRAYSIZE variable 8.5.3, 12.41, 12.41.2, B.2.3
- AUTOCOMMIT variable 12.41, 12.41.3
- AUTOPRINT variable 12.41, 12.41.4, 12.51
- AUTORECOVERY variable 12.41, 12.41.5
- AUTOTRACE variable 12.41.6
- BLOCKTERMINATOR variable 12.41, 12.41.7
- BUFFER variable C.6
- CLOSECURSOR variable C.1, C.8
- CMDSEP variable 12.41, 12.41.8
- COLINVISIBLE variable 12.41.9
- COLSEP variable 6.4.1, 12.41, 12.41.10
- COMPATIBILITY variable C.1, C.7
- CONCAT variable 5.9.4, 12.41, 12.41.11
- COPYCOMMIT variable 12.41, 12.41.12, B.2.3
- COPYTYPECHECK variable 12.41, 12.41.13
- DEFINE clause 5.9.4
- DEFINE variable 12.41
- DESCRIBE variable 12.41, 12.41.15
- DOCUMENT variable C.1, C.9
- ECHO variable 12.41, 12.41.16
- EDITFILE variable 12.41, 12.41.17
- EMBEDDED variable 12.41, 12.41.18
- ERRORLOGGING variable 12.41.19
- ESCAPE variable 5.9.4, 12.41, 12.41.20
- ESCCHAR variable 12.41.21
- EXITCOMMIT variable 12.41.22
- FEEDBACK variable 12.41, 12.41.23
- FLAGGER variable 12.41, 12.41.24
- FLUSH variable 8.5.5, 12.41, 12.41.25
- HEADING variable 12.41.26
- HEADSEP variable 6.1.1.2, 12.41, 12.41.27
- HISTORY variable 12.41
- INSTANCE variable 12.41, 12.41.29
- LINESIZE variable 6.3.1.1, 6.3.6, 12.41, 12.41.30
- LOBOFFSET variable 12.41, 12.41.31
- LOBPREFETCH variable 12.41
- LOGSOURCE variable 12.41, 12.41.33
- LONGCHUNKSIZE variable 12.41, 12.41.35
- LONG variable 12.41, 12.41.34, B.2.3
- MARKUP clause 12.41.36
- MAXDATA variable C.1, C.10
- NEWPAGE variable 6.3.6, 12.41, 12.41.37
- NULL variable 12.41, 12.41.38
- NUMFORMAT clause 2.2.2.1
- NUMFORMAT variable 12.41, 12.41.39
- NUMWIDTH variable 6.1.2.1, 12.13, 12.41, 12.41.40
- PAGESIZE clause 2.2.2.1
- PAGESIZE variable 4.4, 6.3.6, 8.5.8, 12.41, 12.41.41
- PAUSE variable 12.41, 12.41.42
- RECSEPCHAR variable 6.1.7, 12.41, 12.41.44
- RECSEP variable 6.1.7, 12.41, 12.41.44
- ROWPREFETCH variable 12.41
- SCAN variable C.1, C.11
- SECUREDCOL variable 12.41.47
- SERVEROUTPUT variable 12.41.48
- SHIFTINOUT variable 12.41, 12.41.49
- SPACE variable C.1, C.12
- SQLBLANKLINES variable 12.41.51
- SQLCASE variable 12.41, 12.41.52
- SQLCONTINUE variable 12.41, 12.41.53
- SQLNUMBER variable 12.41, 12.41.54
- SQLPLUSCOMPATIBILITY variable 12.41, 12.41.55
- SQLPREFIX variable 12.41, 12.41.56
- SQLPROMPT variable 8.5.10, 12.41, 12.41.57
- SQLTERMINATOR variable 12.41, 12.41.58
- STATEMENTCACHE variable 12.41
- substitution variable 12.41.14
- SUFFIX variable 12.41, 12.41.60
- TAB variable 8.5.11, 12.41, 12.41.61
- TERMOUT variable 8.5.12, 12.41, 12.41.62
- TIME variable 12.41, 12.41.63
- TIMING variable 12.41, 12.41.64
- TRIMOUT variable 12.41, 12.41.65
- TRIMSPOOL variable 12.41, 12.41.66
- TRUNCATE variable C.1, C.13
- UNDERLINE variable 12.41, 12.41.67
- used to format a REFCURSOR variable 12.51
- VERIFY clause 5.9.1
- VERIFY variable 5.9.4, 12.41, 12.41.68
- WRAP variable 6.1.3.2, 12.41, 12.41.69
- XMLOPTIMIZATIONCHECK variable 12.41, 12.41.70
- XQUERY BASEURI variable 12.41
- XQUERY CONTEXT variable 12.41
- XQUERY NODE variable 12.41
- XQUERY ORDERING variable 12.41
SET HISTORY command 12.41.28
SET LOBPREFETCH command 12.41.32
SET MARKUP
- BODY clause 3.5.1.6
- CSV 3.5.1.6, 12.41.36
- CSV example 7.1.2
- DELIMITER clause 12.41.36
- ENTMAP clause 3.5.1.6, 7.1.1.1
- HEAD clause 3.5.1.6
- HTML 3.5.1.6
- interactive HTML example 7.1.1
- PREFORMAT clause 3.5.1.6
- QUOTE clause 12.41.36
- TABLE clause 3.5.1.6
SET ROWPREFETCH command 12.41.46
SET STATEMENTCACHE command 12.41.59
SET system variable summary 12.41
SET variables 4.7
- See: system variables
SET XQUERY BASEURI 12.41.71
SET XQUERY CONTEXT 12.41.74
SET XQUERY NODE 12.41.73
SET XQUERY ORDERING 12.41.72
SGA clause 12.42
SHIFTINOUT variable 12.41, 12.41.49
SHOW
- schema parameter 12.42
SHOW clause 12.48
SHOW command 4.7, 12.42
- ALL clause 12.42
- BTITLE clause 12.42
- CON_ID clause 12.42
- CON_NAME clause 12.42
- ERRORS clause 12.42
- HISTORY clause 12.42
- LABEL variable C.1
- listing current page dimensions 6.3.6
- LNO clause 12.42
- LOBPREFETCH clause 12.42
- PDBS clause 12.42
- PNO clause 12.42
- RELEASE clause 12.42
- REPFOOTER clause 12.42
- REPHEADER clause 12.42
- ROWPREFETCH clause 12.42
- SPOOL clause 12.42
- SQLCODE clause 12.42
- STATEMENTCACHE clause 12.42
- TTITLE clause 12.42
- USER clause 12.42
- XQUERY clause 12.42
SHOWMODE variable 12.41, 12.41.50
SHUTDOWN command 12.43
- ABORT 12.43
- IMMEDIATE 12.43
- NORMAL 12.43
- TRANSACTIONAL LOCAL 12.43
site profile
- glogin 2.2, 2.2.1, 2.2.2.1, 3.5.1.9, 12.41.55.1
SKIP clause
- in BREAK command 6.2.2, 6.2.3, 12.9
- in REPHEADER and REPFOOTER commands 12.37
- in TTITLE and BTITLE commands 6.3.1.1, 12.49
- used to place blank lines before bottom title 6.3.1.1
SKIP PAGE clause 6.2.2, 6.2.3, 12.9
slash (/) command 12.4
- files loaded with GET command 12.24
SPACE variable C.1, C.12
SPOOL clause 3.5.1.6, 12.42
SPOOL command 6.3.6, 12.44
- APPEND clause 12.44
- CREATE clause 12.44
- file name 6.4.2, 12.44
- OFF clause 6.4, 12.44
- OUT clause 6.4.3, 12.44
- REPLACE clause 12.44
- to HTML file 3.5.1.6
- turning spooling off 6.4, 12.44
- use with SET MARKUP 7.1.1
SQL.PNO, referencing in report titles 6.3.2
SQL.SQLCODE
- using in EXIT command 12.23
SQL*Plus
- command history 12.26
- command prompt 3.3.1
- command summary 12.1
- configuring globalization support 11.1
- configuring Oracle Net 2.2.5
- database administration 10.1
- environment variables 2.1
- error messages 13.1
- execution plan 8.1.2
- exiting 3.4, 12.23
- limits A
- obsolete command alternatives C.1
- setting up environment 2.2
- starting 3.3, 3.3.1, 3.5
- statistics 8.1.3
- system variables affecting performance 8.5
- tuning 8.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, D.2, D.2.1, D.2.2, D.3, D.3.1, D.3.2
- 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
- required files in packages D.2.3
- unsupported charset error D.1.2.1
SQLBLANKLINES variable 12.41, 12.41.51
SQLCASE variable 12.41, 12.41.52
SQL clause 12.12
SQLCODE clause 12.42
- SHOW command 12.42
SQLCONTINUE variable 12.41, 12.41.53
SQL DML statements
- reporting on 12.41, 12.41.6
SQLNUMBER variable 12.41, 12.41.54, 12.41.55
SQL optimizer 8.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
- 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, 12.41.36
- -MARKUP option 3.5.1.6
- nolongontime 3.5.1.8
- PREFORMAT option 3.5.1.6
- RESTRICT 3.5.1.9, 9.3
- service name 3.5.2
- -SILENT clause 3.5.1.10
- -SILENT option 3.5.1.10, 7.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 12.41, 12.41.56
SQLPROMPT variable 8.5.10, 12.41, 12.41.57
SQLTERMINATOR variable 12.27, 12.41, 12.41.51, 12.41.58
STANDBY DATAFILE clause 12.34
STANDBY TABLESPACE clause 12.34
START clause 12.48
START command 5.4, 12.45
- arguments 5.10
- passing parameters to a script 5.10
- script 5.4, 12.45
- similar to @ (at sign) command 5.4, 12.2, 12.45
- similar to @@ (double at sign) command 12.45
starting
- SQL*Plus 1.1, 3.3, 3.3.1
STARTUP command 12.46
- DOWNGRADE clause 12.46
- FORCE clause 12.46
- MOUNT clause 12.46
- NOMOUNT clause 12.46
- OPEN clause 12.46
- PFILE clause 12.46
- PLUGGABLE DATABASE clause 12.46
- RECOVER clause 12.46
- RESTRICT clause 12.46
- specifying a database 12.46
- UPGRADE clause 12.46
statement cache
- setting size 12.41
STATEMENTCACHE clause 12.42
STATEMENTCACHE variable 12.41
statistics 8.1.3
- collecting TIMING statistics 8.2
STOP clause 12.48
stop query 4.8
STORE command 2.2.3, 12.47
- SET clause 12.47
stored functions 5.13
stored procedures
- creating 4.5.1
subkey, registry 2.1.1
substitution variables 5.7, 5.9, 5.9.4, 12.41, 12.41.14
- _EDITOR 12.17.1
- appending characters immediately after 5.9.1
- avoiding unnecessary prompts for value 5.9.2
- concatenation character 12.41, 12.41.11
- DEFINE command 12.17
- defining 5.7, 5.9.2, 12.17
- deleting 5.7, 12.50
- displaying in headers and footers 12.37
- displaying in titles 12.49
- in ACCEPT command 5.11.1, 12.5
- listing definitions 5.7, 12.17
- parsing 8.5.4
- prefixing 12.41.14, C.1
- related system variables 5.9.4
- restrictions 5.9.3
- single and double ampersands 5.9.2
- system variables used with 5.9.4
- undefined 5.9.1
- where and how to use 5.9.1
SUFFIX variable 12.41, 12.41.60
- used with EDIT command 12.21
- used with GET command 12.24
- used with SAVE command 12.39
- used with START command 12.45
SUM function 6.2.6
summary lines
- computing and printing 6.2.6, 12.14
- computing and printing at ends of reports 6.2.7
- computing same type on different columns 6.2.8
- printing grand and sub summaries (totals) 6.2.7
- printing multiple on same break column 6.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, 12.15
SYSBACKUP clause 3.5.2, 12.15
SYSDBA clause 3.5.2, 12.15
SYSDG clause 3.5.2, 12.15
SYSKM clause 3.5.2, 12.15
SYSOPER clause 3.5.2, 12.15
SYSRAC clause 3.5.2, 12.15
system-maintained values
- displaying in headers and footers 12.37
- displaying in titles 6.3.2, 12.49
- formatting in titles 6.3.2
system variables 4.7, 12.40
- affecting SQL*Plus performance 8.5
- affecting substitution variables 5.9.4
- listing current settings 4.7, 12.42
- listing old and new values 12.41, 12.41.50
- storing and restoring 2.2.3
- summary of SET commands 12.41

T

TAB clause 12.37, 12.49
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, 12.19
- referring to another user’s when copying B.2.4
TABLESPACE clause 12.34
tablespaces, recovering 12.34
TAB variable 8.5.11, 12.41, 12.41.61
tag, HTML 7.1
TERMOUT variable 8.5.12, 12.41, 12.41.62
- using with SPOOL command 12.44
territory
- SQL*Plus Instant Client D.1.2
text 3.5.1.6
- adding to current line with APPEND 5.2.3, 12.6
- changing old to new with CHANGE 5.2.2, 12.11
- clearing from buffer 5.2, 12.12
text editor
- operating system 5.1.1, 12.21
TIME variable 12.41, 12.41.63
TIMING clause 12.12
TIMING command 8.2, 12.48
- deleting all areas created by 12.12
- deleting current area 12.48
- SHOW clause 12.48
- START clause 12.48
- STOP clause 12.48
TIMING variable 12.41, 12.41.64
titles
- aligning elements 6.3.1.1, 12.49
- displaying at bottom of page 6.3, 12.10, C.1
- displaying at top of page 6.3, 12.49, C.1
- displaying column values 6.3.4, 12.13
- displaying current date 6.3.5, 12.13
- displaying page number 6.3.2, 12.49
- displaying system-maintained values 6.3.2, 12.49
- formatting elements 12.49
- formatting system-maintained values in 6.3.2
- indenting 6.3.1.2, 12.49
- listing current definition 6.3.3, 12.10, 12.49
- restoring definition 6.3.3
- setting at start or end of report 6.3
- setting lines from top of page to top title 6.3.6, 12.41, 12.41.37, C.1
- setting lines from top title to end of page 8.5.8, 12.41, 12.41.41
- setting top and bottom 6.3, 12.10, 12.49, C.1
- spacing between last row and bottom title 6.3.1.1
- suppressing definition 6.3.3, 12.49
TNS_ADMIN
- environment variables 2.1
TO clause B.2.1
tracing queries 8.3, 8.4
tracing statements
- for performance statistics 8.1.3
- for query execution path 8.1.3
- with parallel query option 8.3
TRIMOUT variable 12.41, 12.41.65
TRIMSPOOL variable 12.41, 12.41.66
TRUNCATED clause 6.1.3.2, 12.13
TRUNCATE variable C.1, C.13
TTITLE clause 12.42
TTITLE command 6.3.1, 12.49
- aligning title elements 6.3.1.1, 12.49
- BOLD clause 12.49
- CENTER clause 6.3.1.1, 12.49
- COL clause 6.3.1.2, 12.49
- FORMAT clause 6.3.2, 12.49
- indenting titles 6.3.1.2, 12.49
- LEFT clause 6.3.1.1, 12.49
- listing current definition 6.3.3, 12.49
- OFF clause 6.3.3, 12.49
- old form C.14
- ON clause 6.3.3
- referencing column value variable 6.3.4, 12.13
- restoring current definition 6.3.3
- RIGHT clause 6.3.1.1, 12.49
- SKIP clause 6.3.1.1, 12.49
- suppressing current definition 6.3.3, 12.49
- TAB clause 12.49
tuning
- SET APPINFO OFF 8.5.2
- SET ARRAYSIZE 8.5.3
- SET DEFINE OFF 8.5.4
- SET FLUSH OFF 8.5.5
- SET TRIMOUT ON 8.5.13
- SET TRIMSPOOL ON 8.5.13
- SQL*Plus 8.1
- system variables 8.5
TWO_TASK
- environment variables 2.1

U

UNDEFINE command 5.7, 12.50
- and DEFINE command 12.17
UNDERLINE variable 12.41, 12.41.67
unicode 11.1
UNIX
- ed 12.17.1
- installing SQL*Plus Instant Client D.2.2
- SQL*Plus Instant Client files to copy D.3.1
unlocking sample tables
UNTIL CANCEL clause 12.34
UNTIL CHANGE clause 12.34
UNTIL CONTROLFILE clause 12.34
UNTIL TIME clause 12.34
USER clause 12.42
username 3.1
- connecting under different 3.1, 12.15
- in CONNECT command 3.1, 12.15
- 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 12.34
USING clause B.1.1, B.2.1
UTF-8 11.1

V

V$SESSION virtual table 12.41.1
V$SQLAREA virtual table 12.41.1
VARCHAR2
- column definition from DESCRIBE 12.19
VARCHAR2 clause
- VARIABLE command 12.51
VARCHAR2 columns
- changing format 12.13
- default format 6.1.3.1
VARCHAR columns
- default format 6.1.3.1
VARIABLE command 12.51
- BINARY_DOUBLE clause 12.51
- BINARY_FLOAT clause 12.51
- CHAR clause 12.51
- CLOB clause 12.51
- NCHAR clause 12.51
- NCLOB clause 12.51
- NUMBER clause 12.51
- REFCURSOR clause 12.51
- value clause 12.51
- VARCHAR2 clause 12.51
- variable clause 12.51
variables
- bind variables 5.12
- substitution variables 12.17
- system variables 4.7
VERIFY clause 5.9.1
VERIFY variable 5.9.4, 12.41, 12.41.68

W

WARNING clause 12.23
web, outputting reports 7.1
web browser 7.1.1
WHENEVER OSERROR command 12.52
- COMMIT clause 12.52
- CONTINUE clause 12.52
- EXIT clause 12.52
- NONE clause 12.52
- ROLLBACK clause 12.52
WHENEVER SQLERROR command 12.53
- COMMIT clause 12.53
- CONTINUE clause 12.53
- EXIT clause 12.53
- NONE clause 12.53
- ROLLBACK clause 12.53
Windows
- installing SQL*Plus Instant Client D.2.2
- notepad 12.17.1
- SQL*Plus Instant Client files to copy D.3.2
WORD_WRAPPED clause 6.1.3.2, 6.1.7, 12.13
WRAPPED clause 6.1.3.2, 12.13
WRAP variable 6.1.3.2, 12.41, 12.41.69

X

XMLOPTIMIZATIONCHECK variable 12.41, 12.41.70
XMLType
- column definition from DESCRIBE 12.19
- column formatting 6.1.3.2
- column width 6.1.3.1
- creating 6.1.3.2
- formatting in reports 6.1.3
- inserting values 6.1.3.2
- selecting data 6.1.3.2
- setting column retrieval size 8.5.7, 12.41.35
- setting maximum column width 12.41.34
XQUERY clause 12.42
XQUERY command 12.54
XQUERY options
- BASEURI 12.41.71
- CONTEXT 12.41.74
- NODE 12.41.73
- ORDERING 12.41.72