Skip Headers
SQL*Plus® User's Guide and Reference
Release 11.1

Part Number B31189-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

Index

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

Symbols

-- (comment delimiter), 5.3.3
- (hyphen)
clause, 3.5.1.1
continuing a long SQL*Plus command, 4.6.1.1, 12
. (period), 4.5
# pound sign
overflow indication, 12
SET SQLPREFIX character, 12
$ number format, 6.1.2.2
& (ampersand)
disabling substitution variables, 5.9.4
substitution variables, 5.9
&&, 5.9.2
/(slash) command
default logon, 3.5.2, 12
entered at buffer line-number prompt, 4.4.1.2, 12
entered at command prompt, 12
executing current PL/SQL block, 4.5
similar to RUN, 12, 12
usage, 12
* (asterisk)
in DEL command, 5.2, 12
in LIST command, 5.2, 12
/*...*/(comment delimiters), 5.3.2
: (colon)
bind variables, 5.12
:BindVariable clause
EXIT command, 12
; (semicolon), 4.4, 5.2, 12
@ (at sign)
command, 2.2.3.1, 5.4, 12
command arguments, 12, 12
in CONNECT command, 12
in COPY command, B.1, B.2.1
in SQLPLUS command, 3.5
passing parameters to a script, 12, 12
script, 5.4, 12
similar to START, 5.4, 12
@ at sign)
similar to START, 12
@@ (double at sign) command, 2.2.3.1, 12
script, 12
similar to START, 12, 12
_CONNECT_IDENTIFIER predefined variable, 2.2.2.1, 12, 12
_DATE predefined variable, 12, 12
_EDITOR predefined variable, 5.1.1, 12, 12, 12, 12
_EDITOR substitution variable, 12
_EDITOR, in EDIT command, 5.1.1, 12, 12
_O_RELEASE predefined variable, 12, 12
_O_VERSION predefined variable, 12, 12
_PRIVILEGE predefined variable, 12, 12
_RC predefined variable, 12
_SQLPLUS_RELEASE predefined variable, 12, 12, 12
_USER predefined variable, 12, 12
~ infinity sign, 12
-~ negative infinity sign, 12

Numerics

0, number format, 6.1.2.2
9, number format, 6.1.2.2

A

ABORT mode, 12
abort query, 4.8
ACCEPT command, 5.11.1, 12, 12
and DEFINE command, 12
BINARY_DOUBLE clause, 12, 12
BINARY_FLOAT clause, 12, 12
customizing prompts for value, 5.11.2
DATE clause, 12
DEFAULT clause, 12
FORMAT clause, 12
HIDE clause, 12
NOPROMPT clause, 12
NUMBER clause, 5.11.2
PROMPT clause, 5.11.1, 12
access, denying and granting, 9.1
alias, 3.2.2
ALIAS clause, 12, 12
in ATTRIBUTE command, 12
ALL clause, 12
ALTER command
disabling, 9.2
ampersands &(amp;)
in parameters, 5.10, 12, 12, 12
substitution variables, 5.9
ANALYZE command
disabling, 9.2
APPEND clause
in COPY command, B.1.1, B.2.2
in SAVE command, 12, 12
APPEND command, 5.2, 5.2.3, 12
APPINFO clause, 8.5.2, 12
ARCH background process, 12
ARCHIVE LOG
command, 10.3.1, 12
mode, 10.3.1
argument
in START command, 5.10
ARRAYSIZE variable, 8.5.3, 12, 12
relationship to COPY command, B.1.2, B.2.3
ASSOCIATE command
disabling, 9.2
ATTRIBUTE command, 12
ALIAS clause, 12
and CLEAR COLUMN command, 12
CLEAR clause, 12
clearing columns, 12, 12
controlling display characteristics, 12
display characteristics, 12
entering multiple, 12
FORMAT clause, 12
LIKE clause, 12
listing attribute display characteristics, 12, 12
OFF clause, 12
ON clause, 12
restoring column display attributes, 12
suppressing column display attributes, 12
AUDIT command
disabling, 9.2
AUTOCOMMIT variable, 4.11, 12, 12
AUTOMATIC clause, 12
AUTOPRINT variable, 12, 12
AUTORECOVERY variable, 12, 12
autotrace report, 8.1.1
AUTOTRACE variable, 8.1.1, 12, 12

B

background process
startup after abnormal termination, 12
BASEURI variable, 12
basic OCI package, D.1.1
BASURI XQUERY option, 12
batch jobs, authenticating users in, 3.1.1
batch mode, 12
BEGIN command, 4.5
disabling, 9.2
BFILE clause
VARIABLE command, 12
BINARY_DOUBLE clause
ACCEPT command, 12, 12
VARIABLE command, 12
BINARY_FLOAT clause
ACCEPT command, 12, 12
VARIABLE command, 12
bind variables, 5.12
creating, 12
displaying, 12
displaying automatically, 12, 12
in PL/SQL blocks, 12
in SQL statements, 12
in the COPY command, 12
blank line
in PL/SQL blocks, 4.5
in SQL commands, 4.4.1.2
preserving in SQL commands, 12, 12
BLOB
column width, 6.1.3.1
formating in reports, 6.1.3
BLOB clause
VARIABLE command, 12
BLOB columns
default format, 12
setting maximum width, 12, 12
setting retrieval position, 12, 12
setting retrieval size, 8.5.7, 12, 12
blocks, PL/SQL
continuing, 4.5
editing in buffer, 5.2
editing with system editor, 5.1, 12
entering and executing, 4.5
listing current in buffer, 5.2.1
saving current, 12
setting character used to end, 12, 12
stored in SQL buffer, 4.5
timing statistics, 12
within SQL commands, 4.5.1
BLOCKTERMINATOR, 12, 12, 12, 12
BODY clause, 3.5.1.6
BODY option, 3.5.1.6
BOLD clause, 12, 12
break columns, 6.2, 12
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
and SQL ORDER BY clause, 6.2, 6.2.1, 6.2.4, 12
clearing BREAKS, 6.2.5
displaying column values in titles, 6.3.4
DUPLICATES clause, 12
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
ON column clause, 6.2.1, 12
ON expr clause, 12
ON REPORT clause, 6.2.7, 12
ON ROW clause, 6.2.3, 12
printing grand and sub summaries, 6.2.7
printing summary lines at ends of reports, 6.2.7
removing definition, 12
SKIP clause, 6.2.3, 12
SKIP PAGE clause, 6.2.2, 6.2.2, 6.2.3, 12
specifying multiple break columns, 6.2.4, 12
suppressing duplicate values, 6.2.1
used in conjunction with COMPUTE, 6.2.6
used in conjunction with SET COLSEP, 12
used to format a REFCURSOR variable, 12
used with COMPUTE, 12, 12, 12, 12, 12
break definition
listing current, 6.2.5, 12
removing current, 6.2.5, 12
BREAKS clause, 6.2.5, 12
browser, web, 7.1.1
BTITLE clause, 12
BTITLE command, 6.3.1, 12
aligning title elements, 12
BOLD clause, 12
CENTER clause, 12
COL clause, 12
FORMAT clause, 12
indenting titles, 12
LEFT clause, 12
OFF clause, 12
old form, C.2
printing blank lines before bottom title, 6.3.1.1
referencing column value variable, 12
RIGHT clause, 12
SKIP clause, 12
suppressing current definition, 12
TAB clause, 12
TTITLE command, 12
buffer, 4.1.1
appending text to a line in, 5.2.3, 12
delete a single line, 5.2
delete the current line, 5.2
delete the last line, 5.2
deleting a range of lines, 5.2, 12
deleting a single line, 12
deleting all lines, 5.2, 12, 12
deleting lines from, 5.2.5, 12
deleting the current line, 12
deleting the last line, 12
executing contents, 12, 12
inserting new line in, 5.2.4, 12
listing a range of lines, 5.2, 12
listing a single line, 5.2, 12
listing all lines, 5.2, 12
listing contents, 5.2.1, 12
listing the current line, 5.2, 12
listing the last line, 5.2, 12
loading into system editor, 12
saving contents, 12
BUFFER clause, 5.1.1, 5.2, 12
BUFFER variable, C.6

