Skip Headers

SQL*Plus® User's Guide and Reference
Release 10.1

Part Number B12170-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
Feedback

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), 6.3.3
- (hyphen)
clause, 4.5.1.2
continuing a long SQL*Plus command, 5.6.1.1, 13
. (period), 5.5
/ (slash) command
default logon, 4.5.2, 13
entered at buffer line-number prompt, 5.4.1.2, 13
entered at command prompt, 13
executing current PL/SQL block, 5.5
similar to RUN, 13, 13
usage, 13
", 6.2, 6.2
listing all lines, 6.2
" list command, 6.2
# pound sign
overflow indication, 13
SET SQLPREFIX character, 13
$ number format, 7.1.2.2
& (ampersand)
disabling substitution variables, 6.9.4
substitution variables, 6.9
&&, 6.9.2
* (asterisk)
in DEL command, 6.2, 13
in LIST command, 6.2, 13
/*...*/ (comment delimiters), 6.3.2
: (colon)
bind variables, 6.13
:BindVariable clause
EXIT command, 13
; (semicolon), 5.4
@ ("at" sign)
command, 3.2.3.1, 6.4, 13
in CONNECT command, 13
in COPY command, B.1, B.2.1
in SQLPLUS command, 4.5
script, 6.4
similar to START, 6.4, 13, 13
@@ (double "at" sign) command, 3.2.3.1, 13
script, 13
similar to START, 13, 13
[Cancel] key, 5.8
_CONNECT_IDENTIFIER predefined variable, Preface, Preface, 3.2.2.1, 13, 13
_DATE predefined variable, 13, 13
_EDITOR predefined variable, 2.2.3.2, 6.1.1, 13, 13, 13, 13
_EDITOR substitution variable, 13
_EDITOR, in EDIT command, 6.1.1, 13, 13
_O_RELEASE predefined variable, 13, 13
_O_VERSION predefined variable, 13, 13
_PRIVILEGE predefined variable, Preface, 13, 13
_RC predefined variable, 13
_SQLPLUS_RELEASE predefined variable, 13, 13, 13
_USER predefined variable, 13, 13
~ infinity sign, 13
-~ negative infinity sign, 13

Numerics

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

A

ABORT mode, 13
abort query, 5.8
ACCEPT command, 6.12.1, 13, 13
and DEFINE command, 13
BINARY_DOUBLE clause, 13
BINARY_FLOAT clause, 13
customizing prompts for value, 6.12.2
DATE clause, 13
DEFAULT clause, 13
FORMAT clause, 13
HIDE clause, 13
NOPROMPT clause, 13
NUMBER clause, 6.12.2
PROMPT clause, 6.12.1, 13
access, denying and granting, 10.1
AFIEDT.BUF
See editor
alias, 4.2.2
ALIAS clause, 13, 13
in ATTRIBUTE command, 13
ALL clause, 13
ALTER command
disabling, 10.2
ampersands &(amp;)
in parameters, 6.11, 13
substitution variables, 6.9
ANALYZE command
disabling, 10.2
APPEND clause
in COPY command, B.1.1, B.2.2
in SAVE command, 13, 13
APPEND command, 6.2, 6.2.3, 13
APPINFO clause, 9.4.2, 13
Application Server
authentication, 2.3.3.2, 10.6.3
isqlplusctl utility, 4.3.4
port in use, 3.3.1
Product User Profile table, 10.6.5
starting, 4.3.4
starting the Windows service, 4.3.4
stopping, 4.3.6
test if running, 3.3.2
ARCH background process, 13
ARCHIVE LOG
command, 11.3.1, 13
mode, 11.3.1
argument
in START command, 6.11
ARRAYSIZE variable, 9.4.3, 13, 13
relationship to COPY command, B.1.2, B.2.3
ATTRIBUTE command, 13
ALIAS clause, 13
and CLEAR COLUMN command, 13
CLEAR clause, 13
clearing columns, 13, 13
controlling display characteristics, 13
display characteristics, 13
entering multiple, 13
FORMAT clause, 13
LIKE clause, 13
listing attribute display characteristics, 13, 13
OFF clause, 13
ON clause, 13
restoring column display attributes, 13
suppressing column display attributes, 13
AUDIT command
disabling, 10.2
authentication
adding username/password entries, 10.6.3
DBA access in iSQL*Plus, 10.6.2
AUTOCOMMIT variable, 5.11, 13, 13
AUTOMATIC clause, 13
AUTOPRINT variable, 13, 13
AUTORECOVERY variable, 13, 13
autotrace report, 9.1.1
AUTOTRACE variable, 9.1.1, 13, 13

B

background process
startup after abnormal termination, 13
batch mode, 13
BEGIN command, 5.5
disabling, 10.2
BINARY_DOUBLE clause
ACCEPT command, 13
VARIABLE command, 13
BINARY_FLOAT clause
ACCEPT command, 13
VARIABLE command, 13
bind variables, 6.13
creating, 13
displaying, 13
displaying automatically, 13, 13
in PL/SQL blocks, 13
in SQL statements, 13
in the COPY command, 13
blank line
in PL/SQL blocks, 5.5
in SQL commands, 5.4.1.2
preserving in SQL commands, 13, 13
blocks, PL/SQL
continuing, 5.5
editing in buffer, 6.2
editing with system editor, 6.1, 13
entering and executing, 5.5
listing current in buffer, 6.2.1
saving current, 13
setting character used to end, 13, 13
stored in SQL buffer, 5.5
timing statistics, 13
within SQL commands, 5.5.1
BLOCKTERMINATOR, 13, 13, 13, 13
BODY clause, 4.5.1.5
BODY option, 4.5.1.5
BOLD clause, 13, 13
break columns, 7.2, 13
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
and SQL ORDER BY clause, 7.2, 7.2.1, 7.2.4, 13
clearing BREAKS, 7.2.5
displaying column values in titles, 7.3.4
DUPLICATES clause, 13
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
ON column clause, 7.2.1, 13
ON expr clause, 13
ON REPORT clause, 7.2.7, 13
ON ROW clause, 7.2.3, 13
printing "grand" and "sub" summaries, 7.2.7
printing summary lines at ends of reports, 7.2.7
removing definition, 13
SKIP clause, 7.2.3, 13
SKIP PAGE clause, 7.2.2, 7.2.2, 7.2.3, 13
specifying multiple break columns, 7.2.4, 13
suppressing duplicate values, 7.2.1
used in conjunction with COMPUTE, 7.2.6
used in conjunction with SET COLSEP, 13
used to format a REFCURSOR variable, 13
used with COMPUTE, 13, 13, 13, 13, 13
break definition
listing current, 7.2.5, 13
removing current, 7.2.5, 13
BREAKS clause, 7.2.5, 13
browser, web, 8.1.1
BTITLE clause, 13
BTITLE command, 7.3.1, 13
aligning title elements, 13
BOLD clause, 13
CENTER clause, 13
COL clause, 13
FORMAT clause, 13
indenting titles, 13
LEFT clause, 13
OFF clause, 13
old form, C.2
printing blank lines before bottom title, 7.3.1.1
referencing column value variable, 13
RIGHT clause, 13
SKIP clause, 13
suppressing current definition, 13
TAB clause, 13
TTITLE command, 13
buffer, 5.1.1
appending text to a line in, 6.2.3, 13
clearing your screen, 2.2.3.2
delete a single line, 6.2
delete the current line, 6.2
delete the last line, 6.2
deleting a range of lines, 6.2, 13
deleting a single line, 13
deleting all lines, 6.2, 13, 13
deleting lines from, 6.2.5, 13
deleting the current line, 13
deleting the last line, 13
executing contents, 13, 13
inserting new line in, 6.2.4, 13
listing a range of lines, 6.2, 13
listing a single line, 6.2, 13
listing all lines, 6.2, 13
listing contents, 6.2.1, 13
listing the current line, 6.2, 13
listing the last line, 6.2, 13
loading into system editor, 13
saving contents, 13
screen area, 2.2.3.4
SQL, 2.2.3.1
BUFFER clause, 6.1.1, 6.2, 13
BUFFER variable, C.5
buttons
cancel, 2.3.7.3, 2.3.8.1, 2.3.8.1, 4.1.2.6, 6.10.1.3
clear screen, 2.3.4.1
execute, 2.3.4.2
load script, 2.3.4.3
log in, 2.3.2.4, 2.3.3.7
save script, 2.3.4.4

