Index

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

---

Symbols

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

---

Numerics

• 0, number format 7.1.2.2
• 9, number format 7.1.2.2

---

A

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

---

B

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

---

C

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

---

D

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

---

E

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

---

F

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

---

G

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

---

H

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

---

I

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

---

J

• Japanese 12.1
• JUSTIFY clause 13.14

---

L

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

---

M

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

---

N

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

---

O

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

---

P

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

---

Q

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

---

R

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

---

S

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

---

T

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

---

U

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

---

V

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

---

W

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

---

X

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