C

CALL command
disabling, 9.2
CANCEL clause, 12, 12
Cancel key, 4.8
cancel query, 4.8
CENTER clause, 6.3.1.1, 12, 12
CHANGE command, 5.2, 5.2.2, 12
CHAR clause
VARIABLE command, 12
CHAR columns
changing format, 12
default format, 6.1.3.1
definition from DESCRIBE, 12
charset
SQL*Plus Instant Client, D.1.2
CLEAR clause, 6.1.5, 12
in ATTRIBUTE command, 12
CLEAR command, 12
BREAKS clause, 6.2.5, 12
BUFFER clause, 5.1.1, 5.2, 12
COLUMNS clause, 12
COMPUTES clause, 12
SCREEN clause, 5.11.4, 12
SQL clause, 12
TIMING clause, 12
CLOB clause
VARIABLE command, 12
CLOB columns
changing format, 12
default format, 12
setting maximum width, 12, 12
setting retrieval position, 12, 12
setting retrieval size, 8.5.7, 12, 12, 12
CLOSECURSOR variable, C.1, C.8
CMDSEP variable, 12, 12
COL clause, 6.3.1.2, 12, 12
colons (:)
bind variables, 5.12
COLSEP variable, 12, 12
COLUMN command, 6.1, 12
ALIAS clause, 12
and BREAK command, 12
and DEFINE command, 12
CLEAR clause, 6.1.5, 12, 12
DEFAULT clause, C.3
displaying column values in bottom titles, 6.3.4, 12
displaying column values in top titles, 6.3.4, 12
entering multiple, 12
ENTMAP clause, 12
FOLD_AFTER clause, 12, 12, 12
FOLD_BEFORE clause, 12, 12
FORMAT clause, 6.1.2.2, 6.1.3.2, 12, 12
formatting a REFCURSOR variable, 12
formatting NUMBER columns, 6.1.2.1, 12
HEADING clause, 6.1.1.2, 12, 12
HEADSEP character, 12
JUSTIFY clause, 12
LIKE clause, 6.1.4, 12, 12
listing column display attributes, 6.1.5, 6.1.5, 12, 12
NEW_VALUE clause, 6.3.4, 12, 12
NEWLINE clause, 12, 12
NOPRINT clause, 6.3.4, 8.5.1, 12
NULL clause, 12, 12
OFF clause, 6.1.6, 12
OLD_VALUE clause, 6.3.4, 12, 12
ON clause, 6.1.6, 12
PRINT clause, 12
resetting a column to default display, C.1
resetting to default display, 6.1.5, 12, C.1
restoring column display attributes, 6.1.6, 12
storing current date in variable for titles, 12
suppressing column display attributes, 6.1.6, 12
TRUNCATED clause, 6.1.3.2, 12
WORD_WRAPPED clause, 6.1.3.2, 6.1.7, 12
WRAPPED clause, 6.1.3.2, 12
column headings
aligning, 12
changing, 6.1.1.1, 12
changing character used to underline, 12, 12
changing to two or more words, 6.1.1.2, 12
displaying on more than one line, 6.1.1.2, 12
suppressing printing in a report, 12, 12
when truncated, 12
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
column separator, 12, 12, C.1
columns
assigning aliases, 12
computing summary lines, 6.2.6, 12
copying display attributes, 6.1.4, 12, 12
copying values between tables, B.1, B.2, B.3
displaying values in bottom titles, 6.3.4, 12
displaying values in top titles, 6.3.4, 12
formatting CHAR, VARCHAR, LONG, and DATE, 12
formatting in reports, 6.1, 12
formatting MLSLABEL, RAW MLSLABEL, ROWLABEL, 12
formatting NUMBER, 6.1.2.1, 12
listing display attributes for all, 6.1.5, 12
listing display attributes for one, 6.1.5, 12
names in destination table when copying, B.1.1, B.2.1
printing line after values that overflow, 6.1.7, 12, 12
resetting a column to default display, 6.1.5, 12, C.1, C.1
resetting all columns to default display, 12
restoring display attributes, 6.1.6, 12, 12
setting printing to off or on, 6.3.4, 8.5.1, 12
starting new lines, 12
storing values in variables, 6.3.4, 12
suppressing display attributes, 6.1.6, 12, 12
truncating display for all when value overflows, 6.1.3.2, 12
truncating display for one when value overflows, 6.1.3.2, 12
wrapping display for all when value overflows, 6.1.3.2, 12
wrapping display for one when value overflows, 6.1.3.2, 12
wrapping whole words for one, 6.1.7
COLUMNS clause, 12
comma, number format, 6.1.2.2
command files
aborting and exiting with a return code, 5.6, 12, 12
creating with a system editor, 5.1.1
creating with SAVE, 12, 12
editing with system editor, 12
in @ (at sign) command, 5.4, 12
in EDIT command, 12
in GET command, 12
in SAVE command, 5.1.1, 12
in SQLPLUS command, 3.5.3, 5.4.1
in START command, 5.4, 12
including comments in, 5.3, 12
including more than one PL/SQL block, 5.1.1
including more than one SQL command, 5.1.1
nesting, 5.5
passing parameters to, 5.10, 12, 12, 12
registering, 12, 12
retrieving, 12
running, 5.4, 12, 12
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
uniform resource locator, 12, 12, 12, 12
command prompt
SET SQLPROMPT, 8.5.10, 12, 12
SQL*Plus, 3.3.1
command-line
configuring globalization support, 11.1
installing help, 2.2.4
command-line interface
changing face and size, 1.2
commands
collecting timing statistics on, 8.2, 12
disabled in schema, 13.1
disabling, 9.2
echo on screen, 12
host, running from SQL*Plus, 4.9, 12
listing current in buffer, 12
re-enabling, 9.2
spaces, 4.1
SQL
continuing on additional lines, 4.4.1.1
editing in buffer, 5.2
editing with system editor, 12
ending, 4.4.1.2
entering and executing, 4.4
entering without executing, 4.4.1.2
executing current, 12, 12
following syntax, 4.4.1
listing current in buffer, 5.2.1
saving current, 12
setting character used to end and run, 12
SQL*Plus
command summary, 12
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
obsolete command alternatives, C.1
stopping while running, 4.8
tabs, 4.1
types of, 4.1
variables that affect running, 4.7
COMMENT command
disabling, 9.2
comments
including in command files, C.1
including in scripts, 5.3, 12, C.1
using -- to create, 5.3.3
using /*...*/to create, 5.3.2
using REMARK, C.1
using REMARK to create, 5.3.1, 12, C.1
COMMIT clause, 12
WHENEVER OSERROR, 12
WHENEVER SQLERROR, 12
COMMIT command, 4.11
disabling, 9.2
communication between tiers, Preface
COMPATIBILITY variable, C.1, C.7
compilation errors, 4.5.1, 12, 13.1
COMPUTE command, 6.2, 12
computing a summary on different columns, 6.2.8
LABEL clause, 6.2.6, 6.2.7, 12
listing all definitions, 6.2.9, 12
maximum LABEL length, 12
OF clause, 6.2.6
ON, 12
ON column clause, 6.2.6, 12
ON expr clause, 12
ON REPORT clause, 6.2.7, 12
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
referencing a SELECT expression in ON, 12
removing definitions, 6.2.9, 12
used to format a REFCURSOR variable, 12
COMPUTES clause, 12
CONCAT variable, 5.9.4, 5.9.4, 12, 12, 12, 12
configuration
globalization support
configuring
Oracle Net, 2.2.5
SQL*Plus, 2
CONNECT command, 3.1, 12
and @ (at sign), 12
changing password, 12, 12, 12
SYSDBA clause, 3.5.2, 12, 12
SYSOPER clause, 3.5.2, 12
username/password, 12
CONNECT /feature, 3.1.1
connect identifier, 12
in CONNECT command, 12
in COPY command, B.1
in DESCRIBE command, 12
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
CONTEXT XQUERY option, 12
CONTINUE clause
WHENEVER OSERROR, 12
WHENEVER SQLERROR, 12
continuing a long SQL*Plus command, 4.6.1.1, 12
COPY command, 12, 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, 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, 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, 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, 12
relationship to COPY command, B.1.2, B.2.3
COPYTYPECHECK variable, 12, 12
CREATE clause
in COPY command, B.1.1, B.2.2
CREATE command
disabling, 9.2
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, Preface
creating the PRODUCT_USER_PROFILE table, 9.1.1
cursor variables, 12