C

cancel button, 2.3.7.3, 2.3.8.1, 2.3.8.1, 4.1.2.6, 6.10.1.3
CANCEL clause, 13, 13
cancel query, 5.8
cancelling an in-progress operation, 2.2.3.1
CENTER clause, 7.3.1.1, 13, 13
CHANGE command, 6.2, 6.2.2, 13
Change Password screen, 4.1.2
CHAR clause
VARIABLE command, 13
CHAR columns
changing format, 13
default format, 7.1.3.1
definition from DESCRIBE, 13
Character Map Windows utility
choosing a font, 2.1.2.2, 2.2.4.2
CLEAR clause, 7.1.5, 13
in ATTRIBUTE command, 13
CLEAR command, 13
BREAKS clause, 7.2.5, 13
BUFFER clause, 6.1.1, 6.2, 13
COLUMNS clause, 13
COMPUTES clause, 13
SCREEN clause, 6.12.4, 13
SQL clause, 13
TIMING clause, 13
clear screen button, 2.3.4.1
clearing your screen, 2.2.3.2
client tier, 1.2, 1.3
CLOB clause
VARIABLE command, 13
CLOB columns
changing format, 13
default format, 13
setting maximum width, 13, 13
setting retrieval position, 13, 13
setting retrieval size, 9.4.7, 13, 13, 13
CLOSECURSOR variable, C.1, C.6
CMDSEP variable, 13, 13
COL clause, 7.3.1.2, 13, 13
colons (:)
bind variables, 6.13
COLSEP variable, 13, 13
COLUMN command, 7.1, 13
ALIAS clause, 13
and BREAK command, 13
and DEFINE command, 13
CLEAR clause, 7.1.5, 13, 13
DEFAULT clause, C.3
displaying column values in bottom titles, 7.3.4, 13
displaying column values in top titles, 7.3.4, 13
entering multiple, 13
ENTMAP clause, 13
FOLD_AFTER clause, 13, 13, 13
FOLD_BEFORE clause, 13, 13
FORMAT clause, 7.1.2.2, 7.1.3.2, 13, 13
formatting a REFCURSOR variable, 13
formatting NUMBER columns, 7.1.2.1, 13
HEADING clause, 7.1.1.2, 13, 13
HEADSEP character, 13
JUSTIFY clause, 13
LIKE clause, 7.1.4, 13, 13
listing column display attributes, 7.1.5, 7.1.5, 13, 13
NEW_VALUE clause, 7.3.4, 13, 13
NEWLINE clause, 13, 13
NOPRINT clause, 7.3.4, 9.4.1, 13
NULL clause, 13, 13
OFF clause, 7.1.6, 13
OLD_VALUE clause, 7.3.4, 13, 13
ON clause, 7.1.6, 13
PRINT clause, 13
resetting a column to default display, C.1
resetting to default display, 7.1.5, 13, C.1
restoring column display attributes, 7.1.6, 13
storing current date in variable for titles, 13
suppressing column display attributes, 7.1.6, 13
TRUNCATED clause, 7.1.3.2, 13
WORD_WRAPPED clause, 7.1.3.2, 7.1.7, 13
WRAPPED clause, 7.1.3.2, 13
column headings
aligning, 13
changing, 7.1.1.1, 13
changing character used to underline, 13, 13
changing to two or more words, 7.1.1.2, 13
displaying on more than one line, 7.1.1.2, 13
suppressing printing in a report, 13, 13
when truncated, 13
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
column separator, 13, 13, C.1
columns
assigning aliases, 13
computing summary lines, 7.2.6, 13
copying display attributes, 7.1.4, 13, 13
copying values between tables, B.1, B.2, B.3
displaying values in bottom titles, 7.3.4, 13
displaying values in top titles, 7.3.4, 13
formatting CHAR, VARCHAR, LONG, and DATE, 13
formatting in reports, 7.1, 13
formatting MLSLABEL, RAW MLSLABEL, ROWLABEL, 13
formatting NUMBER, 7.1.2.1, 13
listing display attributes for all, 7.1.5, 13
listing display attributes for one, 7.1.5, 13
names in destination table when copying, B.1.1, B.2.1
printing line after values that overflow, 7.1.7, 13, 13
resetting a column to default display, 7.1.5, 13, C.1, C.1
resetting all columns to default display, 13
restoring display attributes, 7.1.6, 13, 13
setting printing to off or on, 7.3.4, 9.4.1, 13
starting new lines, 13
storing values in variables, 7.3.4, 13
suppressing display attributes, 7.1.6, 13, 13
truncating display for all when value overflows, 7.1.3.2, 13
truncating display for one when value overflows, 7.1.3.2, 13
wrapping display for all when value overflows, 7.1.3.2, 13
wrapping display for one when value overflows, 7.1.3.2, 13
wrapping whole words for one, 7.1.7
COLUMNS clause, 13
comma, number format, 7.1.2.2
command files
aborting and exiting with a return code, 6.6, 13, 13, 13
creating with a system editor, 6.1.1
creating with SAVE, 13, 13
editing with system editor, 13
in @ ("at" sign) command, 6.4, 13
in EDIT command, 13
in GET command, 13
in SAVE command, 6.1.1, 13
in SQLPLUS command, 4.5.3, 6.4.1
in START command, 6.4, 13
including comments in, 6.3, 13
including more than one PL/SQL block, 6.1.1
including more than one SQL command, 6.1.1
nesting, 6.5
opening, 2.2.3.1
passing parameters to, 6.11, 13
registering, 13, 13
retrieving, 13
running, 6.4, 13, 13
running a series in sequence, 6.5
running as you start SQL*Plus, 4.5.3, 6.4.1
running in batch mode, 6.6, 13
saving, 2.2.3.1
uniform resource locator, 13, 13, 13
command keys, SQL*Plus Windows GUI, 2.2.2
command prompt
SET SQLPROMPT, 9.4.10, 13, 13
SQL*Plus, 4.3.1
command-line
configuring globalization support, 12.1
command-line interface
changing face and size, 2.1.2
Euro sign, 2.1.2.2
special character, 2.1.2.2
Windows Character Map utility, 2.1.2.2
commands
collecting timing statistics on, 9.2, 13
copying text, 2.2.1
disabled in schema, 14.1
disabling, 10.2
echo on screen, 13
finding text, 2.2.3.3
host, running from SQL*Plus, 5.9, 13
listing current in buffer, 13
pasting text, 2.2.3.2
re-enabling, 10.2
spaces, 5.1
SQL
continuing on additional lines, 5.4.1.1
editing in buffer, 6.2
editing with system editor, 13
ending, 5.4.1.2
entering and executing, 5.4
entering without executing, 5.4.1.2
executing current, 13, 13
following syntax, 5.4.1
listing current in buffer, 6.2.1
saving current, 13
setting character used to end and run, 13
SQL*Plus
continuing on additional lines, 5.6.1.1, 13
ending, 5.6.1, 13
entering and executing, 5.6
entering during SQL command entry, 13
obsolete command alternatives, C.1
stopping while running, 5.8
tabs, 5.1
types of, 5.1
variables that affect running, 5.7
comments
including in command files, C.1
including in scripts, 6.3, 13, C.1
using -- to create, 6.3.3
using /*...*/ to create, 6.3.2
using REMARK, C.1
using REMARK to create, 6.3.1, 13, C.1
COMMIT clause, 13
WHENEVER OSERROR, 13
WHENEVER SQLERROR, 13
COMMIT command, 5.11
communication between tiers, 1.2.2, 1.3.3
COMPATIBILITY variable, 13, 13
compilation errors, 5.5.1, 13, 14.1
COMPUTE command, 7.2, 13
computing a summary on different columns, 7.2.8
LABEL clause, 7.2.6, 7.2.7, 13
listing all definitions, 7.2.9, 13
maximum LABEL length, 13
OF clause, 7.2.6
ON, 13
ON column clause, 7.2.6, 13
ON expr clause, 13
ON REPORT clause, 7.2.7, 13
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
referencing a SELECT expression in ON, 13
removing definitions, 7.2.9, 13
used to format a REFCURSOR variable, 13
COMPUTES clause, 13
CONCAT variable, 6.9.4, 6.9.4, 13, 13, 13, 13
configuration
globalization support
configuration parameter
iSQLPlusAllowUserMarkup, 3.1
iSQLPlusConnectIdList, 3.1
log4j.rootLogger, 3.1
configuring
cookies for iSQL*Plus, 3.4
javascript for iSQL*Plus, 3.4
Oracle Net, 3.2.4
SQL*Plus, 3
Windows GUI, 3.5
CONNECT command, 4.1, 13
and @ ("at" sign), 13
changing password, 13, 13, 13
SYSDBA clause, 4.5.2, 13, 13
SYSOPER clause, 4.5.2, 13
username/password, 13
connect identifier, 13
field, 2.3.2.3, 2.3.3.5
in CONNECT command, 13
in COPY command, B.1
in DESCRIBE command, 13
in SQLPLUS command, 4.5.2
connect port conflict, 3.3.1
connect string
See connection identifier
connection identifier, 4.2.1, 4.3.3.1
easy or abbreviated, 4.2.3
full, 4.2.2
net service name, 4.2.2
CONTINUE clause
WHENEVER OSERROR, 13
WHENEVER SQLERROR, 13
continuing a long SQL*Plus command, 5.6.1.1, 13
cookies, configuring for iSQL*Plus, 3.4
COPY command, 13, 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, 14.3
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, 13, 13
relationship to COPY command, B.1.2, B.2.3
copying text, 2.2.1, 2.2.3.2
COPYTYPECHECK variable, 13, 13
CREATE clause
in COPY command, B.1.1, B.2.2
CREATE command
disabling, 10.2
entering PL/SQL, 5.5.1
creating a PLAN_TABLE, 9.1.1
creating flat files, 7.4.1
creating PLUSTRACE role, 9.1.1
creating sample tables, 1.8.1
creating the PRODUCT_USER_PROFILE table, 10.1.1
cursor variables, 13

