Skip Headers

SQL*Plus User's Guide and Reference
Release 9.2

Part Number A90842-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback

Go to previous page

Index

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

-- (comment delimiter), 6-11
- (hyphen)
clause, 4-4
continuing a long SQL*Plus command, 5-9, 13-1
. (period), 5-7
/ (slash) command
default logon, 4-11, 13-46
entered at buffer line-number prompt, 5-5, 13-9
entered at command prompt, 5-7, 13-9
executing current PL/SQL block, 5-7
executing current SQL command, 5-7
similar to RUN, 5-7, 13-9, 13-92
usage, 13-9

Symbols

# pound sign, 13-34
$ number format, 7-5
& (ampersand)
disabling substitution variables, 6-23
substitution variables, 6-18
&&, 6-21
* (asterisk)
in DEL command, 6-4, 13-51
in LIST command, 6-4, 13-73
/*...*/ (comment delimiters), 6-10
: (colon)
bind variables, 6-31
:BindVariable clause
EXIT command, 13-65
; (semicolon), 5-4
@ ("at" sign)
command, 3-4, 6-14, 13-5
command arguments, 13-6
in CONNECT command, 13-46
in COPY command, B-2, B-5
in SQLPLUS command, 4-3, 4-21, 6-15
passing parameters to a script, 13-5
script, 6-14, 13-5
similar to START, 6-14, 13-6, 13-133
@@ (double "at" sign) command, 3-4, 13-7
script, 13-7
similar to START, 13-8, 13-133
[Cancel] key, 5-12
_EDITOR, in EDIT command, 6-2, 13-61
~ infinity sign, 13-34
-~ negative infinity sign, 13-34

Numerics

0, number format, 7-5
9, number format, 7-5

A

ABORT mode, 13-129
abort query, 5-12
ACCEPT command, 6-27, 13-10
and DEFINE command, 13-49
CHAR clause, 13-10
customizing prompts for value, 6-29
DATE clause, 13-10
DEFAULT clause, 13-11
FORMAT clause, 13-10
HIDE clause, 13-11
NOPROMPT clause, 13-11
NUMBER clause, 6-30
PROMPT clause, 6-28, 13-11
access, denying and granting, 10-2
adding authentication entries, 10-12
administrator
Oracle HTTP Server, 10-12
ALIAS clause, 13-30
in ATTRIBUTE command, 13-16
ALL clause, 13-124
ALTER command
disabling, 10-5
ampersands (&)
in parameters, 6-26, 13-5, 13-132
substitution variables, 6-18
ANALYZE command
disabling, 10-5
APPEND clause
in COPY command, B-3, B-7
in SAVE command, 13-93
APPEND command, 6-4, 6-8, 13-12
APPINFO clause, 9-10, 13-99
ARCH background process, 13-14
ARCHIVE LOG
command, 11-4, 13-13
mode, 11-4
argument
in START command, 6-26
ARRAYSIZE variable, 9-10, 13-100
relationship to COPY command, B-4, B-8
ATTRIBUTE command, 13-16
ALIAS clause, 13-16
and CLEAR COLUMN command, 13-17
CLEAR clause, 13-16
clearing columns, 13-27, 13-30
controlling display characteristics, 13-17
display characteristics, 13-16
entering multiple, 13-17
FORMAT clause, 13-17
LIKE clause, 13-17
listing attribute display characteristics, 13-16
OFF clause, 13-17
ON clause, 13-17
restoring column display attributes, 13-17
suppressing column display attributes, 13-17
AUDIT command
disabling, 10-5
authentication
adding connection entries, 10-12
adding username/password entries, 3-11, 10-11
DBA access in iSQL*Plus, 10-9, 10-11
enabling for iSQL*Plus users, 3-11
htpasswd utility, 10-12
iSQL*Plus, 10-10
iSQL*Plus Server statistics, 10-9
AUTOCOMMIT variable, 5-11, 13-101
AUTOMATIC clause, 13-80
AUTOPRINT variable, 13-101
AUTORECOVERY variable, 13-101
autotrace report, 9-2
AUTOTRACE variable, 9-2, 13-102
AVG function, 7-17

B

background process,
startup after abnormal termination, 13-129
batch mode, 6-17, 13-65
BEGIN command, 5-7
disabling, 10-5
bind variables, 6-31
creating, 13-145
displaying, 13-77
displaying automatically, 13-101, 13-147
in PL/SQL blocks, 13-147
in SQL statements, 13-147
in the COPY command, 13-147
blank line
in PL/SQL blocks, 5-7
in SQL commands, 5-5
preserving in SQL commands, 13-118
blocks, PL/SQL
continuing, 5-7
editing in buffer, 6-4
editing with host system editor, 6-2, 13-61
entering and executing, 5-7
listing current in buffer, 6-5
run from SQL buffer, 5-7
saving current, 13-93
setting character used to end, 13-102
stored in SQL buffer, 5-7
timing statistics, 13-122
within SQL commands, 5-6
BLOCKTERMINATOR, 13-102, 13-118, 13-121
BODY clause, 4-6
BODY option, 4-6
BOLD clause, 13-90, 13-142
break columns, 7-12, 13-18
inserting space when value changes, 7-13
specifying multiple, 7-14
suppressing duplicate values in, 7-12
BREAK command, 7-12, 13-18
and SQL ORDER BY clause, 7-12, 7-13, 7-14, 13-19
clearing BREAKS, 7-16
displaying column values in titles, 7-29
DUPLICATES clause, 13-21
inserting space after every row, 7-14
inserting space when break column changes, 7-13
listing current break definition, 7-16, 13-21
ON column clause, 7-13, 13-18
ON expr clause, 13-19
ON REPORT clause, 7-20, 13-20
ON ROW clause, 7-14, 13-20
printing "grand" and "sub" summaries, 7-20
printing summary lines at ends of reports, 7-20
removing definition, 13-27
SKIP clause, 7-14, 13-20
SKIP PAGE clause, 7-13, 7-14, 13-21
specifying multiple break columns, 7-14, 13-18
storing current date in variable for titles, 7-31
suppressing duplicate values, 7-12
used in conjunction with COMPUTE, 7-16
used in conjunction with SET COLSEP, 13-104
used to format a REFCURSOR variable, 13-147
used with COMPUTE, 13-18, 13-20, 13-42
break definition
listing current, 7-16, 13-21
removing current, 7-16, 13-27
BREAKS clause, 7-16, 13-27
browse button, 2-6, 2-15
browser, web, 8-2
BTITLE clause, 13-124
BTITLE command, 7-23, 13-23
aligning title elements, 13-142
BOLD clause, 13-142
CENTER clause, 13-142
COL clause, 13-142
FORMAT clause, 13-142
indenting titles, 13-142
LEFT clause, 13-142
OFF clause, 13-141
old form, C-3
printing blank lines before bottom title, 7-26
referencing column value variable, 13-35
RIGHT clause, 13-142
SKIP clause, 13-142
suppressing current definition, 13-141
TAB clause, 13-142
TTITLE command, 13-23
buffer, 5-2
appending text to a line in, 6-8, 13-12
delete a single line, 6-4
delete the current line, 6-4
delete the last line, 6-4
deleting a range of lines, 6-4, 13-51
deleting a single line, 13-51
deleting all lines, 6-4, 13-27, 13-51
deleting lines from, 6-9, 13-51
deleting the current line, 13-51
deleting the last line, 13-51
executing contents, 5-7, 13-9, 13-92
inserting new line in, 6-7, 13-71
listing a range of lines, 6-5, 13-73
listing a single line, 6-4, 13-73
listing all lines, 6-4, 13-73
listing contents, 6-5, 13-73
listing the current line, 6-4, 13-73
listing the last line, 6-5, 13-73
loading into host system editor, 13-61
saving contents, 13-93
BUFFER clause, 6-3, 6-4, 13-27
BUFFER variable, C-4
buttons
browse, 2-6, 2-15
cancel, 2-8, 4-19, 6-25
clear screen, 2-6
execute, 2-6
load script, 2-6
log in, 2-5, 2-12
save script, 2-6

C