D

database
administrator, 10.1
connect identifier, 12
mounting, 12, 12
opening, 12, 12
database changes, saving automatically, 12, 12
DATABASE clause, 12
database files
recovering, 12
database name at startup, 12
database schema, 8.1.1
default, 12
DESCRIBE parameter, 12
SHOW, 12, 12
databases
connecting to default, 12
connecting to remote, 12
copying data between, B.1, B.2
copying data between tables on a single, B.3
disconnecting without leaving SQL*Plus, 3.1, 12
mounting, 10.2.1
opening, 10.2.1
recovering, 10.4, 12
shutting down, 10.2, 10.2.2
starting, 10.2
DATAFILE clause, 12
DATE
column definition from DESCRIBE, 12
DATE clause, 12
DATE columns
changing format, 12, 12
default format, 6.1.3.1
date, storing current in variable for titles, 6.3.5, 12, 12
DB2, 12, 12
DBA, 10.1
mode, 12
privilege, 12
DBMS output, 8.5.9, 12
DBMS_APPLICATION_INFO package, 8.5.2, 12, 12
DECLARE command
disabling, 9.2
PL/SQL, 4.5
DEFAULT clause, 12
DEFINE command, 5.7, 12
and system editor, 5.1.1, 12
and UNDEFINE command, 5.7, 12
CHAR values, 12
SET DEFINE ON|OFF, 12, 12
substitution variables, 12
DEFINE variable
See substitution variable
DEL command, 5.2, 5.2.5, 12
using an asterisk, 5.2, 12
DELETE command
disabling, 9.2
DESCRIBE command (SQL*Plus), 4.2, 12
connect_identifier, 12
PL/SQL properties listed by, 12
table properties listed by, 12
DISABLED keyword, disabling commands, 9.1.3
disabling
PL/SQL commands, 9.2
SQL commands, 9.2
SQL*Plus commands, 9.2
DISASSOCIATE command
disabling, 9.2
DISCONNECT command, 3.1, 12
DOCUMENT command, C.1, C.4
REMARK as newer version of, C.4, C.4
DOCUMENT variable, C.1, C.9
DROP command
disabling, 9.2
DUPLICATES clause, 12

E

ECHO
SET command, 12
ECHO variable, 5.4, 12, 12
Ed on UNIX, 12
EDIT command, 5.1.1, 12, 12, 12
creating scripts with, 5.1.1
defining _EDITOR, 12
modifying scripts, 12
setting default file name, 12, 12
EDITFILE variable, 12, 12
EDITOR operating system variable, 12
EMBEDDED variable, 12, 12
entities, HTML, 7.1.3
ENTMAP, 3.5.1.6
ENTMAP clause, 3.5.1.6, 7.1.3, 12
environment variables
LD_LIBRARY_PATH, 2.1
LOCAL, 2.1
NLS_LANG, 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
SQLPLUS, 2.1
TNS_ADMIN, 2.1
TWO_TASK, 2.1
error
SQL*Plus Instant Client unsupported charset, D.1.2.1
error messages
COPY command, 13.2
interpreting, 4.12
sqlplus, 13.1
ERRORLOGGING variable, 12
errors
compilation errors, 4.5.1, 12, 13.1
making line containing current, 5.2.2
escape characters, definition of, 12, 12
ESCAPE variable, 5.9.4, 12, 12, 12, 12
ESCCHAR variable, 12
example
interactive HTML report, 7.1.1, 7.1.1
EXECUTE command, 12
executing
a CREATE command, 4.5.1
execution plan, 8.1.2
execution statistics
including in report, 12
EXIT clause
WHENEVER OSERROR, 12
WHENEVER SQLERROR, 12
EXIT command, 3.4, 12
:BindVariable clause, 12
COMMIT clause, 12
FAILURE clause, 12
in a script, 12
ROLLBACK clause, 12
use with SET MARKUP, 7.1.1
WARNING clause, 12
exit, conditional, 12
EXPLAIN command
disabling, 9.2
extension, 12, 12, 12