D

database
administrator, 11.1
connect identifier, 13
mounting, 13, 13
opening, 13, 13
database changes, saving automatically, 13, 13
DATABASE clause, 13
database files
recovering, 13
database name at startup, 13
database schema, 9.1.1
default, 13
DESCRIBE parameter, 13
SHOW, 13, 13
database tier, 1.3, 1.3
databases
connecting to default, 13
connecting to remote, 13
copying data between, B.1, B.2
copying data between tables on a single, B.3
disconnecting without leaving SQL*Plus, 4.1, 13
mounting, 11.2.1
opening, 11.2.1, 11.2.1
recovering, 11.4, 13
shutting down, 11.2, 11.2.2
starting, 11.2
DATAFILE clause, 13
DATE
column definition from DESCRIBE, 13
DATE clause, 13
DATE columns
changing format, 13, 13
default format, 7.1.3.1
date, storing current in variable for titles, 7.3.5, 13, 13
DB2, 13, 13
DBA, 11.1
connections, 3.3.6
DBA Login screen, 2.3.3
DBA Workspace, 2.3.5
iSQL*Plus access, 10.6.2
mode, 13
privilege, 2.3.3, 13
DBMS output, 9.4.9, 13
DBMS_APPLICATION_INFO package, 9.4.2, 13, 13
DECLARE command
disabling, 10.2
PL/SQL, 5.5
DEFAULT clause, 13
default port conflict, 3.3.1
DEFINE command, 6.7, 13
and system editor, 6.1.1, 13
and UNDEFINE command, 6.7, 13
CHAR values, 13
SET DEFINE ON|OFF, 13, 13
substitution variables, 13
DEFINE variable
See substitution variable
DEL command, 6.2, 6.2.5, 13
using an asterisk, 6.2, 13
DELETE command
disabling, 10.2
DESCRIBE command (SQL*Plus), 5.2, 13
connect_identifier, 13
PL/SQL properties listed by, 13
table properties listed by, 13
DISABLED keyword, disabling commands, 10.1.3
disabling
iSQL*Plus, 3.3.8
PL/SQL commands, 10.2
SQL commands, 10.2
SQL*Plus commands, 10.2
DISCONNECT command, 4.1, 13
DOCUMENT command, C.1, C.4
REMARK as newer version of, C.4, C.4
DOCUMENT variable, C.1, C.7
DROP command
disabling, 10.2
DUPLICATES clause, 13
dynamic reports, creating, 8.2

E

ECHO
SET command, 13
ECHO variable, 6.4, 13, 13
Ed on UNIX, 13
EDIT command, 6.1.1, 13, 13, 13
creating scripts with, 6.1.1
defining _EDITOR, 13
modifying scripts, 13
setting default file name, 13, 13
Edit menu, 2.2.3.2
EDITFILE variable, 13, 13
editor
defining, 2.2.3.2
invoking, 2.2.3.2
registry entries, 3.5.2.1
EDITOR operating system variable, 13
EMBEDDED variable, 13, 13
enabling iSQL*Plus, 3.3.8
Enter statements field, 2.3.6.1, 2.3.6.1, 2.3.6.2, 2.3.6.3
entities, HTML, 8.1.3
ENTMAP, 4.5.1.5
ENTMAP clause, 4.5.1.5, 8.1.3, 13
environment variables
iSQL*Plus, 3.1
LD_LIBRARY_PATH, 3.1
LOCAL, 3.1
NLS_LANG, 3.1
ORA_NLS10, 3.1
ORACLE_HOME, 3.1
ORACLE_PATH, 3.1
ORACLE_SID, 3.1
PATH, 3.1
SQL*Plus, 3.1
SQLPATH, 3.1
SQLPLUS, 3.1
TNS_ADMIN, 3.1
TWO_TASK, 3.1
error messages
COPY command, 14.3
interpreting, 5.12
iSQL*Plus, 14.2
sqlplus, 14.1
errors
compilation errors, 5.5.1, 13, 14.1
making line containing current, 6.2.2
escape characters, definition of, 13, 13
ESCAPE variable, 6.9.4, 13, 13
Euro sign
command-line interface, 2.1.2.2
GUI, 2.2.4, 2.2.4.2
example
interactive HTML report, 8.1.1, 8.1.1
execute button, 2.3.4.2
EXECUTE command, 13
executing
a CREATE command, 5.5.1
statements, 5.1.2
executing scripts
See running
execution plan, 9.1.2
execution statistics
including in report, 13
EXIT clause
WHENEVER OSERROR, 13
WHENEVER SQLERROR, 13
EXIT command, 4.4.1, 4.4.2, 13
:BindVariable clause, 13
COMMIT clause, 13
FAILURE clause, 13
in a script, 13
ROLLBACK clause, 13
use with SET MARKUP, 8.1.1
WARNING clause, 13
exit, conditional, 13
exiting
iSQL*Plus, Preface, 4.4.3
SQL*Plus GUI, 2.2.3.1
Expired Password screen, 4.1.4
extension, 13, 13, 13

F

FAILURE clause, 13
FEEDBACK variable, 13, 13
fields
connection identifier, 2.3.2.3, 2.3.3.5
enter statements, 2.3.6.1, 2.3.6.1, 2.3.6.2, 2.3.6.3
new password, 4.1.2.3
password, 2.3.2.2, 2.3.3.4
privilege, 2.3.3.6
script location, 2.3.8.4
username, 2.3.2.1, 2.3.3.3, 4.1.2.1
file extensions, 3.2.3, 13, 13, 13
File menu, 2.2.3.1
file names
in @@ (double "at" sign) command, 13
in EDIT command, 13
in GET command, 13
in SAVE command, 13
in SPOOL command, 7.4.2, 13
in SQLPLUS command, 4.5.3
files
flat, 7.4.1
finding text, 2.2.3.3
FLAGGER variable, 13, 13
flat file, 7.4.1
FLUSH variable, 9.4.5, 13, 13
FOLD_AFTER clause, 13
FOLD_BEFORE clause, 13
font
changing face and size in command-line, 2.1.2
changing face and size in GUI, 2.2.4, 2.2.4.1
changing in GUI, 2.2.4
euro sign in command-line, 2.1.2.2
fixed pitch TrueType, 2.2.4
Oracle Database home, 2.2.4.1
setting default in GUI, 3.5.2.3
setting default size in GUI, 3.5.2.4
special character in command-line, 2.1.2.2
Windows Character Map utility, 2.1.2.2
footers
aligning elements, 13
displaying at bottom of page, 13
displaying system-maintained values, 13
formatting elements, 13
indenting, 13
listing current definition, 13
setting at the end of reports, 7.3
suppressing definition, 13
FORCE clause, 13
FORMAT clause, 13, 13
in ATTRIBUTE command, 13
in COLUMN command, 7.1.2.2, 7.1.3.2
in REPHEADER and REPFOOTER commands, 13
in TTITLE and BTITLE commands, 7.3.2, 13
format models, number, 7.1.2.2, 13
formfeed, to begin a new page, 7.3.6, 13
FROM clause, 13, B.2.1