cancel button, 2-8, 4-19, 6-25
CANCEL clause, 13-81, 13-83
cancel query, 5-12
cascading style sheet
customizing, 3-11
user interface, 3-11
CENTER clause, 7-26, 13-90, 13-142
CHANGE command, 6-4, 6-6, 13-24
Change Password screen, 4-19
CHAR clause, 13-10
VARIABLE command, 13-145
CHAR columns
changing format, 7-6, 13-31
default format, 7-6, 13-31
definition from DESCRIBE, 13-53
character encoding
national language support, 12-3
CLEAR clause, 7-10, 13-30
in ATTRIBUTE command, 13-16
CLEAR command, 13-27
BREAKS clause, 7-16, 13-27
BUFFER clause, 6-3, 6-4, 13-27
COLUMNS clause, 13-27
COMPUTES clause, 13-27
SCREEN clause, 6-30, 13-27
SQL clause, 13-28
TIMING clause, 13-28
clear screen button, 2-6
client tier, 1-4
configuring, 3-5
CLOB clause
VARIABLE command, 13-146
CLOB columns
changing format, 7-6, 13-31
default format, 13-31
setting maximum width, 13-112
setting retrieval position, 13-111
setting retrieval size, 13-112
CLOSECURSOR variable, C-2, C-5
CMDSEP variable, 13-103
COL clause, 7-26, 13-90, 13-142
colons (:)
bind variables, 6-31
COLSEP variable, 13-104
COLUMN command, 7-2, 13-29
ALIAS clause, 13-30
and BREAK command, 13-20
and DEFINE command, 13-49
CLEAR clause, 7-10, 13-30
DEFAULT clause, C-3
displaying column values in bottom titles, 7-30, 13-35
displaying column values in top titles, 7-29, 13-34
entering multiple, 13-36
ENTMAP clause, 13-30
FOLD_AFTER clause, 13-30, 13-31
FOLD_BEFORE clause, 13-31
FORMAT clause, 7-5, 7-6, 13-31
formatting a REFCURSOR variable, 13-147
formatting columns, 7-6
formatting NUMBER columns, 7-4, 13-32
HEADING clause, 7-2, 13-34
HEADSEP character, 13-34
JUSTIFY clause, 13-34
LIKE clause, 7-9, 13-34
listing column display attributes, 7-9, 13-29
NEW_VALUE clause, 7-29, 7-31, 13-34
NEWLINE clause, 13-34
NOPRINT clause, 7-29, 13-35
NULL clause, 13-35
OFF clause, 7-10, 13-36
OLD_VALUE clause, 7-30, 13-35
ON clause, 7-10, 13-36
PRINT clause, 13-35
resetting to default display, 7-10, 13-30, C-2
restoring column display attributes, 7-10, 13-36
storing current date in variable for titles, 7-31, 13-37
suppressing column display attributes, 7-10, 13-36
TRUNCATED clause, 7-7, 13-36
WORD_WRAPPED clause, 7-7, 7-10, 13-36
WRAPPED clause, 7-7, 13-36
column headings
aligning, 13-34
changing, 7-2, 13-34
column headings (continued)
changing character used to underline, 13-123
changing to two or more words, 7-3, 13-34
displaying on more than one line, 7-3, 13-34
suppressing printing in a report, 13-109
when truncated, 13-31
when truncated for CHAR and LONG columns, 7-6
when truncated for DATE columns, 7-6
when truncated for NUMBER columns, 7-4
column separator, 13-104, C-2
columns
assigning aliases, 13-30
computing summary lines, 7-16, 13-40
copying display attributes, 7-9, 13-17, 13-34
copying values between tables, B-2, B-5, B-9
displaying values in bottom titles, 7-30, 13-35
displaying values in top titles, 7-29, 13-34
formatting CHAR, VARCHAR, LONG, and DATE, 13-31
formatting in reports, 7-2, 13-29
formatting MLSLABEL, RAW MLSLABEL, ROWLABEL, 13-31
formatting NUMBER, 7-4, 13-32
listing display attributes for all, 7-9, 13-29
listing display attributes for one, 7-9, 13-29
names in destination table when copying, B-3, B-6
printing line after values that overflow, 7-10, 13-115
resetting a column to default display, 7-10, 13-30, C-2
resetting all columns to default display, 13-27
restoring display attributes, 7-10, 13-17, 13-36
setting printing to off or on, 7-29, 13-35
starting new lines, 13-34
storing values in variables, 7-29, 13-34
suppressing display attributes, 7-10, 13-17, 13-36
truncating display for all when value overflows, 7-7, 13-123
truncating display for one when value overflows, 7-7, 13-36
wrapping display for all when value overflows, 7-7, 13-123
wrapping display for one when value overflows, 7-7, 13-36
wrapping whole words for one, 7-10
COLUMNS clause, 13-27
comma, number format, 7-5
command file extension, 13-98
command files
aborting and exiting with a return code, 6-17, 13-153, 13-155
allowing end-user input, 6-17
creating with a system editor, 6-2
creating with SAVE, 13-93
editing with host system editor, 6-3, 13-61
in @ ("at" sign) command, 6-14, 13-5
in @@ (double "at" sign) command, 13-7
in EDIT command, 6-3, 13-61
in GET command, 13-66
in SAVE command, 6-3, 13-93
in SQLPLUS command, 4-12, 6-15
in START command, 6-14, 13-132
including comments in, 6-10, 13-86
including more than one PL/SQL block, 6-2
including more than one SQL command, 6-2
nesting, 6-15
passing parameters to, 6-26, 13-5, 13-132
registering, 9-10, 13-99
retrieving, 13-66
running, 6-14, 13-5, 13-132
running a series in sequence, 6-15
running as you start SQL*Plus, 4-12, 6-15
running in batch mode, 6-17, 13-65
running nested, 13-7
uniform resource locator, 13-5, 13-7, 13-132
command prompt
SET SQLPROMPT, 13-120
SQL*Plus, 4-2
command-line
configuring globalization support, 12-2
user interface, 2-2
commands
collecting timing statistics on, 9-7, 13-139
disabling, 10-4
commands (continued)
entering in iSQL*Plus, 2-6
host, running from SQL*Plus, 5-12, 13-69
listing current in buffer, 13-73
not supported in iSQL*Plus, D-1
re-enabling, 10-4
spaces, 5-2
SQL
editing in buffer, 6-4
editing with host system editor, 13-61
ending, 5-5
entering and executing, 5-3
entering without executing, 5-5
executing current, 5-7, 13-9, 13-92
following syntax, 5-4
listing current in buffer, 6-5
saving current, 13-93
setting character used to end and run, 13-121
SQL*Plus
abbreviations, 5-8
command summary, 13-2
continuing on additional lines, 5-9, 13-1
editing at command prompt, 6-4
ending, 5-10, 13-1
entering and executing, 5-8
entering during SQL command entry, 13-120
obsolete command alternatives, C-2
SQL, continuing on additional lines, 5-5
stopping while running, 5-12
tabs, 5-2
types of, 5-2
variables that affect running, 5-10
writing interactive, 6-17
comments
including in scripts, 6-10, 13-86, C-2
using -- to create, 6-11
using /*...*/ to create, 6-10
using REMARK to create, 6-10, 13-86, C-2
COMMIT clause, 13-64
WHENEVER OSERROR, 13-152
WHENEVER SQLERROR, 13-154
COMMIT command, 5-11
communication between tiers, 1-4, 1-5
COMPATIBILITY variable, 13-104
COMPUTE command, 7-12, 13-40
AVG function, 7-17
computing a summary on different columns, 7-20
COUNT function, 7-17
LABEL clause, 7-17, 7-20, 13-41
listing all definitions, 7-22, 13-42
MAXIMUM function, 7-17
maximum LABEL length, 13-41
MINIMUM function, 7-17
NUMBER function, 7-17
OF clause, 7-16
ON column clause, 7-16, 13-41
ON expr clause, 13-41
ON REPORT clause, 7-20, 13-41
ON ROW clause, 13-41
printing "grand" and "sub" summaries, 7-20
printing multiple summaries on same column, 7-21
printing summary lines at ends of reports, 7-20
printing summary lines on a break, 7-16
referencing a SELECT expression in OF, 13-41
referencing a SELECT expression in ON, 13-42
removing definitions, 7-22, 13-27
STD function, 7-17
SUM function, 7-17
used to format a REFCURSOR variable, 13-147
VARIANCE function, 7-17
COMPUTES clause, 13-27
CONCAT variable, 6-23, 13-105
configuration
client tier, 3-5
database tier, 3-15
file associations, 3-5
globalization support
iSQL*Plus Server, 3-7
middle tier, 3-7
MIME types, 3-5
Oracle HTTP Server, 3-7
Oracle9i, 3-15
testing HTTP Server configuration file, 3-12
configuring
cookies for iSQL*Plus, 3-5
globalization support, 12-1
HTTP Server, 3-12
configuring (continued)
httpd.conf, 3-12
iSQL*Plus, 3-5
iSQL*Plus extension for windows, 3-15
javascript for iSQL*Plus, 3-5
Oracle Net, 3-15
oracle_apache.conf, 3-12
proxy server exceptions, 3-6
SQL*Plus, 3-1
CONNECT command, 4-18, 4-22, 13-46
and @ ("at" sign), 13-46
changing password, 13-46, 13-47, 13-75
service name, 4-22
SYSDBA clause, 4-11, 13-47
SYSOPER clause, 4-11, 13-47
username/password, 4-21, 13-46
CONNECT command (SQL)
disabling, 10-5
connect identifier, 2-5, 2-11, 4-21, 13-46
field, 2-5, 2-11
in CONNECT command, 13-46
in COPY command, B-2
in DESCRIBE command, 13-53
in SQLPLUS command, 4-11
connection identifier, 4-20
context menu
iSQL*Plus extension for windows, 2-16
CONTINUE clause
WHENEVER OSERROR, 13-152
WHENEVER SQLERROR, 13-154
continuing a long SQL*Plus command, 5-9, 13-1
cookies, configuring for iSQL*Plus, 3-5
COPY command, 13-48, B-2, B-5
and @ ("at" sign), B-2, B-5
and ARRAYSIZE variable, B-4, B-8
and COPYCOMMIT variable, B-4, B-8
and LONG variable, B-4, B-8
APPEND clause, B-3, B-7
copying data between databases, B-5
copying data between tables on one database, B-9
CREATE clause, B-3, B-7
creating a table, B-3, B-7
destination table, B-3, B-6
determining actions, B-6
determining source rows and columns, B-3, B-6
disabling, 10-5
FROM clause, B-5
INSERT clause, B-3, B-7
inserting data in a table, B-3, B-7
interpreting messages, B-8
mandatory connect identifier, B-3
naming the source table with SELECT, B-3, B-6
query, B-3, B-6
referring to another user's table, B-9
REPLACE clause, B-3, B-7
replacing data in a table, B-3, B-7
sample command, B-5, B-6
service name, B-5, B-8, B-9
specifying columns for destination, B-3, B-6
specifying the data to copy, B-3, B-6
TO clause, B-5
username/password, B-2, B-5, B-8, B-9
USING clause, B-3, B-6
copy command
error messages, 14-45
COPYCOMMIT variable, 13-105
relationship to COPY command, B-4, B-8
COPYTYPECHECK variable, 13-105
COUNT function, 7-17
CREATE clause
in COPY command, B-3, B-7
CREATE command
disabling, 10-5
entering PL/SQL, 5-6
creating a PLAN_TABLE, 9-2
creating flat files, 7-34
creating PLUSTRACE role, 9-3
creating sample tables, 1-8
creating the PRODUCT_USER_PROFILE table, 10-2
CSS user interface, 3-11
cursor variables, 13-147

