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