G

GET command, 13
LIST clause, 13
NOLIST clause, 13
retrieving scripts, 13
globalization support
Oracle10g, 12.4
glogin
profile, 13
See also login.sql
site profile, Preface, Preface, 3.2, 3.2.1, 3.2.2.1, 4.5.1.7, 9.1.2, 9.3, 10.6.5, 13, 13
GRANT command, 10.1
disabling, 10.2
graphical user interface
See GUI
GUI
changing face and size, 2.2.4, 2.2.4.1
changing font, 2.2.4
menus, 2.2.3
Windows Character Map utility, 2.2.4.2

H

HEAD clause, 4.5.1.5
HEAD option, 4.5.1.5
headers
aligning elements, 7.3.1.1
displaying at top of page, 13
displaying system-maintained values, 13
setting at the start of reports, 7.3
suppressing, 7.3.1
HEADING clause, 7.1.1.2, 13
HEADING variable, 13
headings
aligning elements, 13
column headings, 13
formatting elements, 13
indenting, 13
listing current definition, 13
suppressing definition, 13
HEADSEP variable, 13, 13
use in COLUMN command, 7.1.1.2
help
enabling or disabling iSQL*Plus help, 3.3.8
iSQL*Plus online, 4.3.10
menu, 2.2.3.5
online, 4.3.2, 13
HELP command, ? command, 13
HIDE clause, 13
History screen, 2.3.6
HOST command, 5.9, 13
host string, 4.3.3.1
HTML, 8.1.1
clause, 4.5.1.5
entities, 3.3.9, 8.1.3
option, 4.5.1.5
running dynamic reports, 8.2
spooling to file, 4.5.1.5
tag, 8.1
HTTP
Application Server authentication, 10.6.3
HTTPS security, 10.6
security, 10.6
hyphen
continuing a long SQL*Plus command, 5.6.1.1, 13

I

IMMEDIATE mode, 13
infinity sign (~), 13
initialization parameters
displaying, 13
INIT.ORA file
parameter file, 13
input
accepting [Return], 6.12.3
accepting values from the user, 6.12.1, 13
INPUT command, 6.2, 6.2.4, 13
entering several lines, 13
INSERT clause, B.1.1, B.2.2
INSERT command
disabling, 10.2
INSTANCE variable, 13, 13
instances
shutting down, 13
starting, 13
iSQL*Plus
access modes, 10.6.2
Application Server running, 3.3.2
Change Password screen, 4.1.2
configuring Oracle Net, 3.2.4
DBA Login screen, 2.3.3
dynamic reports, 8.2
enabling cookies, 3.4
enabling javascript, 3.4
enabling or disabling, 3.3.8
enabling or disabling iSQL*Plus help, 3.3.8
enabling restricted database access, 3.3.5
environment variables, 3.1
error messages, 14.2
exiting, Preface, 4.4.3
Expired Password screen, 4.1.4
History screen, 2.3.6
language support, 4.3.10
logging, 3.3.3
Login screen, 2.3.2, 4.3.7
online help, 4.3.10
port conflict, 3.3.1
Preferences screen, 2.3.8
retained session settings, 3.4.1
security, 10.6, 10.6
session-timeout, 3.3.4
setting up SSL, 3.3.7
starting, 4.3.4, 4.3.4, 4.3.9
starting from a URL, 4.3.9
stopping, 4.3.6
substitution variables, 6.10
three-tier model, 1.3
user access, 10.6.2
user interface, 1.2, 1.2.1, 1.3.1
Workspace, 2.3.4
iSQL*Plus DBA URL, 3.3.6
iSQLPlusAllowUserMarkup
configuration parameter, 3.1, 3.3.9
iSQLPlusConnectIdList
configuration parameter, 3.1, 3.3.5
isqlplusctl
starting Application Server, 4.3.4

J

JAAS, 3.3.6
Japanese
Java Authentication and Authorization Service (JAAS), 3.3.6
Java AuthoriZatioN (JAZN), 3.3.6
javascript, configuring for iSQL*Plus, 3.4
JAZN, 3.3.6
JUSTIFY clause, 13, 13

L

LABEL variable
SHOW command, C.1, C.12
labels
in COMPUTE command, 7.2.6, 13
language support in iSQL*Plus, 4.3.10
LD_LIBRARY_PATH
environment variables, 3.1
LEFT clause, 7.3.1.1, 13, 13
LIKE clause, 7.1.4, 13, 13
limits, SQL*Plus, A
line numbers, for SQL commands, 5.4
lines
adding at beginning of buffer, 13
adding at end of buffer, 13
adding new after current, 6.2.4, 13
appending text to, 6.2.3, 13
changing width, 7.3.6, 9.4.6, 13, 13
deleting all in buffer, 13
deleting from buffer, 6.2.5, 13
determining which is current, 6.2.2
editing current, 6.2.2
listing all in buffer, 6.2, 13
removing blanks at end, 13
LINESIZE variable, 7.3.1.1, 7.3.6, 13, 13
LIST clause, 13, 13
LIST command, 6.2, 13
determining current line, 6.2.2, 13
making last line current, 6.2.2, 13
using an asterisk, 6.2, 13
LNO clause, 13
load script button, 2.3.4.3
LOBOFFSET variable, 13, 13
LOCAL
environment variables, 3.1
LOCK TABLE command
disabling, 10.2
log in button, 2.3.2.4, 2.3.3.7
Log On dialog, 4.3.3.1
LOG_ARCHIVE_DEST parameter, 13
log4j.rootLogger, 3.3.3
configuration parameter, 3.1
LOGFILE clause, 13
logging, 3.3.3
logging off
conditionally, 13, 13
Oracle Database, 4.1, 13
SQL*Plus, 4.4.1, 13
logging on
Oracle Database, 13
SQL*Plus, 4.3.1
login
user profile
Login screen, 2.3.2, 2.3.3.2, 3.3.5, 4.3.7
login.sql, 3.2.2
See glogin.sql
Logout, Preface, 4.4.3
LONG
column definition from DESCRIBE, 13
LONG columns
changing format, 13
default format, 13
setting maximum width, 13, 13, 13
setting retrieval size, 9.4.7, 9.4.7, 13, 13, 13
LONG variable, 13, 13
effect on COPY command, B.1.2, B.2.3
LONGCHUNKSIZE variable, 7.1.3.1, 13, 13, 13, 13, 13
LONGRAW
column definition from DESCRIBE, 13

M

-MARKUP, 4.5.1.5, 4.5.1.5, 8.1, 8.1, 13, 13
BODY clause, 4.5.1.5
ENTMAP clause, 4.5.1.5
HEAD clause, 4.5.1.5
PREFORMAT clause, 4.5.1.5
SQLPLUS command clause, 4.5.1.5
TABLE clause, 4.5.1.5
MAXDATA variable, C.1, C.8
media recovery, 13
menus, Windows GUI, 2.2.3
message logging, 3.3.3
message, sending to screen, 6.12.1, 13
middle tier, 1.3
MOUNT clause, 13
mounting a database, 13
mouse, using to copy command, 2.2.1
multiple Oracle Database homes, specifying font, 2.2.4.1

N