F

FAILURE clause, 12
features
new, Preface
FEEDBACK variable, 12, 12
file extensions, 2.2.3, 12, 12, 12
file names
in @ (at sign) command, 12
in @@ (double at sign) command, 12
in EDIT command, 12
in GET command, 12
in SAVE command, 12
in SPOOL command, 6.4.2, 12
in SQLPLUS command, 3.5.3
files
flat, 6.4.1
required for SQL*Plus Instant Client, D.2.3
FLAGGER variable, 12, 12
FLASHBACK command
disabling, 9.2
flat file, 6.4.1
FLUSH variable, 8.5.5, 12, 12
FOLD_AFTER clause, 12
FOLD_BEFORE clause, 12
font
changing face and size in command-line, 1.2
footers
aligning elements, 12
displaying at bottom of page, 12
displaying system-maintained values, 12
formatting elements, 12
indenting, 12
listing current definition, 12
setting at the end of reports, 6.3
suppressing definition, 12
FORCE clause, 12
FORMAT clause, 12, 12
in ATTRIBUTE command, 12
in COLUMN command, 6.1.2.2, 6.1.3.2
in REPHEADER and REPFOOTER commands, 12
in TTITLE and BTITLE commands, 6.3.2, 12
format models, number, 6.1.2.2, 12
formfeed, to begin a new page, 6.3.6, 12
FROM clause, 12, B.2.1

G

GET command, 12
LIST clause, 12
NOLIST clause, 12
retrieving scripts, 12
globalization support
Oracle10g, 11.3
glogin
profile, 12
See also login.sql
site profile, 2.2, 2.2.1, 2.2.2.1, 3.5.1.8, 12
GRANT command, 9.1
disabling, 9.2

H

HEAD clause, 3.5.1.6
HEAD option, 3.5.1.6
headers
aligning elements, 6.3.1.1
displaying at top of page, 12
displaying system-maintained values, 12
setting at the start of reports, 6.3
suppressing, 6.3.1
HEADING clause, 6.1.1.2, 12
HEADING variable, 12
headings
aligning elements, 12
column headings, 12
formatting elements, 12
indenting, 12
listing current definition, 12
suppressing definition, 12
HEADSEP variable, 12, 12
use in COLUMN command, 6.1.1.2
help
installing command-line, 2.2.4
online, 3.3.2, 12
HELP command, ? command, 12
HIDE clause, 12
HOST command, 4.9, 12
HTML, 7.1.1
clause, 3.5.1.6
entities, 7.1.3
option, 3.5.1.6
spooling to file, 3.5.1.6, 3.5.1.6
tag, 7.1
hyphen
continuing a long SQL*Plus command, 4.6.1.1, 12

I

IMMEDIATE mode, 12
infinity sign (~), 12
initialization parameters
displaying, 12, 12
INIT.ORA file
parameter file, 12
input
accepting [Return], 5.11.3
accepting values from the user, 5.11.1, 12
INPUT command, 5.2, 5.2.4, 12
entering several lines, 12
INSERT clause, B.1.1, B.2.2
INSERT command
disabling, 9.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 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
installation, UNIX and Linux files to copy, D.3.1
installation, Windows files to copy, D.3.2
INSTANCE variable, 12, 12
instances
shutting down, 12
starting, 12
Instant Client
SQL*Plus, D
Instant Client packages, D.1
iSQL*Plus
configuring Oracle Net, 2.2.5

J

Japanese
JUSTIFY clause, 12, 12

L

LABEL variable
SHOW command, C.1
labels
in COMPUTE command, 6.2.6, 12
language
SQL*Plus Instant Client, D.1.2
LD_LIBRARY_PATH
environment variables, 2.1
LEFT clause, 6.3.1.1, 12, 12
lightweight OCI package, D.1.2
LIKE clause, 6.1.4, 12, 12
limits, SQL*Plus, A
lines
adding at beginning of buffer, 12
adding at end of buffer, 12
adding new after current, 5.2.4, 12
appending text to, 5.2.3, 12
changing width, 6.3.6, 8.5.6, 12, 12
deleting all in buffer, 12
deleting from buffer, 5.2.5, 12
determining which is current, 5.2.2
editing current, 5.2.2
listing all in buffer, 5.2, 12
removing blanks at end, 12
LINESIZE variable, 6.3.1.1, 6.3.6, 12, 12
Linux
installing SQL*Plus Instant Client, D.2.1
SQL*Plus Instant Client files to copy, D.3.1
LIST clause, 12, 12
LIST command, 5.2, 12
determining current line, 5.2.2, 12
making last line current, 5.2.2, 12
using an asterisk, 5.2, 12
LNO clause, 12
LOBOFFSET variable, 12, 12
LOCAL
environment variables, 2.1
LOCK TABLE command
disabling, 9.2
LOG_ARCHIVE_DEST parameter, 12
LOGFILE clause, 12
logging off
conditionally, 12, 12
Oracle Database, 3.1, 12
SQL*Plus, 3.4, 12
logging on
Oracle Database, 12
SQL*Plus, 3.3.1
login
user profile, 2.2.2.1
login.sql, 2.2.2
LONG
column definition from DESCRIBE, 12
LONG columns
changing format, 12
default format, 12
setting maximum width, 12, 12, 12
setting retrieval size, 8.5.7, 8.5.7, 12, 12, 12
LONG variable, 12, 12
effect on COPY command, B.1.2, B.2.3
LONGCHUNKSIZE variable, 6.1.3.1, 12, 12, 12, 12
LONGRAW
column definition from DESCRIBE, 12

M

-MARKUP, 3.5.1.6, 3.5.1.6, 7.1, 7.1, 12
BODY clause, 3.5.1.6
ENTMAP clause, 3.5.1.6
HEAD clause, 3.5.1.6
PREFORMAT clause, 3.5.1.6
SQLPLUS command clause, 3.5.1.6
TABLE clause, 3.5.1.6
MAXDATA variable, C.1, C.10
media recovery, 12
MERGE command
disabling, 9.2
message, sending to screen, 5.11.1, 12
MOUNT clause, 12
mounting a database, 12