D

database
connect identifier, 13-46
mounting, 13-135
opening, 13-135
database administrator, 11-2
database changes, saving automatically, 5-11, 13-101
DATABASE clause, 13-81
database files
recovering, 13-79
database name at startup, 13-134
database tier, 1-4
configuration, 3-15
databases
connecting to default, 13-46
connecting to remote, 4-21, 13-46
copying data between, B-2, B-5
copying data between tables on a single, B-9
disconnecting without leaving SQL*Plus, 4-18, 13-60
mounting, 11-3
opening, 11-3
recovering, 11-5, 13-79
shutting down, 11-2, 11-3
starting, 11-2
DATAFILE clause, 13-82
DATE
column definition from DESCRIBE, 13-53
DATE clause, 13-10
DATE columns
changing format, 7-6, 13-32, 13-39
default format, 7-6
date, storing current in variable for titles, 7-30, 13-35, 13-37
DB2, 13-105
DBA, 11-2
iSQL*Plus access, 10-9
mode, 13-134
privilege, 2-10, 13-134
DBA access, 10-11
DBA Login screen, 2-10
DBA Work screen, 2-12
DBMS_APPLICATION_INFO package, 9-10, 13-99
DECLARE command (PL/SQL), 5-7
DECLARE command, disabling, 10-5
DEFAULT clause, 13-11
default logins
created at installation, 4-17
DEFINE command, 6-17, 13-49
and host system editor, 6-2, 13-50
and UNDEFINE command, 6-18, 13-144
CHAR values, 13-49
SET DEFINE ON|OFF, 13-105
substitution variables, 6-21, 13-49
define substitution variables field, 6-25
DEFINE variable, 6-23, 13-105
DEL command, 6-4, 6-9, 13-51
using an asterisk, 6-4, 13-51
DELETE command
disabling, 10-5
DESCRIBE command (SQL*Plus), 5-13, 13-53
connect_identifier, 13-53
PL/SQL properties listed by, 13-54
table properties listed by, 13-53
DISABLED keyword, disabling commands, 10-4
disabling
iSQL*Plus, 3-14
PL/SQL commands, 10-5
SQL commands, 10-4
SQL*Plus commands, 10-4
DISCONNECT command, 4-18, 13-60
DOCUMENT command, C-2, C-3
REMARK as newer version of, C-4
DOCUMENT variable, C-2, C-5
DROP command
disabling, 10-5
DUPLICATES clause, 13-21
dynamic reports, creating, 8-13

E

ECHO variable, 6-14, 13-107
EDIT command, 6-2, 13-61
creating scripts with, 6-2
defining _EDITOR, 13-61
disabling, 10-5
modifying scripts, 6-3, 13-61
setting default file name, 13-107
EDITFILE variable, 13-107
editing
external editor, 5-2
input area, 5-2
scripts, 5-2
editor, 5-2
EMBEDDED variable, 13-107
EMP table, 1-7
enabling HTTP Server authentication, 3-11, 10-10
enabling iSQL*Plus, 3-14
Enter statements field, 2-6, 2-7
entities, HTML, 8-12
ENTMAP, 4-6
ENTMAP clause, 4-6, 8-12, 13-30
error messages
copy command, 14-45
iSQL*Plus, 14-35
sqlplus, 14-2
error messages, interpreting, 5-15
errors, making line containing current, 6-6
escape characters, definition of, 13-108
ESCAPE variable, 6-23, 13-108
example
embedded CGI report, 8-7
interactive HTML report, 8-3, 8-6
execute button, 2-6
EXECUTE command, 13-63
disabling, 10-5
executing
a CREATE command, 5-6
statements, 5-3
executing scripts
See running
execution plan, 9-3
execution statistics
including in report, 13-102
EXIT clause
WHENEVER OSERROR, 13-152
WHENEVER SQLERROR, 13-154
EXIT command, 4-13, 13-64
:BindVariable clause, 13-65
COMMIT clause, 13-64
disabling, 10-5
FAILURE clause, 13-64
in a script, 13-133
ROLLBACK clause, 13-65
use with SET MARKUP, 8-3
WARNING clause, 13-64
exit, conditional, 13-152, 13-154
exiting
iSQL*Plus, 4-15
Expired Password screen, 4-19
extension, 13-93, 13-121, 13-138
extension for windows, 2-16

F