national language support
See also globalization support
NCHAR clause
VARIABLE command, 13
NCHAR columns
changing format, 13
default format, 7.1.3.1, 7.1.3.1, 13
NCLOB clause
VARIABLE command, 13
NCLOB columns
changing format, 13
default format, 13
setting maximum width, 13, 13
setting retrieval position, 13, 13
setting retrieval size, 9.4.7, 13, 13, 13
negative infinity sign (-~), 13
net service name, 4.2.1, 4.2.2
See also connection identifier
new password field, 4.1.2.3
NEW_VALUE clause, 7.3.4, 13
storing current date in variable for titles, 13
NEWLINE clause, 13
NEWPAGE command, C.1
NEWPAGE variable, 7.3.6, 13, 13
NEXT clause, 13
NLS
NLS_DATE_FORMAT, 13, 13
NLS_LANG
environment variables, 3.1
NOAUDIT command
disabling, 10.2
NOLIST clause, 13
NOLOG, 4.2.4, 4.5.2
NOMOUNT clause, 13
NONE clause
WHENEVER OSERROR, 13
WHENEVER SQLERROR, 13
NOPARALLEL clause, 13
NOPRINT clause, 7.2.6, 7.3.4, 9.4.1, 13
NOPROMPT clause, 13
NORMAL mode, 13
Notepad on Windows, 13
NULL clause, 13
null values
setting text displayed, 13, 13, 13
NULL variable, 13, 13
NUMBER
column definition from DESCRIBE, 13
NUMBER clause, 6.12.2
VARIABLE command, 13
NUMBER columns
changing format, 7.1.2.1, 13
default format, 7.1.2.1, 13
number formats
$, 7.1.2.2
0, 7.1.2.2
9, 7.1.2.2
comma, 7.1.2.2
setting default, 6.9.4, 6.9.4, 13, 13
NUMFORMAT clause
in LOGIN.SQL, 3.2.2.1
NUMFORMAT variable, 13, 13
NUMWIDTH variable, 13, 13
effect on NUMBER column format, 7.1.2.1, 13
NVARCHAR2 columns
changing format, 13
default format, 7.1.3.1, 13

O

objects, describing, 13
obsolete commands
BTITLE, C.2
COLUMN command DEFAULT clause, C.3
DOCUMENT, C.1, C.4
NEWPAGE, C.1
SET command BUFFER variable, C.5
SET command CLOSECURSOR variable, C.1, C.6
SET command DOCUMENT variable, C.1, C.7
SET command MAXDATA variable, C.1, C.8
SET command SCAN variable, C.1, C.9
SET command SPACE variable, C.1, C.10
SET command TRUNCATE variable, C.1, C.11
SHOW command LABEL variable, C.1, C.12
TTITLE command old form, C.13
OF clause, 7.2.6
OFF clause, 13
in ATTRIBUTE command, 13
in COLUMN command, 7.1.6, 13
in REPFOOTER commands, 13
in REPHEADER commands, 13
in SPOOL command, 7.4, 13
in TTITLE and BTITLE commands, 7.3.3, 13
OLD_VALUE clause, 7.3.4, 13
ON clause
in ATTRIBUTE command, 13
in COLUMN command, 7.1.6, 13
in TTITLE and BTITLE commands, 7.3.3
ON column clause
in BREAK command, 13
in COMPUTE command, 7.2.6, 13
ON expr clause
in BREAK command, 13
in COMPUTE command, 13
ON REPORT clause
in BREAK command, 7.2.7, 13
in COMPUTE command, 7.2.7, 13
ON ROW clause
in BREAK command, 7.2.3, 13
in COMPUTE command, 13
online help, 4.3.2, 4.3.2, 13
OPEN clause, 13
opening a database, 13
operating system
editor, 6.1.1, 13, 13
file, loading into buffer, 13
running commands from SQL*Plus, 5.9, 13
text editor, 6.1.1
Options menu, 2.2.3.4
ORA_NLS10
environment variables, 3.1
Oracle Database home
specifying font, 2.2.4.1
Oracle Net, 1.3, 3.3.7.5, 10.6
configuring, 3.2.4
connect identifier, 13
security, 10.6
ORACLE_HOME
environment variables, 3.1
ORACLE_PATH
environment variables, 3.1
ORACLE_SID
environment variables, 3.1
Oracle10g, 1.3
globalization support, 12.4
ORDER BY clause
displaying column values in titles, 7.3.4
displaying values together in output, 7.2
OUT clause, 7.4.3, 13
output
formatting white space in, 9.4.11, 13
pausing during display, 5.10, 13

P