N

national language support
See also globalization support
NCHAR clause
VARIABLE command, 12
NCHAR columns
changing format, 12
default format, 6.1.3.1, 6.1.3.1, 12
NCLOB clause
VARIABLE command, 12
NCLOB columns
changing format, 12
default format, 12
setting maximum width, 12, 12
setting retrieval position, 12, 12
setting retrieval size, 8.5.7, 12, 12, 12
negative infinity sign (-~), 12
net service name, 3.2.1, 3.2.2
new features, Preface
NEW_VALUE clause, 6.3.4, 12
storing current date in variable for titles, 12
NEWLINE clause, 12
NEWPAGE command, C.1, C.5
NEWPAGE variable, 6.3.6, 12, 12
NEXT clause, 12
NLS
NLS_DATE_FORMAT, 12, 12
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
NOAUDIT command
disabling, 9.2
NODE variable, 12
NODE XQUERY option, 12
NOLIST clause, 12
NOLOG, 3.2.4, 3.5.2
NOMOUNT clause, 12
NONE clause
WHENEVER OSERROR, 12
WHENEVER SQLERROR, 12
NOPARALLEL clause, 12
NOPRINT clause, 6.2.6, 6.3.4, 8.5.1, 12
NOPROMPT clause, 12
NORMAL mode, 12
Notepad on Windows, 12
NULL clause, 12
null values
setting text displayed, 12, 12, 12
NULL variable, 12, 12
NUMBER
column definition from DESCRIBE, 12
NUMBER clause, 5.11.2
VARIABLE command, 12
NUMBER columns
changing format, 6.1.2.1, 12
default format, 6.1.2.1, 12
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, 5.9.4, 12, 12
NUMFORMAT clause
in LOGIN.SQL, 2.2.2.1
NUMFORMAT variable, 12, 12
NUMWIDTH variable, 12, 12
effect on NUMBER column format, 6.1.2.1, 12
NVARCHAR2 columns
changing format, 12
default format, 6.1.3.1, 12

O

objects, describing, 12
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
in ATTRIBUTE command, 12
in COLUMN command, 6.1.6, 12
in REPFOOTER commands, 12
in REPHEADER commands, 12
in SPOOL command, 6.4, 12
in TTITLE and BTITLE commands, 6.3.3, 12
OLD_VALUE clause, 6.3.4, 12
ON clause
in ATTRIBUTE command, 12
in COLUMN command, 6.1.6, 12
in TTITLE and BTITLE commands, 6.3.3
ON column clause
in BREAK command, 12
in COMPUTE command, 6.2.6, 12
ON expr clause
in BREAK command, 12
in COMPUTE command, 12
ON REPORT clause
in BREAK command, 6.2.7, 12
in COMPUTE command, 6.2.7, 12
ON ROW clause
in BREAK command, 6.2.3, 12
in COMPUTE command, 12
online help, 3.3.2, 3.3.2, 12
OPEN clause, 12
opening a database, 12
operating system
editor, 5.1.1, 12, 12
file, loading into buffer, 12
running commands from SQL*Plus, 4.9, 12
text editor, 5.1.1
ORA_NLS10
environment variables, 2.1
Oracle Database Client, D
Oracle Net
configuring, 2.2.5
connect identifier, 12
ORACLE_HOME
environment variables, 2.1
ORACLE_PATH
environment variables, 2.1
ORACLE_SID
environment variables, 2.1
Oracle10g
globalization support, 11.3
ORDER BY clause
displaying column values in titles, 6.3.4
displaying values together in output, 6.2
ORDERING variable, 12
ORDERING XQUERY option, 12
OUT clause, 6.4.3, 12
output
formatting white space in, 8.5.11, 12
pausing during display, 4.10, 12

P