FAILURE clause, 13-64
FEEDBACK variable, 13-108
fields
connection identifier, 2-5, 2-11
define substitution variables, 6-25
enter statements, 2-6, 2-7
new password, 4-19
old password, 4-19
password, 2-4, 2-11
privilege, 2-11
retype new password, 4-19
script location, 2-8
username, 2-4, 2-11, 3-16, 4-19
file extensions, 3-3, 13-93, 13-121, 13-138
file names
in @ ("at" sign) command, 13-5
in @@ (double "at" sign) command, 13-7
in EDIT command, 13-61
in GET command, 13-66
in SAVE command, 13-93
in SPOOL command, 7-34, 13-131
in SQLPLUS command, 4-12
files
configuring associations, 3-5
flat, 7-34
output, 2-9
FLAGGER variable, 13-108
flat file, 7-34
FLUSH variable, 13-109
FOLD_AFTER clause, 13-31
FOLD_BEFORE clause, 13-31
font
national language support, 12-3
footers
aligning elements, 13-90
displaying at bottom of page, 13-87
displaying system-maintained values, 13-89
formatting elements, 13-90
footers (continued)
indenting, 13-90
listing current definition, 13-87
setting at the end of reports, 7-23
suppressing definition, 13-90
FORCE clause, 13-134
FORMAT clause, 13-10, 13-31
in ATTRIBUTE command, 13-17
in COLUMN command, 7-5, 7-6
in REPHEADER and REPFOOTER commands, 13-90
in TTITLE and BTITLE commands, 7-28, 13-142
format models, number, 7-5, 13-33
formfeed, to begin a new page, 7-32, 13-114
FROM clause, 13-80
FROM clause (SQL*Plus), B-5
functionality, 2-3

G

GET command, 13-66
disabling, 10-5
LIST clause, 13-66
NOLIST clause, 13-66
retrieving scripts, 13-66
globalization support, 12-1
Oracle9i database, 12-2, 12-4
GLOGIN.SQL, 3-2, 9-4, 9-8
See also LOGIN.SQL
glogin.sql, 10-13
GRANT command, 10-2
disabling, 10-5

H

HEAD clause, 4-6
HEAD option, 4-6
headers
aligning elements, 7-25
displaying at top of page, 13-89
displaying system-maintained values, 13-89
setting at the start of reports, 7-23
suppressing, 7-25
HEADING clause, 7-2, 13-34
HEADING variable, 13-109
headings
aligning elements, 13-90
column headings, 13-109
formatting elements, 13-90
indenting, 13-90
listing current definition, 13-91
suppressing definition, 13-90
HEADSEP variable, 13-110
use in COLUMN command, 7-3, 13-34
help
iSQL*Plus online, 4-14
HELP command, 13-68
help, online, 4-12, 13-68
HIDE clause, 13-11
History screen, 2-6
HOST command, 5-13, 13-69
disabling, 10-5
host operating system
editor, 6-2, 13-61
file, loading into buffer, 13-66
running commands from SQL*Plus, 5-12, 13-69
HTML, 8-2
clause, 4-5
entities, 8-12
option, 4-5
running dynamic reports, 8-13
spooling to file, 4-8
tag, 8-2
htpasswd
adding username/password file entries, 10-12
HTTP
HTTPS security, 10-9
security, 10-9
HTTP Server
adding authentication entries, 10-12
authentication, 2-10, 10-10
authentication username/password entries, 3-11
configuring, 3-12
configuring globalization support, 12-4
enabling DBA, 10-11
testing configuration file, 3-12
httpd.conf, 3-12
testing httpd.conf edits, 3-15
hyphen, continuing SQL*Plus command, 5-9, 13-1

I

-idle-timeout parameter, 9-14
IMMEDIATE mode, 13-129
infinity sign (~), 13-34
initialization parameters
displaying, 13-125
INIT.ORA file
parameter file, 13-134
input
accepting [Return], 6-30
accepting values from the user, 6-27, 13-10
input area, 2-6
editing, 5-2
INPUT command, 6-4, 6-7, 13-71
entering several lines, 13-71
INSERT clause, B-3, B-7
INSERT command
disabling, 10-5
installation
default users created, 4-17
INSTANCE variable, 13-110
instances
shutting down, 13-129
starting, 13-134
Interface options screen, 2-9
iplus.css, 3-11
iplusdba.pw, 10-11
iplus.pw, 10-10
iSQL*Plus, 2-3
access modes, 10-9
cascading style sheet, 3-11
Change Password screen, 4-19
configuring, 3-5
configuring extension for windows, 3-15
configuring globalization support, 12-3
configuring HTTP Server, 3-12
configuring Oracle Net, 3-15
DBA Login screen, 2-10
DBA Work screen, 2-12
enabling cookies, 3-5
enabling HTTP Server authentication, 3-11
enabling javascript, 3-5
enabling or disabling, 3-14
entering commands, 2-6
exiting, 4-15
Expired Password screen, 4-19
extension for windows, 2-16
globalization support, 12-1
History screen, 2-6
Interface options screen, 2-9
iSQLPlusHashTableSize parameter, 9-13
iSQLPlusNumberOfThreads parameter, 9-13
language support, 4-14
Login screen, 2-4, 4-14
online help, 4-14
overview, 2-3
Preferences screen, 2-8
security, 10-9
Server configuration, 3-7
server parameters, 2-14
server statistics, 2-12
session, 1-5
setting system variables, 2-14
starting, 4-14, 4-15
System variables screen, 2-14
three-tier model, 1-4
unsupported commands, D-1
user access, 10-9
user interface, 1-4, 1-5, 2-3
Work screen, 2-5
iSQL*Plus error messages, 14-35
iSQL*Plus Server
active statistics, 9-12
authentication, 10-10
configuring httpd.conf, 3-12
configuring oracle_apache.conf, 3-12
enabling DBA access, 10-11
enabling restricted database access, 10-10
isqlplus.conf, 3-8, 3-9, 3-10, 3-11, 3-12, 10-11
iSQLPlusConnectIdList, 10-10
iSQLPlusHashTableSize parameter, 9-13
iSQLPlusNumberOfThreads parameter, 9-13
iSQLPlusTimeOutInterval parameter, 9-14

J

Japanese, 12-2, 12-3
javascript, configuring for iSQL*Plus, 3-5
JUSTIFY clause, 13-34

L

LABEL variable
SHOW command, C-2, C-7
labels
in COMPUTE command, 7-17, 13-41
language support in iSQL*Plus, 4-14
LEFT clause, 7-26, 13-90, 13-142
LIKE clause, 7-9, 13-17, 13-34
limits, SQL*Plus, A-1
line numbers, for SQL commands, 5-4
lines
adding at beginning of buffer, 13-71
adding at end of buffer, 13-71
adding new after current, 6-7, 13-71
appending text to, 6-8, 13-12
changing width, 7-32, 13-111
deleting all in buffer, 13-51
deleting from buffer, 6-9, 13-51
determining which is current, 6-6
editing current, 6-6
listing all in buffer, 6-4, 13-73
removing blanks at end, 13-122
LINESIZE variable, 7-25, 7-32, 13-111
LIST clause, 13-13, 13-66
LIST command, 6-4, 13-73
determining current line, 6-6, 13-73
making last line current, 6-6, 13-73
using an asterisk, 6-4, 13-73
LNO clause, 13-125
load script button, 2-6
LOBOFFSET variable, 13-111
LOCK TABLE command
disabling, 10-5
log in button, 2-5, 2-12
LOG_ARCHIVE_DEST parameter, 13-13
LOGFILE clause, 13-80
logging off
conditionally, 13-152, 13-154
Oracle, 4-18, 13-60
SQL*Plus, 4-13, 13-64
logging on
default users created at installation, 4-17
Oracle, 4-22, 13-46
SQL*Plus, 4-2
Login screen, 2-4, 2-10, 4-14, 10-10
LOGIN.SQL, 3-2
including SET commands, 3-3
sample commands to include, 3-3
See also GLOGIN.SQL
storing current date in variable for titles, 7-31
login.sql
See glogin.sql
Logout, 4-15
LONG
column definition from DESCRIBE, 13-53
LONG columns
changing format, 7-6, 13-31
default format, 13-31
setting maximum width, 13-112
setting retrieval size, 13-112
LONG variable, 13-112
effect on COPY command, B-4, B-8
LONGCHUNKSIZE variable, 7-6, 13-31, 13-112
LONGRAW
column definition from DESCRIBE, 13-53