PAGE clause, 13
page number, including in titles, 7.2.4, 7.3.2
pages
changing length, 7.3.6, 9.4.8, 13, 13
default dimensions, 7.3.6
matching to screen or paper size, 7.3.6
setting dimensions, 7.3.6
PAGESIZE clause
in LOGIN.SQL, 3.2.2.1
PAGESIZE variable, 5.4, 7.3.6, 9.4.8, 13, 13
parameter, 6.11, 13
iSQL*Plus session-timeout, 3.3.4
iSQLPlusAllowUserMarkup, 3.3.9
SQLPATH, 3.5.2.2
SQLPLUS_FONT, 2.2.4, 3.5.2.3
SQLPLUS_FONT_SIZE, 2.2.4, 2.2.4, 3.5.2.4
parameter files (INIT.ORA files)
specifying alternate, 13
PARAMETERS clause, 13
password
Application Server authentication, 2.3.3.2
changing in iSQL*Plus, 4.1.2, 4.1.4
changing with the PASSWORD command, 13
field, 2.3.2.2, 2.3.3.4
in CONNECT command, 4.1, 13
in COPY command, B.2.1, B.2.2, B.3
in SQLPLUS command, 4.3.1, 4.5.2
viewable warning, 4.5.2
PASSWORD command, 13, 13
pasting text, 2.2.3.2
PATH
environment variables, 3.1
PAUSE command, 6.12.3, 13
PAUSE variable, 5.10, 13, 13
performance
of SQL statements, 9.1
over dial-up lines, 13
period (.)
terminating PL/SQL blocks, 5.5, 13, 13
PLAN_TABLE
creating, 9.1.1
table, 9.1.1
PL/SQL, 5.5
blocks, PL/SQL, 5.5
executing, 13
formatting output in SQL*Plus, 13
listing definitions, 5.3
mode in SQL*Plus, 5.5.1
within SQL commands, 5.5.1
PLUSTRACE
creating role, 9.1.1
role, 9.1.1
PNO clause, 13
port conflict, 3.3.1
pound sign (#), 13
predefined variable
_CONNECT_IDENTIFIER, Preface, Preface, 3.2.2.1, 13, 13
_DATE, 13, 13
_EDITOR, 2.2.3.2, 6.1.1, 13, 13, 13, 13
_O_RELEASE, 13, 13
_O_VERSION, 13, 13
_PRIVILEGE, Preface, 13, 13
_RC, 13
_SQLPLUS_RELEASE, 13, 13, 13
_USER, 13, 13
Preferences screen, 2.3.8
PREFORMAT, 4.5.1.5
PREFORMAT clause, 4.5.1.5
PRINT clause, 13
PRINT command, 13
printing
bind variables automatically, 13
REFCURSOR variables, 13
SPOOL command, 13
privileges
list, 2.3.3.6
Product User Profile table, 10.1, 10.6.5
prompt
SET SQLPROMPT, 9.4.10, 13, 13
PROMPT clause, 6.12.1, 13
PROMPT command, 6.12.1, 13
customizing prompts for value, 6.12.2
prompts for value
bypassing with parameters, 6.11
customizing, 6.12.2
through ACCEPT, 6.12.1
through substitution variables, 6.9.1
PUPBLD.SQL, 10.1.1

Q

queries
in COPY command, B.1.1, B.2.1
show number of records retrieved, 5.4, 13, 13
tracing, 9.3
query execution path
including in report, 13
query results
displaying on-screen, 5.4
sending to a printer, 7.4.3, 13
storing in a file, 7.4.2, 13
QUIT command, 13
See also EXIT

R

RAW
column definition from DESCRIBE, 13
record separators, printing, 7.1.7, 13, 13
RECOVER clause, 13
RECOVER command, 13
and database recovery, 11.4
AUTOMATIC clause, 13
CANCEL clause, 13, 13
CONTINUE clause, 13
DATABASE clause, 13
FROM clause, 13
LOGFILE clause, 13
NOPARALLEL clause, 13
STANDBY DATABASE clause, 13
STANDBY DATAFILE clause, 13
STANDBY TABLESPACE clause, 13, 13
UNTIL CANCEL clause, 13
UNTIL CONTROLFILE clause, 13
UNTIL TIME clause, 13
USING BACKUP CONTROL FILE clause, 13
recovery
RECOVER command, 13
RECSEP variable, 7.1.7, 13, 13
RECSEPCHAR variable, 7.1.7, 13, 13
redo Log Files
ARCHIVE LOG command, 13
REFCURSOR bind variables
in a stored function, 6.14
REFCURSOR clause
VARIABLE command, 13
REGEDIT.EXE, 3.5.2.1
REGEDT32.EXE, 3.5.2.1
registry
editor, 2.2.4, 3.5.2.1, 3.5.2.2, 3.5.2.3, 3.5.2.4
REGEDIT.EXE, 3.5.2.1
REGEDT32.EXE, 3.5.2.1
registry entry
SQLPATH, 3.1, 3.5.2.2
SQLPLUS_FONT, 2.2.4, 3.1, 3.5.2.3
SQLPLUS_FONT_SIZE, 2.2.4, 2.2.4, 3.1, 3.5.2.4
RELEASE clause, 13
REMARK command, 6.3.1, 13
removing sample tables, 1.8.1
RENAME command
disabling, 10.2
REPFOOTER clause, 13
REPFOOTER command, 7.3.1, 13
aligning footer elements, 13
BOLD clause, 13
CENTER clause, 13
COL clause, 13
FORMAT clause, 13
indenting report footers, 13
LEFT clause, 13
OFF clause, 13
RIGHT clause, 13
SKIP clause, 13
suppressing current definition, 13
TAB clause, 13
REPHEADER clause, 13
REPHEADER command, 7.3.1, 13
aligning header elements, 7.3.1.1
aligning heading elements, 13
BOLD clause, 13
CENTER clause, 13
COL clause, 13
FORMAT clause, 13
indenting headings, 13
LEFT clause, 13
OFF clause, 13
PAGE clause, 13
RIGHT clause, 13
SKIP clause, 13
suppressing current definition, 13
TAB clause, 13
REPLACE clause
in COPY command, B.1.1, B.2.2
in SAVE command, 13, 13
reports
autotrace, 9.1.1
breaks, 13
clarifying with spacing and summary lines, 7.2
columns, 13
creating bottom titles, 7.3, 13, C.1, C.1
creating dynamic, 8.2
creating footers, 13
creating headers, 13
creating headers and footers, 7.3
creating master/detail, 7.3.4, 13, 13
creating top titles, 7.3, 13, C.1
displaying, 13, 13
formatting column headings, 7.1.1.2, 13
formatting columns, 7.1.2.1, 7.1.3.1, 13
interactive HTML example, 8.1.1, 8.1.1
on the web, 8.1
running from a URL, 8.2
SILENT mode, 8.1.2
starting on a new page, 13
title, 13, C.1
RESTRICT, 4.5.1.7, 10.4, 13
restricted database access, 3.3.5
return code, specifying, 6.6, 13, 13
REVOKE command, 10.1
disabling, 10.2
RIGHT clause, 7.3.1.1, 13, 13
roles, 10.3
disabling, 10.3.2
re-enabling, 10.3.2
ROLLBACK clause, 13
WHENEVER OSERROR, 13
WHENEVER SQLERROR, 13
ROWID
column definition from DESCRIBE, 13
rows
performing computations on, 7.2.6, 13
setting number retrieved at one time, 9.4.3, 13, 13
setting the number after which COPY commits, 13
RUN command, 13
executing current PL/SQL block, 5.5
making last line current, 6.2.2
similar to / (slash) command, 13
Run menu command, 2.2.3.1

S

sample schemas, Preface, Preface, Preface, 1.8, 1.8.1, 1.8.1, 8.2
see Oracle Database Sample Schemas guide, Preface
see Oracle9i Sample Schemas guide, 1.8
using HR in COLUMN example, 13
using HR in examples, 6, 7
sample tables
access to, 1.8.1
creating, 1.8.1
removing, 1.8.1
unlocking, Preface, 1.8.1
SAVE command, 13
APPEND clause, 13
CREATE clause, 13
REPLACE clause, 13
storing commands in scripts, 13
using with INPUT to create scripts, 6.1.1
save script button, 2.3.4.4
saving environment attributes, 13
saving, command files, 2.2.3.1
SCAN variable, C.1, C.9
schemas
command, 14.1
database, 9.1.1
database default, 13
DESCRIBE parameter, 13
disabled commands, 14.1
HR sample, Preface, 1.8
installing own copy of HR, 1.8.1
sample, Preface
SHOW parameter, 13, 13
unlocking HR, Preface, 1.8.1
using HR in COLUMN example, 13
using HR in examples, 6, 7, 8.2
screen buffer area, 2.2.3.4
SCREEN clause, 6.12.4, 13
screens
Change Password, 4.1.2
clearing, 6.12.4, 13
connection identifier field, 2.3.2.3, 2.3.3.5
DBA Login, 2.3.3
DBA Workspace, 2.3.5
enter statements field, 2.3.6.1, 2.3.6.1, 2.3.6.2, 2.3.6.3
Expired Password, 4.1.4
History, 2.3.6
Login, 2.3.2, 2.3.3.2
new password field, 4.1.2.3
password field, 2.3.2.2, 2.3.3.4
Preferences, 2.3.8
privilege list, 2.3.3.6
script location field, 2.3.8.4
username field, 2.3.2.1, 2.3.3.3, 4.1.2.1
Workspace, 2.3.4
scripts
extension, 13, 13, 13
location field, 2.3.8.4
registering, 9.4.2
See also command file
Search menu, 2.2.3.3
Secure Sockets Layer security, 10.6
security
Application Server, 10.6
changing password, 13
HTTP, 10.6
Oracle Net, 10.6
password viewable, 4.5.2
PRODUCT_USER_PROFILE table, 10.1
RESTRICT, 4.5.1.7, 10.4
Secure Sockets Layer (SSL), 10.6
SELECT command
and BREAK command, 7.2, 13, 13, 13
and COLUMN command, 13
and COMPUTE command, 7.2
and COPY command, B.1.1, B.2.1
and DEFINE command, 13
and ORDER BY clause, 7.2
formatting results, 6.14
semicolon (;)
in PL/SQL blocks, 5.5
in SQL commands, 5.4, 5.4.1.2
in SQL*Plus commands, 5.6.1, 13
not stored in buffer, 6.2.1
server
iSQL*Plus port conflict, 3.3.1
SERVEROUTPUT variable, 13
service name
in COPY command, B.2.1, B.2.2, B.3
session
identification, 4.3.7
settings, 3.4.1
stateful behavior, 3.4.1
session-timeout parameter, 3.3.4
SET AUTOTRACE, 9.1.1
SET clause, 13
SET command, 3.2.3, 5.7, 13
APPINFO variable, 9.4.2, 13
ARRAYSIZE variable, 9.4.3, 13, 13, B.2.3
AUTOCOMMIT variable, 13, 13
AUTOPRINT variable, 13, 13, 13
AUTORECOVERY variable, 13, 13
AUTOTRACE variable, 13, 13
BLOCKTERMINATOR variable, 13, 13
BUFFER variable, C.5
CLOSECURSOR variable, C.1, C.6
CMDSEP variable, 13, 13
COLSEP variable, 7.4.1, 13, 13
COMPATIBILITY variable, 13, 13
CONCAT variable, 6.9.4, 6.9.4, 13, 13
COPYCOMMIT variable, 13, 13, B.2.3
COPYTYPECHECK variable, 13, 13
DEFINE clause, 6.9.4
DEFINE variable, 13
DESCRIBE variable, 13, 13
DOCUMENT variable, C.1, C.7
ECHO variable, 13, 13
EDITFILE variable, 13, 13
EMBEDDED variable, 13, 13
ESCAPE variable, 6.9.4, 13, 13
FEEDBACK variable, 13, 13
FLAGGER variable, 13, 13
FLUSH variable, 9.4.5, 13, 13
HEADING variable, 13
HEADSEP variable, 7.1.1.2, 13, 13
INSTANCE variable, 13, 13
LINESIZE variable, 7.3.1.1, 7.3.6, 13, 13
LOBOFFSET variable, 13, 13
LOGSOURCE variable, 13, 13
LONG variable, 13, 13, B.2.3
LONGCHUNKSIZE variable, 13, 13
MARKUP clause, 13, 13
MAXDATA variable, C.1, C.8
NEWPAGE variable, 7.3.6, 13, 13
NULL variable, 13, 13
NUMFORMAT clause, 3.2.2.1
NUMFORMAT variable, 13, 13
NUMWIDTH variable, 7.1.2.1, 13, 13, 13
PAGESIZE clause, 3.2.2.1
PAGESIZE variable, 5.4, 7.3.6, 9.4.8, 13, 13
PAUSE variable, 13, 13
RECSEP variable, 7.1.7, 13, 13
RECSEPCHAR variable, 7.1.7, 13, 13
SCAN variable, C.1, C.9
SERVEROUTPUT variable, 13
SHIFTINOUT variable, 13, 13
SPACE variable, C.1, C.10
SQLBLANKLINES variable, 13
SQLCASE variable, 13, 13
SQLCONTINUE variable, 13, 13
SQLNUMBER variable, 13, 13
SQLPLUSCOMPATIBILITY variable, 13, 13
SQLPREFIX variable, 13, 13
SQLPROMPT variable, 9.4.10, 13, 13
SQLTERMINATOR variable, 13, 13
substitution variable, 13
SUFFIX variable, 13, 13
TAB variable, 9.4.11, 13, 13
TERMOUT variable, 9.4.12, 13, 13
TIME variable, 13, 13
TIMING variable, 13, 13
TRIMOUT variable, 13, 13
TRIMSPOOL variable, 13, 13
TRUNCATE variable, C.1, C.11
UNDERLINE variable, 13, 13
used to format a REFCURSOR variable, 13
VERIFY clause, 6.9.1
VERIFY variable, 6.9.4, 6.9.4, 13, 13
WRAP variable, 7.1.3.2, 13, 13
SET MARKUP
BODY clause, 4.5.1.5
ENTMAP clause, 4.5.1.5, 8.1.3
HEAD clause, 4.5.1.5
HTML, 4.5.1.5
interactive HTML example, 8.1.1, 8.1.1
PREFORMAT clause, 4.5.1.5
See also SPOOL command
TABLE clause, 4.5.1.5
Set Options area, 2.2.3.4
SET ROLE command
disabling, 10.2
SET system variable summary, 13
SET TRANSACTION command
disabling, 10.2
SET variables, 5.7
See system variables
SGA clause, 13
SHIFTINOUT variable, 13, 13
SHOW
schema parameter, 13, 13
SHOW clause, 13
SHOW command, 5.7, 13
ALL clause, 13
BTITLE clause, 13
ERRORS clause, 13
LABEL variable, C.1, C.12
listing current page dimensions, 7.3.6
LNO clause, 13
PNO clause, 13
RELEASE clause, 13
REPFOOTER clause, 13
REPHEADER clause, 13
SPOOL clause, 13
SQLCODE clause, 13
TTITLE clause, 13
USER clause, 13
SHOWMODE variable, 13, 13
SHUTDOWN command, 13, 13
ABORT, 13
IMMEDIATE, 13
NORMAL, 13
TRANSACTIONAL LOCAL, 13
-SILENT option, 4.5.1.8, 8.1.2
site profile
glogin, Preface, Preface, 3.2, 3.2.1, 3.2.2.1, 4.5.1.7, 9.1.2, 9.3, 10.6.5, 13, 13, 13
SKIP clause
in BREAK command, 7.2.2, 7.2.3, 13
in REPHEADER and REPFOOTER commands, 13
in TTITLE and BTITLE commands, 7.3.1.1, 13
used to place blank lines before bottom title, 7.3.1.1
SKIP PAGE clause, 7.2.2, 7.2.3, 13
slash (/) command, 13
SPACE variable, C.1, C.10
special characters
choosing a font, 2.1.2.2
Euro sign, 2.1.2.2, 2.2.4, 2.2.4.2
using, 2.1.2.2, 2.2.4.2
SPOOL clause, 4.5.1.5, 13
SPOOL command, 7.3.6, 13
APPEND clause, 13
CREATE clause, 13
file name, 7.4.2, 13
OFF clause, 7.4, 13
OUT clause, 7.4.3, 13
REPLACE clause, 13
to HTML file, 4.5.1.5
turning spooling off, 7.4, 13
use with SET MARKUP, 8.1.1
spool menu command, 2.2.3.1
SQL buffer, 2.2.3.1
SQL clause, 13
SQL DML statements
reporting on, 13, 13
SQL optimizer, 9.1.2
SQL*Plus
application window, 2.2, 4.3.3.2
command prompt, 4.3.1
configuring globalization support, 12.1
database administration, 11.1
environment variables, 3.1
error messages, 14.1
execution plan, 9.1.2
exiting, 4.4.1, 13, 13
exiting conditionally, 13
limits, A
menus, 2.2.3
obsolete command alternatives, C.1
setting up environment, 3.2
shortcuts to starting, 4.3.1.1
starting, 4.3, 4.3.1, 4.5
statistics, 9.1.3
system variables affecting performance, 9.4
tuning, 9.1
who can use, 1.5
SQL*Plus Windows GUI
changing face and size, 2.2.4, 2.2.4.1
changing font, 2.2.4
SQLBLANKLINES variable, 13, 13
SQLCASE variable, 13, 13
SQLCODE clause, 13
SHOW command, 13
SQLCONTINUE variable, 13, 13
SQL.PNO, referencing in report titles, 7.3.2
SQLNUMBER variable, 13, 13, 13, 13
SQLPATH
environment variables, 3.1
registry entry, 3.1, 3.5.2.2
SQLPLUS
environment variables, 3.1
SQLPLUS command, 4.3.1
- clause, 4.5.1.2
-? clause, 4.5.1.3
and @ ("at" sign), 4.5
and EXIT FAILURE, 4.4
BODY option, 4.5.1.5
commands
SQLPLUS, 4.5
connect identifier, 4.5.2
display syntax, 4.5.1.2
ENTMAP option, 4.5.1.5
HEAD option, 4.5.1.5
HTML option, 4.5.1.5
-MARKUP clause, 4.5.1.5
-MARKUP option, 4.5.1.5
/NOLOG clause, 4.5.2
PREFORMAT option, 4.5.1.5
RESTRICT, 4.5.1.7, 10.4
service name, 4.5.2
-SILENT clause, 4.5.1.8
-SILENT option, 4.5.1.8, 8.1.2
SPOOL clause, 4.5.1.5
syntax, 4.5
SYSDBA clause, 4.5.2
TABLE option, 4.5.1.5
unsuccessful connection, 4.4
username/password, 4.3.1, 4.5.2
SQLPLUS_FONT
registry entry, 2.2.4, 3.1, 3.5.2.3
SQLPLUS_FONT_SIZE
registry entry, 2.2.4, 2.2.4, 3.1, 3.5.2.4
SQLPREFIX variable, 13, 13
SQLPROMPT variable, 9.4.10, 13, 13
SQL.SQLCODE
using in EXIT command, 13
SQLTERMINATOR variable, 13, 13, 13, 13
SSL
iSQL*Plus setup, 3.3.7
security, 10.6
STANDBY DATAFILE clause, 13
STANDBY TABLESPACE clause, 13
START clause, 13, 13
START command, 6.4, 13
arguments, 6.11
passing parameters to a script, 6.11
script, 6.4, 13
similar to @ ("at" sign) command, 6.4, 13, 13
similar to @@ (double "at" sign) command, 13
Start menu
starting SQL*Plus, 4.3.3.1
starting
iSQL*Plus, 4.3.4, 4.3.4, 4.3.9
SQL*Plus, 2.1, 4.3, 4.3.1
SQL*Plus shortcuts, 4.3.1.1
SQL*Plus Windows GUI, 4.3.3.1
STARTUP command, 13
FORCE clause, 13
MOUNT clause, 13
NOMOUNT clause, 13
OPEN clause, 13
PFILE clause, 13
RECOVER clause, 13
RESTRICT clause, 13
specifying a database, 13
statements
executing, 5.1.2
statistics, 9.1.3
collecting TIMING statistics, 9.2
STOP clause, 13, 13
stop query, 5.8
stopping
iSQL*Plus Application Server, 4.3.6
STORE command, 3.2.3, 13
SET clause, 13
stored functions, 6.14
stored procedures
creating, 5.5.1
subkey, registry, 3.5.2.1, 3.5.2.2, 3.5.2.3, 3.5.2.4
substitution variables, 6.7, 6.9, 6.9.4, 13, 13
_EDITOR, 13
appending characters immediately after, 6.9.1
avoiding unnecessary prompts for value, 6.9.2
concatenation character, 13, 13
DEFINE command, 13
defining, 6.7, 6.9.2, 13
deleting, 6.7, 13
displaying in headers and footers, 13
displaying in titles, 13
in ACCEPT command, 6.12.1, 13
iSQL*Plus, 6.10
listing definitions, 6.7, 6.7, 13, 13
parsing, 9.4.4
prefixing, 13, C.1
related system variables, 6.9.4
restrictions, 6.9.3
single and double ampersands, 6.9.2
system variables used with, 6.9.4
undefined, 6.9.1
where and how to use, 6.9.1
SUFFIX variable, 13, 13
used with EDIT command, 13
used with SAVE command, 13
used with START command, 13
SUM function, 7.2.6
summary lines
computing and printing, 7.2.6, 13
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 commands, 5.4.1
SQL*Plus commands, 5.6.1
SYSDBA clause, 13
SYSOPER clause, 4.5.2, 13
system variables, 5.7, 13
affecting SQL*Plus performance, 9.4
affecting substitution variables, 6.9.4
listing current settings, 5.7, 13
listing old and new values, 13, 13
screen buffer, 2.2.3.4
Set Options area, 2.2.3.4
setting, 2.2.3.4
storing and restoring, 3.2.3
summary of SET commands, 13
value area, 2.2.3.4
system-maintained values
displaying in headers and footers, 13
displaying in titles, 7.3.2, 13
formatting in titles, 7.3.2

T

TAB clause, 13, 13
TAB variable, 9.4.11, 13, 13
TABLE clause, 4.5.1.5
TABLE option, 4.5.1.5
tables
access to sample, 1.8.1
controlling destination when copying, B.1.1, B.2.2
copying values between, B.2, B.3
listing column definitions, 5.2, 13
referring to another user's when copying, B.2.4
TABLESPACE clause, 13
tablespaces, recovering, 13
tag, HTML, 8.1
TERMOUT variable, 9.4.12, 13, 13
using with SPOOL command, 13
text, 4.5.1.5, 4.5.1.5
adding to current line with APPEND, 6.2.3, 13
changing old to new with CHANGE, 6.2.2, 13
clearing from buffer, 6.2, 13
text editor
defining, 2.2.3.2
invoking, 2.2.3.2
operating system, 6.1.1, 13
three-tier model, 1.3
TIME variable, 13, 13
TIMING clause, 13
TIMING command, 9.2, 13
deleting all areas created by, 13
deleting current area, 13
SHOW clause, 13
START clause, 13
STOP clause, 13
TIMING variable, 13, 13
titles
aligning elements, 7.3.1.1, 13
displaying at bottom of page, 7.3, 13, C.1, C.1
displaying at top of page, 7.3, 13, C.1
displaying column values, 7.3.4, 13, 13
displaying current date, 7.3.5, 13, 13
displaying page number, 7.3.2, 13
displaying system-maintained values, 7.3.2, 13
formatting elements, 13
formatting system-maintained values in, 7.3.2
indenting, 7.3.1.2, 13
listing current definition, 7.3.3, 13, 13
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, 13, C.1
setting lines from top title to end of page, 9.4.8, 13, 13
setting top and bottom, 7.3, 13, 13, C.1, C.1, C.1
spacing between last row and bottom title, 7.3.1.1
suppressing definition, 7.3.3, 13
TNS_ADMIN
environment variables, 3.1
TO clause, B.2.1
tracing queries, 9.3
tracing statements
for performance statistics, 9.1.3
for query execution path, 9.1.3
using a database link, 9.1.3
with parallel query option, 9.3
TRIMOUT variable, 13, 13
TRIMSPOOL variable, 13, 13
TRUNCATE command
disabling, 10.2
TRUNCATE variable, C.1, C.11
TRUNCATED clause, 7.1.3.2, 13
TTITLE clause, 13
TTITLE command, 7.3.1, 13
aligning title elements, 7.3.1.1, 13
BOLD clause, 13
CENTER clause, 7.3.1.1, 13
COL clause, 7.3.1.2, 13
FORMAT clause, 7.3.2, 13
indenting titles, 7.3.1.2, 13
LEFT clause, 7.3.1.1, 13
listing current definition, 7.3.3, 13
OFF clause, 7.3.3, 13
old form, C.13
ON clause, 7.3.3
referencing column value variable, 7.3.4, 13
restoring current definition, 7.3.3
RIGHT clause, 7.3.1.1, 13
SKIP clause, 7.3.1.1, 13
suppressing current definition, 7.3.3, 13
TAB clause, 13
tuning
SET APPINFO OFF, 9.4.2
SET ARRAYSIZE, 9.4.3
SET DEFINE OFF, 9.4.4
SET FLUSH OFF, 9.4.5
SET TRIMOUT ON, 9.4.13
SET TRIMSPOOL ON, 9.4.13
SQL*Plus, 9.1
system variables, 9.4
TWO_TASK
environment variables, 3.1

U

UNDEFINE command, 6.7, 13
and DEFINE command, 13
UNDERLINE variable, 13, 13
unicode
UNIX
ed, 13
unlocking sample tables, Preface, 1.8.1
UNTIL CANCEL clause, 13
UNTIL CHANGE clause, 13
UNTIL CONTROLFILE clause, 13
UNTIL TIME clause, 13
UPDATE command, disabling, 10.2
URL
running dynamic reports, 8.2
starting iSQL*Plus, 4.3.9
USER clause, 13
user profile, 3.2.2
glogin.sql, 3.2.2
login.sql, 3.2.2
See also site profile
user variable
See substitution variable
username, 4.1
connecting under different, 4.1, 13
field, 2.3.2.1, 2.3.3.3, 4.1.2.1
in CONNECT command, 4.1, 13
in COPY command, B.2.1, B.2.2, B.3
in SQLPLUS command, 4.3.1, 4.5.2
USING BACKUP CONTROL FILE clause, 13
USING clause, B.1.1, B.2.1
UTF-8

V

V$SESSION virtual table, 13
V$SQLAREA virtual table, 13
value area, 2.2.3.4
value screen area, 2.2.3.4
VARCHAR columns
default format, 7.1.3.1
VARCHAR2
column definition from DESCRIBE, 13
VARCHAR2 clause
VARIABLE command, 13
VARCHAR2 columns
changing format, 13
default format, 7.1.3.1
VARIABLE command, 13
BINARY_DOUBLE clause, 13
BINARY_FLOAT clause, 13
CHAR clause, 13
CLOB clause, 13
NCHAR clause, 13
NCLOB clause, 13
NUMBER clause, 13
REFCURSOR clause, 13
VARCHAR2 clause, 13
variable clause, 13
variables
bind variables, 6.13
substitution variables, 13
system variables, 5.7
VERIFY clause, 6.9.1
VERIFY variable, 6.9.4, 6.9.4, 13, 13

W

WARNING clause, 13
web browser, 1.2, 8.1.1
web, outputting reports, 8.1
WHENEVER OSERROR command, 13
COMMIT clause, 13
CONTINUE clause, 13
EXIT clause, 13
NONE clause, 13
ROLLBACK clause, 13
WHENEVER SQLERROR command, 13
COMMIT clause, 13
CONTINUE clause, 13
EXIT clause, 13
NONE clause, 13
ROLLBACK clause, 13
Windows
notepad, 13
Windows GUI
application window, 2.2, 4.3.3.2
cancelling, 2.2.3.1
changing face and size, 2.2.4, 2.2.4.1
changing font, 2.2.4
command keys, 2.2.2
configuring, 3.5
exiting, 2.2.3.1
File menu, 2.2.3.1
Log On dialog, 4.3.3.1
menus, 2.2.3
starting SQL*Plus, 4.3.3.1
Windows service
starting iSQL*Plus Application Server, 4.3.4
WORD_WRAPPED clause, 7.1.3.2, 7.1.7, 13
Workspace, 2.3.4
WRAP variable, 7.1.3.2, 13, 13
WRAPPED clause, 7.1.3.2, 13, 13

X

XMLType
column definition from DESCRIBE, 13
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.4.7, 13
setting maximum column width, 13