packages
SQL*Plus and OCI for Instant Client, D.1
PAGE clause, 12
page number, including in titles, 6.2.4, 6.3.2
pages
changing length, 6.3.6, 8.5.8, 12, 12
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, 12
parameter, 5.10, 12, 12, 12
SQLPATH, 2.1.1
parameter files (INIT.ORA files)
specifying alternate, 12
PARAMETERS clause, 12, 12
password
changing with the PASSWORD command, 12
in CONNECT command, 3.1, 12
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, 12
PATH
environment variables, 2.1
PAUSE command, 5.11.3, 12
PAUSE variable, 4.10, 12, 12
performance
of SQL statements, 8.1
over dial-up lines, 12
period (.)
terminating PL/SQL blocks, 4.5, 12, 12
PLAN_TABLE
creating, 8.1.1
table, 8.1.1
PL/SQL, 4.5
blocks, PL/SQL, 4.5
executing, 12
formatting output in SQL*Plus, 12
listing definitions, 4.3
mode in SQL*Plus, 4.5.1
within SQL commands, 4.5.1
PLUSTRACE
creating role, 8.1.1
role, 8.1.1
PNO clause, 12
pound sign (#), 12
predefined variable
_CONNECT_IDENTIFIER, 2.2.2.1, 12, 12
_DATE, 12, 12
_EDITOR, 5.1.1, 12, 12, 12, 12
_O_RELEASE, 12, 12
_O_VERSION, 12, 12
_PRIVILEGE, 12, 12
_RC, 12
_SQLPLUS_RELEASE, 12, 12, 12
_USER, 12, 12
PREFORMAT, 3.5.1.6
PREFORMAT clause, 3.5.1.6
PRINT clause, 12
PRINT command, 12
printing
bind variables automatically, 12
REFCURSOR variables, 12
SPOOL command, 12
Product User Profile table, 9.1
prompt
SET SQLPROMPT, 8.5.10, 12, 12
PROMPT clause, 5.11.1, 12
PROMPT command, 5.11.1, 12
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
PUPBLD.SQL, 9.1.1
PURGE command
disabling, 9.2

Q

queries
in COPY command, B.1.1, B.2.1
show number of records retrieved, 4.4, 12, 12
tracing, 8.3, 8.4
query execution path
including in report, 12
query results
displaying on-screen, 4.4
sending to a printer, 6.4.3, 12
storing in a file, 6.4.2, 12
QUIT command, 12
See also EXIT

R

RAW
column definition from DESCRIBE, 12
record separators, printing, 6.1.7, 12, 12
RECOVER clause, 12
RECOVER command, 12
and database recovery, 10.4
AUTOMATIC clause, 12
CANCEL clause, 12, 12
CONTINUE clause, 12
DATABASE clause, 12
FROM clause, 12
LOGFILE clause, 12
NOPARALLEL clause, 12
STANDBY DATABASE clause, 12
STANDBY DATAFILE clause, 12
STANDBY TABLESPACE clause, 12, 12
UNTIL CANCEL clause, 12
UNTIL CONTROLFILE clause, 12
UNTIL TIME clause, 12
USING BACKUP CONTROL FILE clause, 12
recovery
RECOVER command, 12
RECSEP variable, 6.1.7, 12, 12
RECSEPCHAR variable, 6.1.7, 12, 12
redo Log Files
ARCHIVE LOG command, 12
REFCURSOR bind variables
in a stored function, 5.13
REFCURSOR clause
VARIABLE command, 12
registry
editor, 2.1.1
registry entry
SQLPATH, 2.1, 2.1.1
RELEASE clause, 12
REMARK command, 5.3.1, 12
removing sample tables, Preface
RENAME command
disabling, 9.2
REPFOOTER clause, 12
REPFOOTER command, 6.3.1, 12
aligning footer elements, 12
BOLD clause, 12
CENTER clause, 12
COL clause, 12
FORMAT clause, 12
indenting report footers, 12
LEFT clause, 12
OFF clause, 12
RIGHT clause, 12
SKIP clause, 12
suppressing current definition, 12
TAB clause, 12
REPHEADER clause, 12
REPHEADER command, 6.3.1, 12
aligning header elements, 6.3.1.1
aligning heading elements, 12
BOLD clause, 12
CENTER clause, 12
COL clause, 12
FORMAT clause, 12
indenting headings, 12
LEFT clause, 12
OFF clause, 12
PAGE clause, 12
RIGHT clause, 12
SKIP clause, 12
suppressing current definition, 12
TAB clause, 12
REPLACE clause
in COPY command, B.1.1, B.2.2
in SAVE command, 12, 12
reports
autotrace, 8.1.1
breaks, 12
clarifying with spacing and summary lines, 6.2
columns, 12
creating bottom titles, 6.3, 12, C.1, C.1
creating footers, 12
creating headers, 12
creating headers and footers, 6.3
creating master/detail, 6.3.4, 12, 12
creating top titles, 6.3, 12, C.1
displaying, 12, 12
formatting column headings, 6.1.1.2, 12
formatting columns, 6.1.2.1, 6.1.3.1, 12
interactive HTML example, 7.1.1, 7.1.1
on the web, 7.1
SILENT mode, 7.1.2
starting on a new page, 12
title, 12, C.1
RESTRICT, 3.5.1.8, 9.4, 12
return code, specifying, 5.6, 12, 12
REVOKE command, 9.1
disabling, 9.2
RIGHT clause, 6.3.1.1, 12, 12
roles, 9.3
disabling, 9.3.2
re-enabling, 9.3.2
ROLLBACK clause, 12
WHENEVER OSERROR, 12
WHENEVER SQLERROR, 12
ROLLBACK command
disabling, 9.2
ROWID
column definition from DESCRIBE, 12
rows
performing computations on, 6.2.6, 12
setting number retrieved at one time, 8.5.3, 12, 12
setting the number after which COPY commits, 12
RUN command, 12
executing current PL/SQL block, 4.5
making last line current, 5.2.2
similar to /(slash) command, 12

S

sample schemas, Preface, Preface, Preface, Preface, Preface
see Oracle Database Sample Schemas guide, Preface
using HR in COLUMN example, 12
using HR in examples, 5, 6
sample tables
access to, Preface
creating, Preface
removing, Preface
unlocking, Preface
SAVE command, 12
APPEND clause, 12
CREATE clause, 12
REPLACE clause, 12
storing commands in scripts, 12
using with INPUT to create scripts, 5.1.1
SAVEPOINT command
disabling, 9.2
saving environment attributes, 12
SCAN variable, C.1, C.11
schemas
command, 13.1
database, 8.1.1
database default, 12
DESCRIBE parameter, 12
disabled commands, 13.1
HR sample, Preface, Preface
installing own copy of HR, Preface
sample, Preface
SHOW parameter, 12, 12
unlocking HR, Preface
using HR in COLUMN example, 12
using HR in examples, 5, 6
SCREEN clause, 5.11.4, 12
screens
clearing, 5.11.4, 12
scripts
extension, 12, 12, 12
registering, 8.5.2
scripts, authenticating users in, 3.1.1
security
changing password, 12
password viewable, 3.5.2
PRODUCT_USER_PROFILE table, 9.1
RESTRICT, 3.5.1.8, 9.4
SELECT command
and BREAK command, 6.2, 12, 12, 12
and COLUMN command, 12
and COMPUTE command, 6.2
and COPY command, B.1.1, B.2.1
and DEFINE command, 12
and ORDER BY clause, 6.2
disabling, 9.2
formatting results, 5.13
semicolon (;)
in PL/SQL blocks, 4.5
in SQL commands, 4.4, 4.4.1.2
in SQL*Plus commands, 4.6.1, 12
not stored in buffer, 5.2.1
SERVEROUTPUT variable, 12
service name
in COPY command, B.2.1, B.2.2, B.3
SET AUTOTRACE, 8.1.1
SET clause, 12
SET command, 2.2.3, 4.7, 12
APPINFO variable, 8.5.2, 12
ARRAYSIZE variable, 8.5.3, 12, 12, B.2.3
AUTOCOMMIT variable, 12, 12
AUTOPRINT variable, 12, 12, 12
AUTORECOVERY variable, 12, 12
AUTOTRACE variable, 12, 12
BLOCKTERMINATOR variable, 12, 12
BUFFER variable, C.6
CLOSECURSOR variable, C.1, C.8
CMDSEP variable, 12, 12
COLSEP variable, 6.4.1, 12, 12
COMPATIBILITY variable, C.1, C.7
CONCAT variable, 5.9.4, 5.9.4, 12, 12
COPYCOMMIT variable, 12, 12, B.2.3
COPYTYPECHECK variable, 12, 12
DEFINE clause, 5.9.4
DEFINE variable, 12
DESCRIBE variable, 12, 12
DOCUMENT variable, C.1, C.9
ECHO variable, 12, 12
EDITFILE variable, 12, 12
EMBEDDED variable, 12, 12
ERRORLOGGING variable, 12
ESCAPE variable, 5.9.4, 12, 12, 12, 12
ESCCHAR variable, 12
FEEDBACK variable, 12, 12
FLAGGER variable, 12, 12
FLUSH variable, 8.5.5, 12, 12
HEADING variable, 12
HEADSEP variable, 6.1.1.2, 12, 12
INSTANCE variable, 12, 12
LINESIZE variable, 6.3.1.1, 6.3.6, 12, 12
LOBOFFSET variable, 12, 12
LOGSOURCE variable, 12, 12
LONG variable, 12, 12, B.2.3
LONGCHUNKSIZE variable, 12, 12
MARKUP clause, 12
MAXDATA variable, C.1, C.10
NEWPAGE variable, 6.3.6, 12, 12
NULL variable, 12, 12
NUMFORMAT clause, 2.2.2.1
NUMFORMAT variable, 12, 12
NUMWIDTH variable, 6.1.2.1, 12, 12, 12
PAGESIZE clause, 2.2.2.1
PAGESIZE variable, 4.4, 6.3.6, 8.5.8, 12, 12
PAUSE variable, 12, 12
RECSEP variable, 6.1.7, 12, 12
RECSEPCHAR variable, 6.1.7, 12, 12
SCAN variable, C.1, C.11
SERVEROUTPUT variable, 12
SHIFTINOUT variable, 12, 12
SPACE variable, C.1, C.12
SQLBLANKLINES variable, 12
SQLCASE variable, 12, 12
SQLCONTINUE variable, 12, 12
SQLNUMBER variable, 12, 12
SQLPLUSCOMPATIBILITY variable, 12, 12
SQLPREFIX variable, 12, 12
SQLPROMPT variable, 8.5.10, 12, 12
SQLTERMINATOR variable, 12, 12
substitution variable, 12
SUFFIX variable, 12, 12
TAB variable, 8.5.11, 12, 12
TERMOUT variable, 8.5.12, 12, 12
TIME variable, 12, 12
TIMING variable, 12, 12
TRIMOUT variable, 12, 12
TRIMSPOOL variable, 12, 12
TRUNCATE variable, C.1, C.13
UNDERLINE variable, 12, 12
used to format a REFCURSOR variable, 12
VERIFY clause, 5.9.1
VERIFY variable, 5.9.4, 5.9.4, 12, 12
WRAP variable, 6.1.3.2, 12, 12
XQUERY BASEURI variable, 12
XQUERY CONTEXT variable, 12
XQUERY NODE variable, 12
XQUERY ORDERING variable, 12
SET CONSTRAINTS command
disabling, 9.2
SET MARKUP
BODY clause, 3.5.1.6
ENTMAP clause, 3.5.1.6, 7.1.3
HEAD clause, 3.5.1.6
HTML, 3.5.1.6
interactive HTML example, 7.1.1, 7.1.1
PREFORMAT clause, 3.5.1.6
TABLE clause, 3.5.1.6
SET ROLE command
disabling, 9.2
SET system variable summary, 12
SET TRANSACTION command
disabling, 9.2
SET variables, 4.7
See system variables
SET XQUERY BASURI, 12
SET XQUERY CONTEXT, 12
SET XQUERY NODE, 12
SET XQUERY ORDERING, 12
SGA clause, 12
SHIFTINOUT variable, 12, 12
SHOW
schema parameter, 12, 12
SHOW clause, 12
SHOW command, 4.7, 12
ALL clause, 12
BTITLE clause, 12
ERRORS clause, 12
LABEL variable, C.1
listing current page dimensions, 6.3.6
LNO clause, 12
PNO clause, 12
RELEASE clause, 12
REPFOOTER clause, 12
REPHEADER clause, 12
SPOOL clause, 12
SQLCODE clause, 12
TTITLE clause, 12
USER clause, 12
XQUERY clause, 12
SHOWMODE variable, 12, 12
SHUTDOWN command, 12, 12
ABORT, 12
IMMEDIATE, 12
NORMAL, 12
TRANSACTIONAL LOCAL, 12
-SILENT option, 3.5.1.9, 7.1.2
site profile
glogin, 2.2, 2.2.1, 2.2.2.1, 3.5.1.8, 12, 12
SKIP clause
in BREAK command, 6.2.2, 6.2.3, 12
in REPHEADER and REPFOOTER commands, 12
in TTITLE and BTITLE commands, 6.3.1.1, 12
used to place blank lines before bottom title, 6.3.1.1
SKIP PAGE clause, 6.2.2, 6.2.3, 12
slash (/) command, 12
files loaded with GET command, 12
SPACE variable, C.1, C.12
SPOOL clause, 3.5.1.6, 12
SPOOL command, 6.3.6, 12
APPEND clause, 12
CREATE clause, 12
file name, 6.4.2, 12
OFF clause, 6.4, 12
OUT clause, 6.4.3, 12
REPLACE clause, 12
to HTML file, 3.5.1.6, 3.5.1.6
turning spooling off, 6.4, 12
use with SET MARKUP, 7.1.1
SQL clause, 12
SQL DML statements
reporting on, 12, 12
SQL optimizer, 8.1.2
SQL*Plus
command prompt, 3.3.1
command summary, 12
configuring globalization support, 11.1
database administration, 10.1
environment variables, 2.1
error messages, 13.1
execution plan, 8.1.2
exiting, 3.4, 12, 12
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, Preface
SQL*Plus and OCI packages, D.1
SQL*Plus command-line vs SQL*Plus Instant Client, D
SQL*Plus Instant Client, D, D, D.1, 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, 12
SQLCASE variable, 12, 12
SQLCODE clause, 12
SHOW command, 12
SQLCONTINUE variable, 12, 12
SQL.PNO, referencing in report titles, 6.3.2
SQLNUMBER variable, 12, 12, 12, 12
SQLPATH
environment variables, 2.1
registry entry, 2.1, 2.1.1
SQLPLUS
environment variables, 2.1
SQLPLUS command, 3.3.1
- clause, 3.5.1.1
-? clause, 3.5.1.2
and @ (at sign), 3.5
and EXIT FAILURE, 3.4
BODY option, 3.5.1.6
commands
SQLPLUS, 3.5
connect identifier, 3.5.2
display syntax, 3.5.1.1
ENTMAP option, 3.5.1.6
HEAD option, 3.5.1.6
HTML option, 3.5.1.6
-MARKUP clause, 3.5.1.6
-MARKUP option, 3.5.1.6
/NOLOG clause, 3.5.2
PREFORMAT option, 3.5.1.6
RESTRICT, 3.5.1.8, 9.4
service name, 3.5.2
-SILENT clause, 3.5.1.9
-SILENT option, 3.5.1.9, 7.1.2
SPOOL clause, 3.5.1.6
syntax, 3.5
SYSDBA 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, 12
SQLPROMPT variable, 8.5.10, 12, 12
SQL.SQLCODE
using in EXIT command, 12
SQLTERMINATOR variable, 12, 12, 12, 12
STANDBY DATAFILE clause, 12
STANDBY TABLESPACE clause, 12
START clause, 12, 12
START command, 5.4, 12
arguments, 5.10
passing parameters to a script, 5.10
script, 5.4, 12
similar to @ (at sign) command, 5.4, 12, 12
similar to @@ (double at sign) command, 12
starting
SQL*Plus, 1.1, 3.3, 3.3.1
STARTUP command, 12
FORCE clause, 12
MOUNT clause, 12
NOMOUNT clause, 12
OPEN clause, 12
PFILE clause, 12
RECOVER clause, 12
RESTRICT clause, 12
specifying a database, 12
statistics, 8.1.3
collecting TIMING statistics, 8.2
STOP clause, 12, 12
stop query, 4.8
STORE command, 2.2.3, 12
SET clause, 12
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, 12
_EDITOR, 12
appending characters immediately after, 5.9.1
avoiding unnecessary prompts for value, 5.9.2
concatenation character, 12, 12
DEFINE command, 12
defining, 5.7, 5.9.2, 12
deleting, 5.7, 12
displaying in headers and footers, 12
displaying in titles, 12
in ACCEPT command, 5.11.1, 12
listing definitions, 5.7, 5.7, 12, 12
parsing, 8.5.4
prefixing, 12, 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, 12
used with EDIT command, 12
used with GET command, 12
used with SAVE command, 12
used with START command, 12
SUM function, 6.2.6
summary lines
computing and printing, 6.2.6, 12
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 commands, 4.4.1
SQL*Plus commands, 4.6.1
SYSDBA clause, 12
SYSOPER clause, 3.5.2, 12
system variables, 4.7, 12
affecting SQL*Plus performance, 8.5
affecting substitution variables, 5.9.4
listing current settings, 4.7, 12
listing old and new values, 12, 12
storing and restoring, 2.2.3
summary of SET commands, 12
system-maintained values
displaying in headers and footers, 12
displaying in titles, 6.3.2, 12
formatting in titles, 6.3.2

T

TAB clause, 12, 12
TAB variable, 8.5.11, 12, 12
TABLE clause, 3.5.1.6
TABLE option, 3.5.1.6
tables
access to sample, Preface
controlling destination when copying, B.1.1, B.2.2
copying values between, B.2, B.3
listing column definitions, 4.2, 12
referring to another user's when copying, B.2.4
TABLESPACE clause, 12
tablespaces, recovering, 12
tag, HTML, 7.1
TERMOUT variable, 8.5.12, 12, 12
using with SPOOL command, 12
territory
SQL*Plus Instant Client, D.1.2
text, 3.5.1.6, 3.5.1.6
adding to current line with APPEND, 5.2.3, 12
changing old to new with CHANGE, 5.2.2, 12
clearing from buffer, 5.2, 12
text editor
operating system, 5.1.1, 12
TIME variable, 12, 12
TIMING clause, 12
TIMING command, 8.2, 12
deleting all areas created by, 12
deleting current area, 12
SHOW clause, 12
START clause, 12
STOP clause, 12
TIMING variable, 12, 12
titles
aligning elements, 6.3.1.1, 12
displaying at bottom of page, 6.3, 12, C.1, C.1
displaying at top of page, 6.3, 12, C.1
displaying column values, 6.3.4, 12, 12
displaying current date, 6.3.5, 12, 12
displaying page number, 6.3.2, 12
displaying system-maintained values, 6.3.2, 12
formatting elements, 12
formatting system-maintained values in, 6.3.2
indenting, 6.3.1.2, 12
listing current definition, 6.3.3, 12, 12
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, 12, C.1
setting lines from top title to end of page, 8.5.8, 12, 12
setting top and bottom, 6.3, 12, 12, C.1, C.1, C.1
spacing between last row and bottom title, 6.3.1.1
suppressing definition, 6.3.3, 12
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, 12
TRIMSPOOL variable, 12, 12
TRUNCATE command
disabling, 9.2
TRUNCATE variable, C.1, C.13
TRUNCATED clause, 6.1.3.2, 12
TTITLE clause, 12
TTITLE command, 6.3.1, 12
aligning title elements, 6.3.1.1, 12
BOLD clause, 12
CENTER clause, 6.3.1.1, 12
COL clause, 6.3.1.2, 12
FORMAT clause, 6.3.2, 12
indenting titles, 6.3.1.2, 12
LEFT clause, 6.3.1.1, 12
listing current definition, 6.3.3, 12
OFF clause, 6.3.3, 12
old form, C.14
ON clause, 6.3.3
referencing column value variable, 6.3.4, 12
restoring current definition, 6.3.3
RIGHT clause, 6.3.1.1, 12
SKIP clause, 6.3.1.1, 12
suppressing current definition, 6.3.3, 12
TAB clause, 12
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
and DEFINE command, 12
UNDERLINE variable, 12, 12
unicode
UNIX
ed, 12
installing SQL*Plus Instant Client, D.2.2
SQL*Plus Instant Client files to copy, D.3.1
unlocking sample tables, Preface
UNTIL CANCEL clause, 12
UNTIL CHANGE clause, 12
UNTIL CONTROLFILE clause, 12
UNTIL TIME clause, 12
UPDATE command, disabling, 9.2
USER clause, 12
user profile, 2.2.2
glogin.sql, 2.2.2
login.sql, 2.2.2, 2.2.2.1
See also site profile
user variable
See substitution variable
username, 3.1
connecting under different, 3.1, 12
in CONNECT command, 3.1, 12
in COPY command, B.2.1, B.2.2, B.3
in SQLPLUS command, 3.3.1, 3.5.2
USING BACKUP CONTROL FILE clause, 12
USING clause, B.1.1, B.2.1
UTF-8

V

V$SESSION virtual table, 12
V$SQLAREA virtual table, 12
VALIDATE command
disabling, 9.2
VARCHAR columns
default format, 6.1.3.1
VARCHAR2
column definition from DESCRIBE, 12
VARCHAR2 clause
VARIABLE command, 12
VARCHAR2 columns
changing format, 12
default format, 6.1.3.1
VARIABLE command, 12
BFILE clause, 12
BINARY_DOUBLE clause, 12
BINARY_FLOAT clause, 12
BLOB clause, 12
CHAR clause, 12
CLOB clause, 12
NCHAR clause, 12
NCLOB clause, 12
NUMBER clause, 12
REFCURSOR clause, 12
VARCHAR2 clause, 12
variable clause, 12
variables
bind variables, 5.12
substitution variables, 12
system variables, 4.7
VERIFY clause, 5.9.1
VERIFY variable, 5.9.4, 5.9.4, 12, 12

W

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

X

XMLType
column definition from DESCRIBE, 12
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
setting maximum column width, 12
XQUERY clause, 12
XQUERY command, 12
XQUERY options
BASURI, 12
CONTEXT, 12
NODE, 12
ORDERING, 12