M

-MARKUP, 4-4, 8-2
SPOOL clause, 4-6
SQLPLUS command clause, 4-5
MARKUP, 4-4, 8-2, 13-112
BODY clause, 4-6
ENTMAP clause, 4-6
HEAD clause, 4-6
PREFORMAT clause, 4-8
SPOOL clause, 4-6
TABLE clause, 4-6
MAXDATA variable, C-2, C-6
MAXIMUM function, 7-17
media recovery, 13-135
message, sending to screen, 6-27, 13-78
Microsoft Internet Explorer
configuring proxy exceptions, 3-6
middle tier, 1-4
configuration, 3-7
MIME type
configuration, 3-5
MINIMUM function, 7-17
mod_ssl, 10-9
MOUNT clause, 13-135
mounting a database, 13-135

N

national language support, 12-2, 12-3
character encoding, 12-3
font, 12-3
See also globalization support
NCHAR clause
VARIABLE command, 13-145
NCHAR columns
changing format, 7-6, 13-31
default format, 7-6, 13-31
NCLOB clause
VARIABLE command, 13-146
NCLOB columns
changing format, 7-6, 13-31
default format, 13-31
setting maximum width, 13-112
setting retrieval position, 13-111
setting retrieval size, 13-112
negative infinity sign (-~), 13-34
Netscape Navigator
configuring proxy exceptions, 3-6
new password field, 4-19
NEW_VALUE clause, 7-29, 13-34
storing current date in variable for titles, 7-31, 13-35
NEWLINE clause, 13-34
NEWPAGE command, C-2, C-4
NEWPAGE variable, 7-32, 13-114
NEXT clause, 13-14
NLS, 12-2, 12-3
NLS_DATE_FORMAT, 13-10, 13-39
NOAUDIT command
disabling, 10-5
NOLIST clause, 13-66
NOLOG, 4-11
/NOLOG option, 4-11
NOMOUNT clause, 13-135
NONE clause
WHENEVER OSERROR, 13-153
WHENEVER SQLERROR, 13-155
NOPRINT clause, 7-17, 7-29, 13-35
NOPROMPT clause, 13-11
NORMAL mode, 13-129
NULL clause, 13-35
null values
setting text displayed, 13-35, 13-114
NULL variable, 13-114
NUMBER
column definition from DESCRIBE, 13-53
NUMBER clause, 6-30, 13-10
VARIABLE command, 13-145
NUMBER columns
changing format, 7-4, 13-32
default format, 7-4, 13-33
number formats
$, 7-5
0, 7-5
9, 7-5
comma, 7-5
setting default, 13-114
NUMBER function, 7-17
NUMFORMAT clause
in LOGIN.SQL, 3-3
NUMFORMAT variable, 13-114
NUMWIDTH variable, 13-114
effect on NUMBER column format, 7-4, 13-33
NVARCHAR2 columns
changing format, 7-6, 13-31
default format, 7-6, 13-31

O

objects, describing, 13-106
obsolete commands
BTITLE, C-3
COLUMN command DEFAULT clause, C-3
DOCUMENT, C-2, C-3
NEWPAGE, C-2, C-4
SET command BUFFER variable, C-4
SET command CLOSECURSOR variable, C-2, C-5
SET command DOCUMENT variable, C-2, C-5
SET command MAXDATA variable, C-2, C-6
SET command SCAN variable, C-2, C-6
obsolete commands (continued)
SET command SPACE variable, C-2, C-6
SET command TRUNCATE variable, C-2, C-7
SHOW command LABEL variable, C-2, C-7
TTITLE command old form, C-7
OF clause, 7-16
OFF clause, 13-36
in ATTRIBUTE command, 13-17
in COLUMN command, 7-10, 13-36
in REPFOOTER commands, 13-90
in REPHEADER commands, 13-90
in SPOOL command, 7-34, 13-131
in TTITLE and BTITLE commands, 7-29, 13-141
old password field, 4-19
OLD_VALUE clause, 7-30, 13-35
ON clause
in ATTRIBUTE command, 13-17
in COLUMN command, 7-10, 13-36
in TTITLE and BTITLE commands, 7-29
ON column clause
in BREAK command, 7-13, 13-18
in COMPUTE command, 7-16, 13-41
ON expr clause
in BREAK command, 13-19
in COMPUTE command, 13-41
ON REPORT clause
in BREAK command, 7-20, 13-20
in COMPUTE command, 7-20, 13-41
ON ROW clause
in BREAK command, 7-14, 13-20
in COMPUTE command, 13-41
online help, 4-12, 13-68
OPEN clause, 13-135
opening a database, 13-135
Oracle HTTP Server, 1-5
administrator, 10-12
authentication username/password entries, 3-11, 10-11
configuration, 3-7
configuring, 3-12
configuring globalization support, 12-4
glogin.sql, 10-13
Product User Profile table, 10-13
starting and stopping, 3-13
testing configuration file, 3-12
Oracle Net, 1-4, 10-9
connect identifier, 13-46
protocol, 4-22
security, 10-9
Oracle Net, configuring, 3-15
oracle_apache.conf, 3-12, 3-14
Oracle9i, 1-4, 3-15
globalization support, 12-2, 12-4
ORDER BY clause
displaying column values in titles, 7-29
displaying values together in output, 7-12
OUT clause, 7-35, 13-131
output
formatting white space in, 13-122
pausing during display, 5-15, 13-115
output options
file, 2-9
new window, 2-9
work screen, 2-9

P

PAGE clause, 13-89
page number, including in titles, 7-15, 7-27
pages
changing length, 7-31, 13-115
default dimensions, 7-31
matching to screen or paper size, 7-31
setting dimensions, 7-31
PAGESIZE clause
in LOGIN.SQL, 3-3
PAGESIZE variable, 5-4, 7-32, 13-115
parameter files (INIT.ORA files)
specifying alternate, 13-134
parameters, 6-26, 13-5, 13-132
-idle-timeout, 9-14
iSQL*Plus server, 2-14
iSQLPlusHashTableSize, 9-13
iSQLPlusNumberOfThreads, 9-13
iSQLPlusTimeOutInterval, 9-14
PARAMETERS clause, 13-125
parsing httpd.conf file, 3-15
password, 4-17
changing in iSQL*Plus, 2-8, 4-19
password (continued) password (continued)
changing with the PASSWORD command, 13-75
field, 2-4, 2-11
HTTP Server authentication, 2-10
in CONNECT command, 4-18, 4-22, 13-46
in COPY command, B-5, B-8, B-9
in SQLPLUS command, 4-2, 4-10, 4-21
viewable warning, 4-10
PASSWORD command, 13-46, 13-75
disabling, 10-5
PAUSE command, 6-30, 13-76
in LOGIN.SQL, 3-3
PAUSE variable, 5-15, 13-115
performance
of SQL statements, 9-2
over dial-up lines, 13-122
period (.)
terminating PL/SQL blocks, 5-7, 13-102
PLAN_TABLE table, 9-2
PLAN_TABLE, creating, 9-2
PL/SQL, 5-7
blocks, PL/SQL, 5-7
executing, 13-63
formatting output in SQL*Plus, 13-147
listing definitions, 5-14
mode in SQL*Plus, 5-6
within SQL commands, 5-6
PLUSTRACE role, 9-2
PLUSTRACE, creating role, 9-3
PNO clause, 13-126
pound sign (#), 13-34
Preferences screen, 2-8
PREFORMAT, 4-8
PREFORMAT clause, 4-8
PRINT clause, 13-35
PRINT command, 13-77
printing
bind variables automatically, 13-101
REFCURSOR variables, 13-147
SPOOL command, 13-131
privileges
list, 2-11
Product User Profile table, 10-13
PRODUCT_USER_PROFILE table, 10-2
prompt
SET SQLPROMPT, 13-120
PROMPT clause, 6-28, 13-11
PROMPT command, 6-27, 13-78
customizing prompts for value, 6-29
prompts for value
bypassing with parameters, 6-26
customizing, 6-29
through ACCEPT, 6-27
through substitution variables, 6-19
proxy server exceptions
configuration, 3-6
Microsoft Internet Explorer, 3-6
Netscape Navigator, 3-6
PUPBLD.SQL, 10-2

Q

queries
in COPY command, B-3, B-6
show number of records retrieved, 5-4, 13-108
queries, tracing, 9-7
query execution path
including in report, 13-102
query results
displaying on-screen, 5-4
sending to a printer, 7-35, 13-131
storing in a file, 7-34, 13-131
QUIT command, 13-64
See also EXIT

R

RAW
column definition from DESCRIBE, 13-53
record separators, printing, 7-10, 13-115
RECOVER clause, 13-135
RECOVER command, 13-79
and database recovery, 11-5
AUTOMATIC clause, 13-80
CANCEL clause, 13-81, 13-83
CONTINUE clause, 13-80
DATABASE clause, 13-81
FROM clause, 13-80
RECOVER command (continued) RECOVER command (continued)
LOGFILE clause, 13-80
STANDBY DATABASE clause, 13-81
STANDBY DATAFILE clause, 13-82
STANDBY TABLESPACE clause, 13-82
UNTIL CANCEL clause, 13-81
UNTIL CONTROLFILE clause, 13-82
UNTIL TIME clause, 13-81
USING BACKUP CONTROL FILE clause, 13-81
recovery
RECOVER command, 13-79
RECSEP variable, 7-10, 13-115
RECSEPCHAR variable, 7-10, 13-115
redo Log Files
ARCHIVE LOG command, 13-13
REFCURSOR bind variables
in a stored function, 6-32
REFCURSOR clause
VARIABLE command, 13-147
RELEASE clause, 13-126
REMARK command, 6-10, 13-86
remote database
connect identifier, 2-5, 2-11, 4-21
removing sample tables, 1-8
RENAME command, disabling, 10-5
REPFOOTER clause, 13-126
REPFOOTER command, 7-23, 13-87
aligning footer elements, 13-90
BOLD clause, 13-90
CENTER clause, 13-90
COL clause, 13-90
FORMAT clause, 13-90
indenting report footers, 13-90
LEFT clause, 13-90
OFF clause, 13-90
RIGHT clause, 13-90
SKIP clause, 13-90
suppressing current definition, 13-90
TAB clause, 13-90
REPHEADER clause, 13-126
REPHEADER command, 7-23, 13-89
aligning header elements, 7-25
aligning heading elements, 13-90
BOLD clause, 13-90
CENTER clause, 13-90
COL clause, 13-90
FORMAT clause, 13-90
indenting headings, 13-90
LEFT clause, 13-90
OFF clause, 13-90
PAGE clause, 13-89
RIGHT clause, 13-90
SKIP clause, 13-90
suppressing current definition, 13-90
TAB clause, 13-90
REPLACE clause
in COPY command, B-3, B-7
in SAVE command, 13-93
reports
autotrace, 9-2
breaks, 13-18
clarifying with spacing and summary lines, 7-12
columns, 13-30
creating bottom titles, 7-23, 13-23, C-2
creating dynamic, 8-13
creating footers, 13-87
creating headers, 13-89
creating headers and footers, 7-23
creating master/detail, 7-29, 13-35
creating top titles, 7-23, 13-141, C-2
displaying, 13-102
embedded CGI example, 8-7
formatting column headings, 7-2, 13-29
formatting columns, 7-4, 7-6, 13-29
interactive HTML example, 8-3, 8-6
on the web, 8-2
running from a URL, 8-13
SILENT mode, 8-12
starting on a new page, 13-107
title, 13-141, C-2
RESTRICT, 4-9, 10-8, 13-134
restricted database access, 10-10
return code, specifying, 6-17, 13-65, 13-155
retype new password field, 4-19
REVOKE command, 10-2
disabling, 10-5
RIGHT clause, 7-26, 13-90, 13-142
roles, 10-6
disabling, 10-7
re-enabling, 10-8
ROLLBACK clause, 13-65
WHENEVER OSERROR, 13-152
WHENEVER SQLERROR, 13-154
ROWID
column definition from DESCRIBE, 13-53
rows
performing computations on, 7-16, 13-40
setting number retrieved at one time, 9-10, 13-100
setting the number after which COPY commits, 13-105
RUN command, 5-7, 13-92
disabling, 10-5
executing current PL/SQL block, 5-7
executing current SQL command or PL/SQL block, 5-7
making last line current, 6-6
similar to / (slash) command, 5-7, 13-92

S

sample tables
access to, 1-8
creating, 1-8
removing, 1-8
unlocking, 1-7
SAVE command, 13-93
APPEND clause, 13-93
CREATE clause, 13-93
disabling, 10-5
REPLACE clause, 13-93
storing commands in scripts, 13-93
using with INPUT to create scripts, 6-3
save script button, 2-6
saving environment attributes, 13-138
SCAN variable, C-2, C-6
SCREEN clause, 6-30, 13-27
screen, clearing, 6-30, 13-27
screens
Change Password, 4-19
connection identifier field, 2-5, 2-11
DBA Login, 2-10
DBA Work screen, 2-12
define substitution variables field, 6-25
enter statements field, 2-6, 2-7
Expired Password, 4-19
History, 2-6
Interface options, 2-9
Login, 2-4, 2-10
new password field, 4-19
old password field, 4-19
password field, 2-4, 2-11
Preferences, 2-8
privilege list, 2-11
retype new password field, 4-19
script location field, 2-8
System variables, 2-14
username field, 2-4, 2-11, 3-16, 4-19
Work, 2-5
scripts
editing, 5-2
extension, 13-93, 13-121, 13-138
location field, 2-8
See also command files
Secure Sockets Layer security, 10-9
security
changing password, 13-75
embedded web reports, 8-7
HTTP, 10-9
Oracle HTTP Server, 10-9
Oracle Net, 10-9
password viewable, 4-10
PRODUCT_USER_PROFILE table, 10-2
RESTRICT, 4-9, 10-8
Secure Sockets Layer (SSL), 10-9
SELECT command
and BREAK command, 7-12, 13-19, 13-20
and COLUMN command, 13-30
and COMPUTE command, 7-12
and COPY command, B-3, B-6
and DEFINE command, 13-49
and ORDER BY clause, 7-12
disabling, 10-5
formatting results, 6-32
storing current date in variable for titles, 7-31
semicolon (;)
in PL/SQL blocks, 5-7
in SQL commands, 5-4, 5-5
in SQL*Plus commands, 5-10, 13-1
not stored in buffer, 6-5
server
iSQL*Plus parameters, 2-14
SERVEROUTPUT variable, 13-116
service name
in CONNECT command, 4-22
in COPY command, B-5, B-8, B-9
in SQLPLUS command, 4-21
session
concurrent, 1-5
identification, 1-5, 3-7, 4-14
stateful behavior, 3-7
SET AUTOTRACE, 9-2
SET clause, 13-138
SET command, 3-3, 5-10, 13-95
affecting substitution variables, 6-24
APPINFO variable, 9-10, 13-99
ARRAYSIZE variable, 9-10, 13-100, B-8
AUTOCOMMIT variable, 5-11, 13-101
AUTOPRINT variable, 13-101, 13-147
AUTORECOVERY variable, 13-101
AUTOTRACE variable, 13-102
BLOCKTERMINATOR variable, 13-102
BUFFER variable, C-4
CLOSECURSOR variable, C-2, C-5
CMDSEP variable, 13-103
COLSEP variable, 7-34, 13-104
COMPATIBILITY variable, 13-104
CONCAT variable, 6-23, 13-105
COPYCOMMIT variable, 13-105, B-8
COPYTYPECHECK variable, 13-105
DEFINE clause, 6-23
DEFINE variable, 13-105
DESCRIBE variable, 13-106
disabling, 10-5
DOCUMENT variable, C-2, C-5
ECHO variable, 6-14, 13-107
EDITFILE variable, 13-107
EMBEDDED variable, 13-107
ESCAPE variable, 6-23, 13-108
FEEDBACK variable, 13-108
FLAGGER variable, 13-108
FLUSH variable, 13-109
HEADING variable, 13-109
HEADSEP variable, 7-3, 13-110
INSTANCE variable, 13-110
LINESIZE variable, 7-25, 7-32, 13-111
LOBOFFSET variable, 13-111
LOGSOURCE variable, 13-111
LONG variable, 13-112, B-8
LONGCHUNKSIZE variable, 13-112
MARKUP clause, 13-112
MAXDATA variable, C-2, C-6
NEWPAGE variable, 7-32, 13-114
NULL variable, 13-114
NUMFORMAT clause, 3-3
NUMFORMAT variable, 13-114
NUMWIDTH variable, 7-4, 13-33, 13-114
PAGESIZE clause, 3-3
PAGESIZE variable, 5-4, 7-32, 13-115
PAUSE clause, 3-3
PAUSE variable, 5-15, 13-115
RECSEP variable, 7-10, 13-115
RECSEPCHAR variable, 7-10, 13-115
SCAN variable, C-2, C-6
SERVEROUTPUT variable, 13-116
SHIFTINOUT variable, 13-117
SPACE variable, C-2, C-6
SQLBLANKLINES variable, 13-118
SQLCASE variable, 13-119
SQLCONTINUE variable, 13-119
SQLNUMBER variable, 13-120
SQLPLUSCOMPATIBILITY variable, 13-120
SQLPREFIX variable, 13-120
SQLPROMPT variable, 13-120
SQLTERMINATOR variable, 13-121
SUFFIX variable, 13-121
TAB variable, 13-122
TERMOUT variable, 13-122
TIME clause, 3-3
TIME variable, 13-122
TIMING variable, 13-122
TRIMOUT variable, 13-122
TRIMSPOOL variable, 13-123
TRUNCATE variable, C-2, C-7
UNDERLINE variable, 13-123
used to format a REFCURSOR variable, 13-147
VERIFY clause, 6-19
VERIFY variable, 6-23, 13-123
WRAP variable, 7-7, 13-123
SET MARKUP
BODY clause, 4-6
embedded CGI example, 8-7
ENTMAP clause, 4-6, 8-12
HEAD clause, 4-6
HTML, 4-5
interactive HTML example, 8-3, 8-6
PREFORMAT clause, 4-8
See also SPOOL command
SPOOL clause, 4-6
TABLE clause, 4-6
SET ROLE command
disabling, 10-5
SET TRANSACTION command
disabling, 10-5
SET variables, 5-10
See system variables
SGA clause, 13-126
SHIFTINOUT variable, 13-117
SHOW clause, 13-139
SHOW command, 5-11, 13-124
ALL clause, 13-124
BTITLE clause, 13-124
ERRORS clause, 13-125
LABEL variable, C-2, C-7
listing current page dimensions, 7-33
LNO clause, 13-125
PNO clause, 13-126
RELEASE clause, 13-126
REPFOOTER clause, 13-126
REPHEADER clause, 13-126
SPOOL clause, 13-126
SQLCODE clause, 13-126
TTITLE clause, 13-126
USER clause, 13-126
SHOWMODE variable, 13-118
SHUTDOWN command, 13-129
ABORT, 13-129
IMMEDIATE, 13-129
NORMAL, 13-129
TRANSACTIONAL LOCAL, 13-130
-SILENT option, 4-10, 8-12
site profile
GLOGIN.SQL, 3-2
LOGIN.SQL, 3-2
See also user profile
SKIP clause
in BREAK command, 7-13, 7-14, 13-20
in REPHEADER and REPFOOTER commands, 13-90
in TTITLE and BTITLE commands, 7-26, 13-142
to place blank lines before bottom title, 7-26
SKIP PAGE clause, 7-13, 7-14, 13-21
slash (/) command, 13-9
files loaded with GET command, 13-66
SPACE variable, C-2, C-6
SPOOL clause, 4-6, 4-7, 13-126
SPOOL command, 7-33, 13-131
disabling, 10-5
file name, 7-34, 13-131
OFF clause, 7-34, 13-131
OUT clause, 7-35, 13-131
to HTML file, 4-8
turning spooling off, 7-34, 13-131
use with SET MARKUP, 8-3
SQL buffer, 5-2
SQL clause, 13-28
SQL DML statements
reporting on, 13-102
SQL optimizer, 9-3
SQL*Plus
command prompt, 4-2
command summary, 13-2,
command-line, 2-2
configuring globalization support, 12-2
database administration, 11-2
execution plan, 9-3
exiting, 4-13, 13-64
exiting conditionally, 13-152, 13-154
globalization support, 12-1
limits, A-1
obsolete command alternatives, C-2
running commands in batch mode, 6-17
setting up environment, 3-2
shortcuts to starting, 4-3
starting, 4-2, 4-3
statistics, 9-4
system variables affecting performance, 9-10
tuning, 9-2
who can use, 1-5
SQL*Plus error messages, 14-2
SQLBLANKLINES variable, 13-118
SQLCASE variable, 13-119
SQLCODE clause, 13-126
SHOW command, 13-126
SQLCONTINUE variable, 13-119
SQLNUMBER variable, 13-120
SQLPLUS command, 4-2
- clause, 4-4
-? clause, 4-4
and @ ("at" sign), 4-3, 4-21, 6-15
and EXIT FAILURE, 6-16
BODY option, 4-6
commands
SQLPLUS, 4-3
connect identifier, 4-11
connecting to a remote database, 4-21
display syntax, 4-4
ENTMAP option, 4-6
HEAD option, 4-6
HTML option, 4-5
-MARKUP clause, 4-5
-MARKUP option, 4-4
-MARKUP SPOOL clause, 4-6
/NOLOG clause, 4-11
PREFORMAT option, 4-8
RESTRICT, 4-9, 10-8
running scripts, 6-15
service name, 4-11, 4-21
-SILENT clause, 4-10
-SILENT option, 4-10, 8-12
SPOOL clause, 4-7
syntax, 4-3
SYSDBA clause, 4-11
TABLE option, 4-6
unsuccessful connection, 6-16
username/password, 4-2, 4-10
SQL.PNO, referencing in report titles, 7-27
SQLPREFIX variable, 13-120
SQLPROMPT variable, 13-120
SQL.SQLCODE
using in EXIT command, 13-64
SQLTERMINATOR, 13-118
SQLTERMINATOR variable, 13-69, 13-121
SSL security, 10-9
STANDBY DATAFILE clause, 13-82
STANDBY TABLESPACE clause, 13-82
START clause, 13-14, 13-139
START command, 6-14, 13-132
arguments, 6-26
disabling, 10-5
passing parameters to a script, 6-26
script, 6-14, 13-132
similar to @ ("at" sign) command, 6-14, 13-6, 13-133
similar to @@ (double "at" sign) command, 13-8, 13-133
starting
iSQL*Plus, 4-14, 4-15
Oracle HTTP Server, 3-13
SQL*Plus, 2-2, 4-2
SQL*Plus shortcuts, 4-3
STARTUP command, 13-134
FORCE clause, 13-134
MOUNT clause, 13-135
NOMOUNT clause, 13-135
OPEN clause, 13-135
PFILE clause, 13-134
RECOVER clause, 13-135
RESTRICT clause, 13-134
specifying a database, 13-135
statements
executing, 5-3
statistics, 9-4
collecting TIMING statistics, 9-7
interpreting iSQL*Plus active statistics, 9-13
iSQL*Plus Server, 2-12
iSQL*Plus Server active statistics, 9-12
STD function, 7-17
STOP clause, 13-14, 13-139
stop query, 5-12
stopping Oracle HTTP Server, 3-13
STORE command, 3-3, 13-138
SET clause, 13-138
stored functions, 6-32
stored procedures
creating, 5-6
substitution variables, 6-18, 6-24
appending characters immediately after, 6-20
avoiding unnecessary prompts for value, 6-21
substitution variables (continued) substitution variables (continued)
concatenation character, 13-105
DEFINE command, 6-21, 13-49
defined, 6-21
parsing, 9-11
prefixing, 13-105, C-2
restrictions, 6-23
single and double ampersands, 6-21
system variables used with, 6-23
undefined, 6-19
where and how to use, 6-19
SUFFIX variable, 13-121
used with @ ("at" sign) command, 13-5
used with EDIT command, 13-61
used with GET command, 13-66
used with SAVE command, 13-93
used with START command, 13-132
SUM function, 7-17
summary lines
computing and printing, 7-16, 13-40
computing and printing at ends of reports, 7-20
computing same type, different columns, 7-20
printing "grand" and "sub" summaries (totals), 7-20
printing multiple on same break column, 7-21
syntax
COPY command, B-5
syntax rules
SQL commands, 5-4
SQL*Plus commands, 5-9
SYSDATE, 7-31
SYSDBA clause, 13-47
SYSOPER clause, 4-11, 13-47
system variables, 5-10,
affecting SQL*Plus performance, 9-10
listing current settings, 5-11, 13-124
listing old and new values, 13-118
setting in iSQL*Plus, 2-14
storing and restoring, 3-3
used with substitution variables, 6-23
System variables screen, 2-14
system-maintained values
displaying in headers and footers, 13-89
displaying in titles, 7-27, 13-141
formatting in titles, 7-28

T

TAB clause, 13-90, 13-142
TAB variable, 13-122
TABLE clause, 4-6
TABLE option, 4-6
tables
access to sample, 1-8
controlling destination when copying, B-3, B-7
copying values between, B-2, B-5, B-9
listing column definitions, 5-13, 13-53
referring to another user's when copying, B-9
TABLESPACE clause, 13-81
tablespaces, recovering, 13-79
tag, HTML, 8-2
TERMOUT variable, 13-122
using with SPOOL command, 13-131
text, 4-6
adding to current line with APPEND, 6-8, 13-12
changing old to new with CHANGE, 6-6, 13-24
clearing from buffer, 6-4, 13-27
text editor, host operating system, 6-2, 13-61
three-tier model, 1-4
TIME clause in LOGIN.SQL, 3-3
TIME variable, 13-122
TIMING clause, 13-28
TIMING command, 9-7, 13-139
deleting all areas created by, 13-28
deleting current area, 13-139
SHOW clause, 13-139
START clause, 13-139
STOP clause, 13-139
TIMING variable, 13-122
titles
aligning elements, 7-25, 13-142
displaying at bottom of page, 7-23, 13-23, C-2
displaying at top of page, 7-23, 13-141, C-2
displaying column values, 7-29, 13-34, 13-35
displaying current date, 7-30, 13-35, 13-37
displaying page number, 7-27, 13-143
displaying system-maintained values, 7-27, 13-141
formatting elements, 13-142
formatting system-maintained values in, 7-28
indenting, 7-26, 13-142
titles (continued)
listing current definition, 7-29, 13-23, 13-143
restoring definition, 7-29
setting at start or end of report, 7-23
setting lines, top of page to top title, 7-32, 13-114, C-2
setting lines, top title to page end, 13-115
setting top and bottom, 7-23, 13-23, 13-141, C-2
spacing between last row and bottom title, 7-26
suppressing definition, 7-29, 13-141
TNS alias, 2-5, 2-11, 4-21
TO clause, B-5
tracing queries, 9-7
tracing statements
for performance statistics, 9-5
for query execution path, 9-5
using a database link, 9-7
with parallel query option, 9-8
TRIMOUT variable, 13-122
TRIMSPOOL variable, 13-123
TRUNCATE command
disabling, 10-5
TRUNCATE variable, C-2, C-7
TRUNCATED clause, 7-7, 13-36
TTITLE clause, 13-126
TTITLE command, 7-23, 13-141
aligning title elements, 7-25, 13-142
BOLD clause, 13-142
CENTER clause, 7-26, 13-142
COL clause, 7-26, 13-142
FORMAT clause, 7-28, 13-142
indenting titles, 7-26, 13-142
LEFT clause, 7-26, 13-142
listing current definition, 7-29, 13-143
OFF clause, 7-29, 13-141
old form, C-7
ON clause, 7-29
referencing column value variable, 7-29, 13-34
restoring current definition, 7-29
RIGHT clause, 7-26, 13-142
SKIP clause, 7-26, 13-142
suppressing current definition, 7-29, 13-141
TAB clause, 13-142
tuning
-idle-timeout, 9-14
iSQL*Plus active statistics, 9-12
iSQLPlusHashTableSize, 9-13
iSQLPlusNumberOfThreads, 9-13
iSQLPlusTimeOutInterval, 9-14
SET APPINFO OFF, 9-10
SET ARRAYSIZE, 9-10
SET DEFINE OFF, 9-11
SET FLUSH OFF, 9-11
SET SERVEROUTPUT OFF, 9-11
SET TRIMOUT ON, 9-11
SET TRIMSPOOL ON, 9-11
SQL*Plus, 9-2
system variables, 9-10

U

UNDEFINE command, 6-18, 13-144
and DEFINE command, 13-49
UNDERLINE variable, 13-123
unicode, 12-2, 12-3
unlocking sample tables, 1-7
UNTIL CANCEL clause, 13-81
UNTIL CHANGE clause, 13-81
UNTIL CONTROLFILE clause, 13-82
UNTIL TIME clause, 13-81
UPDATE command, disabling, 10-5
URL, 1-5
running dynamic reports, 8-13
starting iSQL*Plus, 4-15
USER clause, 13-126
user interfaces, 2-3
command-line, 2-2
user profile, 3-2
GLOGIN.SQL, 3-2
LOGIN.SQL, 3-2
See also site profile
user variables, 6-17
defining, 6-17, 13-49
deleting, 6-18, 13-144
displaying in headers and footers, 13-89
displaying in titles, 13-141
in ACCEPT command, 6-27, 13-10
listing definition of one, 6-17, 13-49
listing definitions of all, 6-18, 13-49
username, 4-17
connecting under different, 4-18, 13-46
created at installation, 4-17
field, 2-4, 2-11, 3-16, 4-19
in CONNECT command, 4-18, 13-46
in COPY command, B-5, B-8, B-9
in SQLPLUS command, 4-2, 4-10, 4-21
username/password
adding authentication file entries, 10-12
USING BACKUP CONTROL FILE clause, 13-81
USING clause, B-3, B-6
UTF-8, 12-2, 12-3

V

V$SESSION virtual table, 13-99
V$SQLAREA virtual table, 13-99
VARCHAR columns
changing format, 7-6
default format, 7-6, 13-31
VARCHAR2
column definition from DESCRIBE, 13-53
VARCHAR2 clause
VARIABLE command, 13-146
VARCHAR2 columns
changing format, 7-6, 13-31
default format, 7-6
VARIABLE command, 13-145
CHAR clause, 13-145
CLOB clause, 13-146
NCHAR clause, 13-145
NCLOB clause, 13-146
NUMBER clause, 13-145
REFCURSOR clause, 13-147
VARCHAR2 clause, 13-146
variable clause, 13-145
variables
bind variables, 6-31
substitution, 6-24
substitution variables, 6-18
system variables, 5-10
user variables, 13-49
VARIANCE function, 7-17
VERIFY clause, 6-19
VERIFY variable, 6-23, 13-123

W

WARNING clause, 13-64
web browser, 1-4, 2-3, 8-2
web, outputting reports, 8-2
WHENEVER OSERROR command, 13-152
COMMIT clause, 13-152
CONTINUE clause, 13-152
EXIT clause, 13-152
NONE clause, 13-153
ROLLBACK clause, 13-152
WHENEVER SQLERROR command, 6-17, 13-154
COMMIT clause, 13-154
CONTINUE clause, 13-154
EXIT clause, 13-154
NONE clause, 13-155
ROLLBACK clause, 13-154
window, output, 2-9
windows iSQL*Plus extension, 2-16
WORD_WRAPPED clause, 7-7, 7-10, 13-36
Work screen, 2-5
output options, 2-9
WRAP variable, 7-7, 13-123
WRAPPED clause, 7-7, 13-36

X

XMLType
column definition from DESCRIBE, 13-53
column formatting, 7-8
column width, 7-6
creating, 7-8
formatting in reports, 7-6
inserting values, 7-8
selecting data, 7-8
setting column retrieval size, 13-112
setting maximum column width, 13-112

Go to previous page
Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback