SQL*Plus User's Guide and Reference
Release 8.1.7
Part Number A82950-01
Library
Product
Contents
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
-- (comment delimiter),
3-12
- (hyphen)
clause,
7-2
continuing a long SQL*Plus command,
2-12
,
8-1
. (period),
2-10
/ (slash) command
default logon,
7-9
,
8-47
entered at buffer line-number prompt,
2-8
,
8-9
entered at command prompt,
2-10
,
8-9
executing current PL/SQL block,
2-10
executing current SQL command,
2-10
similar to RUN,
2-10
,
8-9
,
8-95
usage,
8-9
# pound sign,
8-35
$ number format,
4-5
& (ampersand)
substitution variables,
3-22
* (asterisk)
in DEL command,
3-2
,
8-54
in LIST command,
3-2
,
8-75
/*...*/ (comment delimiters),
3-12
: (colon)
bind variables,
3-31
:BindVariable clause
EXIT command,
8-67
; (semicolon),
2-6
@ ("at" sign)
command,
3-16
,
3-20
,
8-5
command arguments,
8-5
command file,
3-16
,
8-5
in CONNECT command,
6-3
,
8-47
in COPY command,
6-5
,
8-49
in SQLPLUS command,
3-17
,
6-4
,
7-2
passing parameters to a command file,
8-5
similar to START,
3-16
,
8-6
,
8-132
@@ (double "at" sign) command,
3-20
,
8-7
command file,
8-7
similar to START,
8-7
,
8-132
[Backspace] key,
2-2
[Cancel] key,
2-2
,
2-15
[Interrupt] key,
2-2
[Pause] key,
2-2
,
2-17
[Resume] key,
2-2
[Return] key,
2-2
_EDITOR, in EDIT command,
3-8
,
8-64
~ infinity sign,
8-35
-~ negative infinity sign,
8-35
0, number format,
4-5
9, number format,
4-5
A
ABORT mode,
8-128
ACCEPT command,
3-28
,
8-10
and DEFINE command,
8-52
CHAR clause,
8-10
customizing prompts for value,
3-30
DATE clause,
8-10
DEFAULT clause,
8-11
FORMAT clause,
8-10
HIDE clause,
8-11
NOPROMPT clause,
8-11
NUMBER clause,
3-30
PROMPT clause,
3-29
,
8-11
access, denying and granting,
E-2
account,
GL-1
,
GL-24
alias,
GL-1
,
GL-23
ALIAS clause,
8-31
in ATTRIBUTE command,
8-17
alignment,
GL-1
ALL clause,
8-123
ALTER command
disabling,
E-5
ampersands (&)
in parameters,
3-27
,
8-5
,
8-131
substitution variables,
3-22
ANALYZE command
disabling,
E-5
anonymous block,
GL-1
APPEND clause
in COPY command,
6-7
,
8-50
in SAVE command,
3-18
,
8-96
APPEND command,
3-2
,
3-6
,
8-12
APPINFO clause,
8-99
ARCH background process,
8-14
ARCHIVE LOG
command,
5-4
,
8-13
mode,
5-4
archived redo log,
GL-1
ARCHIVELOG,
GL-1
argument,
GL-2
in START command,
3-27
,
8-131
array processing,
GL-2
ARRAYSIZE variable,
8-100
relationship to COPY command,
6-8
,
8-51
ASCII,
GL-2
attribute
display characteristics,
8-17
ATTRIBUTE command,
8-17
ALIAS clause,
8-17
and CLEAR COLUMN command,
8-18
CLEAR clause,
8-18
clearing columns,
8-28
,
8-31
controlling display characteristics,
8-18
entering multiple,
8-18
FORMAT clause,
8-18
LIKE clause,
8-18
listing all attributes' display characteristics,
8-17
listing an attribute's display characteristics,
8-17
OFF clause,
8-18
ON clause,
8-18
restoring column display attributes,
8-18
suppressing column display attributes,
8-18
AUDIT command
disabling,
E-5
autocommit,
GL-2
AUTOCOMMIT variable,
2-14
,
8-100
AUTOMATIC clause,
8-82
AUTOPRINT variable,
8-101
AUTORECOVERY variable,
8-101
AUTOTRACE variable,
3-36
,
8-101
AVG function,
4-16
B
background process,
GL-2
startup after abnormal termination,
8-128
batch mode,
3-18
,
8-68
BEGIN command,
2-10
disabling,
E-6
bind reference,
GL-2
bind variables,
3-31
,
GL-2
,
GL-25
creating,
8-145
displaying,
8-79
displaying automatically,
8-101
,
8-146
in PL/SQL blocks,
8-146
in SQL statements,
8-146
in the COPY command,
8-146
REFCURSOR,
3-33
bit,
GL-3
blank line
in PL/SQL blocks,
2-10
in SQL commands,
2-8
preserving in SQL commands,
8-110
blocks,
GL-3
blocks, PL/SQL,
1-2
continuing,
2-10
editing in buffer,
3-2
editing with host system editor,
3-7
,
8-64
entering and executing,
2-10
listing current in buffer,
3-3
run from SQL buffer,
2-10
saving current,
3-8
,
8-96
setting character used to end,
8-102
stored in SQL buffer,
2-10
storing in command files,
3-8
timing statistics,
8-111
within SQL commands,
2-8
BLOCKTERMINATOR,
8-102
,
8-110
,
8-111
body,
GL-3
BODY clause,
7-4
BODY option,
7-4
BOLD clause,
8-92
,
8-141
break,
GL-3
break columns,
4-11
,
8-19
,
GL-3
inserting space when value changes,
4-13
specifying multiple,
4-14
suppressing duplicate values in,
4-12
BREAK command,
4-11
,
8-19
and SQL ORDER BY clause,
4-11
,
4-12
,
4-14
,
8-20
clearing BREAKS,
4-15
displaying column values in titles,
4-29
DUPLICATES clause,
8-22
inserting space after every row,
4-13
inserting space when break column changes,
4-13
listing current break definition,
4-15
,
8-22
ON column clause,
4-12
,
8-19
ON expr clause,
8-20
ON REPORT clause,
4-19
,
8-21
ON ROW clause,
4-13
,
8-21
printing "grand" and "sub" summaries,
4-20
printing summary lines at ends of reports,
4-19
removing definition,
8-28
SKIP clause,
4-13
,
8-21
SKIP PAGE clause,
4-13
,
4-14
,
8-22
specifying multiple break columns,
4-14
,
8-19
storing current date in variable for titles,
4-30
suppressing duplicate values,
4-12
used in conjunction with COMPUTE,
4-15
,
8-19
,
8-21
,
8-43
used in conjunction with SET COLSEP,
8-103
used to format a REFCURSOR variable,
8-147
break definition
listing current,
4-15
,
8-22
removing current,
4-15
,
8-28
break group,
GL-3
break hierarchy,
GL-3
break order,
GL-3
break report,
GL-3
BREAKS clause,
4-15
,
8-28
browser, web,
4-38
BTITLE clause,
8-124
BTITLE command,
4-22
,
8-24
,
GL-24
aligning title elements,
8-141
BOLD clause,
8-141
CENTER clause,
8-141
COL clause,
8-141
FORMAT clause,
8-142
indenting titles,
8-141
LEFT clause,
8-141
OFF clause,
8-141
old form,
F-3
printing blank lines before bottom title,
4-25
referencing column value variable,
8-36
RIGHT clause,
8-141
SKIP clause,
8-141
suppressing current definition,
8-141
TAB clause,
8-141
TTITLE command,
8-24
buffer,
2-9
,
GL-4
,
GL-21
appending text to a line in,
3-6
,
8-12
delete a single line,
3-2
delete the current line,
3-2
delete the last line,
3-2
deleting a range of lines,
3-2
,
8-54
deleting a single line,
8-54
deleting all lines,
3-2
,
8-28
,
8-54
deleting lines from,
3-7
,
8-54
deleting the current line,
8-54
deleting the last line,
8-54
executing contents,
2-10
,
8-9
,
8-95
inserting new line in,
3-5
,
8-73
listing a range of lines,
3-3
,
8-75
listing a single line,
3-2
,
8-75
listing all lines,
3-2
,
8-75
listing contents,
3-3
,
8-75
listing the current line,
3-2
,
8-75
listing the last line,
3-3
,
8-75
loading into host system editor,
3-8
,
8-64
saving contents,
3-8
,
8-96
BUFFER clause,
3-2
,
3-10
,
8-28
BUFFER variable,
F-4
byte,
GL-4
C
CANCEL clause,
8-84
CENTER clause,
4-25
,
8-92
,
8-141
CGI scripts,
4-42
,
GL-6
CHANGE command,
3-2
,
3-3
,
8-25
CHAR clause,
8-10
VARIABLE command,
8-145
CHAR columns
changing format,
4-6
,
8-32
default format,
4-6
,
8-32
CHAR datatype,
GL-4
character,
GL-4
character string,
GL-4
clause,
GL-4
CLEAR clause,
4-9
,
8-31
in ATTRIBUTE command,
8-18
CLEAR command,
8-28
BREAKS clause,
4-15
,
8-28
BUFFER clause,
3-2
,
3-10
,
8-28
COLUMNS clause,
4-9
,
8-28
COMPUTES clause,
8-28
SCREEN clause,
3-31
,
8-28
SQL clause,
8-29
TIMING clause,
8-29
client,
GL-4
CLOB clause
VARIABLE command,
8-146
CLOB columns
changing format,
4-6
,
8-32
default format,
8-32
setting maximum width,
8-107
setting retrieval position,
8-107
setting retrieval size,
8-107
CLOB datatype,
GL-4
CLOSECURSOR variable,
F-2
,
F-5
CMDSEP variable,
8-102
COL clause,
4-26
,
8-92
,
8-141
colons (:)
bind variables,
3-31
COLSEP variable,
8-102
column,
GL-5
format,
GL-24
width,
GL-25
COLUMN command,
4-2
,
8-30
ALIAS clause,
8-31
and BREAK command,
8-21
and DEFINE command,
8-52
CLEAR clause,
4-9
,
8-31
DEFAULT clause,
F-3
displaying column values in bottom titles,
4-30
,
8-36
displaying column values in top titles,
4-29
,
8-35
entering multiple,
8-37
ENTMAP clause,
8-31
FOLD_AFTER clause,
8-31
,
8-32
FOLD_BEFORE clause,
8-32
FORMAT clause,
4-5
,
4-6
,
8-32
formatting columns,
4-6
formatting NUMBER columns,
4-4
,
8-33
HEADING clause,
4-2
,
8-35
HEADSEP character,
8-35
JUSTIFY clause,
8-35
LIKE clause,
4-8
,
8-35
listing column display attributes,
4-8
,
4-9
,
8-30
NEW_VALUE clause,
4-29
,
4-30
,
8-35
NEWLINE clause,
8-35
NOPRINT clause,
4-29
,
8-36
NULL clause,
8-36
OFF clause,
4-9
,
8-37
OLD_VALUE clause,
4-30
,
8-36
ON clause,
4-9
,
8-37
PRINT clause,
8-36
resetting a column to default display,
4-9
,
8-31
,
F-2
restoring column display attributes,
4-9
,
8-37
storing current date in variable for titles,
4-30
,
8-38
suppressing column display attributes,
4-9
,
8-37
TRUNCATED clause,
4-7
,
8-37
used to format a REFCURSOR variable,
8-147
WORD_WRAPPED clause,
4-7
,
4-10
,
8-37
WRAPPED clause,
4-7
,
8-37
column expression,
GL-5
column headings
aligning,
8-35
changing,
4-2
,
8-35
changing character used to underline,
4-3
,
8-112
changing to two or more words,
4-3
,
8-35
displaying on more than one line,
4-3
,
8-35
suppressing printing in a report,
8-105
when truncated,
8-32
when truncated for CHAR and LONG columns,
4-7
when truncated for DATE columns,
4-7
when truncated for NUMBER columns,
4-4
column separator,
8-102
,
F-2
columns
assigning aliases,
8-31
computing summary lines,
4-16
,
8-41
copying display attributes,
4-8
,
8-18
,
8-35
copying values between tables,
6-4
,
6-9
,
8-49
displaying values in bottom titles,
4-30
,
8-36
displaying values in top titles,
4-29
,
8-35
formatting CHAR, VARCHAR, LONG, and DATE,
8-32
formatting in reports,
4-2
,
8-30
formatting MLSLABEL, RAW MLSLABEL, ROWLABEL,
8-32
formatting NUMBER,
4-4
,
8-33
listing display attributes for all,
4-9
,
8-30
listing display attributes for one,
4-8
,
8-30
names in destination table when copying,
6-5
,
8-50
printing line after values that overflow,
4-9
,
8-108
resetting a column to default display,
4-9
,
8-31
,
F-2
resetting all columns to default display,
4-9
,
8-28
restoring display attributes,
4-9
,
8-18
,
8-37
setting printing to off or on,
4-29
,
8-36
starting new lines,
8-35
storing values in variables,
4-29
,
8-35
suppressing display attributes,
4-9
,
8-18
,
8-37
truncating display for all when value overflows,
4-7
,
8-112
truncating display for one when value overflows,
4-7
,
8-37
wrapping display for all when value overflows,
4-7
,
8-112
wrapping display for one when value overflows,
4-7
,
8-37
wrapping whole words for one,
4-10
COLUMNS clause,
4-9
,
8-28
comma, number format,
4-5
command,
GL-5
command file extension,
8-96
,
8-111
,
8-137
command files,
3-8
aborting and exiting with a return code,
3-18
,
8-152
,
8-154
allowing end-user input,
3-21
creating with a system editor,
3-11
creating with INPUT and SAVE,
3-9
creating with SAVE,
3-8
,
8-96
editing with GET and SAVE,
3-18
editing with host system editor,
3-18
,
8-64
in @ ("at" sign) command,
3-16
,
8-5
in @@ (double "at" sign) command,
8-7
in EDIT command,
3-18
,
8-64
in GET command,
3-15
,
8-69
in SAVE command,
3-8
,
3-10
,
8-96
in SQLPLUS command,
3-17
,
7-10
in START command,
3-16
,
8-131
including comments in,
3-11
,
8-88
including more than one PL/SQL block,
3-11
including more than one SQL command,
3-10
,
3-11
listing names with HOST command,
3-9
nesting,
3-17
passing parameters to,
3-27
,
8-5
,
8-131
registering,
8-99
retrieving,
3-15
,
8-69
running,
3-16
,
8-5
,
8-131
running a series in sequence,
3-17
running as you start SQL*Plus,
3-17
,
7-10
running in batch mode,
3-18
,
8-68
running nested,
8-7
saving contents of buffer in,
3-8
,
8-96
command prompt,
GL-5
host operating system,
2-3
SQL*Plus,
2-4
commands,
1-2
collecting timing statistics on,
2-15
,
8-138
disabling,
E-4
host, running from SQL*Plus,
2-16
,
8-71
listing current in buffer,
8-75
re-enabling,
E-5
spaces,
2-5
SQL
continuing on additional lines,
2-7
editing in buffer,
3-2
editing with host system editor,
3-7
,
8-64
ending,
2-7
entering and executing,
2-6
entering without executing,
2-8
executing current,
2-10
,
8-9
,
8-95
following syntax,
2-7
list of major,
D-1
listing current in buffer,
3-3
saving current,
3-8
,
8-96
setting character used to end and run,
8-110
SQL*Plus
abbreviations,
2-11
command summary,
8-2
continuing on additional lines,
2-12
,
8-1
editing at command prompt,
3-2
ending,
2-13
,
8-1
entering and executing,
2-11
entering during SQL command entry,
8-110
obsolete command alternatives,
F-2
stopping while running,
2-15
storing in command files,
3-8
syntax conventions,
1-3
tabs,
2-5
types of,
2-5
variables that affect running,
2-13
writing interactive,
3-21
comments,
GL-5
,
GL-18
including in command files,
3-11
,
8-88
,
F-2
using -- to create,
3-12
using /*...*/ to create,
3-12
using REMARK to create,
3-12
,
8-88
,
F-2
commit,
GL-6
COMMIT clause,
8-67
WHENEVER OSERROR,
8-151
WHENEVER SQLERROR,
8-153
COMMIT command,
2-13
Common Gateway Interface,
GL-6
communications,
GL-14
COMPATIBILITY clause
in LOGIN.SQL,
3-19
COMPATIBILITY variable,
8-103
computation,
GL-6
COMPUTE command,
4-11
,
8-41
AVG function,
4-16
computing a summary on different columns,
4-20
COUNT function,
4-16
LABEL clause,
4-17
,
4-19
,
8-42
listing all definitions,
4-22
,
8-43
MAXIMUM function,
4-16
maximum LABEL length,
8-42
MINIMUM function,
4-16
NUMBER function,
4-16
OF clause,
4-16
ON column clause,
4-16
,
8-42
ON expr clause,
8-42
ON REPORT clause,
4-19
,
8-42
ON ROW clause,
8-42
printing "grand" and "sub" summaries,
4-20
printing multiple summaries on same column,
4-21
printing summary lines at ends of reports,
4-19
printing summary lines on a break,
4-16
referencing a SELECT expression in OF,
8-42
referencing a SELECT expression in ON,
8-43
removing definitions,
4-22
,
8-28
STD function,
4-16
SUM function,
4-16
used to format a REFCURSOR variable,
8-147
VARIANCE function,
4-16
computed column,
GL-6
COMPUTES clause,
8-28
CONCAT variable,
3-26
,
8-103
concurrency
instances, multiple,
8-134
configuration,
GL-6
configuration files,
GL-6
connect,
GL-6
CONNECT command,
6-2
,
6-3
,
8-47
and @ ("at" sign),
6-3
,
8-47
changing password,
8-47
,
8-48
,
8-77
connect identifier,
6-3
INTERNAL,
8-47
service name,
6-3
SYSDBA clause,
7-9
,
8-48
SYSOPER clause,
7-9
,
8-48
username/password,
6-2
,
6-3
,
6-4
,
8-47
CONNECT command (SQL)
disabling,
E-5
connect identifier,
6-3
,
8-47
,
GL-6
in CONNECT command,
8-47
in COPY command,
8-49
in DESCRIBE command,
8-56
in SQLPLUS command,
7-9
CONTINUE clause
WHENEVER OSERROR,
8-151
WHENEVER SQLERROR,
8-153
continuing a long SQL*Plus command,
2-12
,
8-1
conventions, command syntax,
1-3
COPY command,
6-4
,
8-49
and @ ("at" sign),
6-5
,
8-49
and ARRAYSIZE variable,
6-8
,
8-51
and COPYCOMMIT variable,
6-8
,
8-51
and LONG variable,
6-8
,
8-51
APPEND clause,
6-7
,
8-50
copying data between databases,
6-4
copying data between tables on one database,
6-9
CREATE clause,
6-6
,
8-50
creating a table,
6-6
,
8-50
destination table,
6-5
,
8-50
determining actions,
6-5
determining source rows and columns,
6-6
,
8-51
disabling,
E-5
FROM clause,
6-5
,
8-49
INSERT clause,
6-7
,
8-50
inserting data in a table,
6-7
,
8-50
interpreting messages,
6-8
mandatory connect identifier,
8-50
naming the source table with SELECT,
6-6
,
8-51
query,
6-6
,
8-51
referring to another user's table,
6-8
REPLACE clause,
6-6
,
8-50
replacing data in a table,
6-6
,
8-50
sample command,
6-5
,
6-6
service name,
6-5
,
6-7
,
6-9
specifying column names for destination,
6-5
,
8-50
specifying the data to copy,
6-6
,
8-51
TO clause,
6-5
,
8-49
username/password,
6-5
,
6-7
,
6-9
,
8-49
USING clause,
6-6
,
8-51
when a commit is performed,
8-51
COPYCOMMIT variable,
8-103
relationship to COPY command,
6-8
,
8-51
COPYTYPECHECK variable,
8-103
COUNT function,
4-16
CREATE clause
in COPY command,
6-6
,
8-50
CREATE command
disabling,
E-6
entering PL/SQL,
2-8
creating flat files,
4-34
creating the PRODUCT_USER_PROFILE table,
E-2
current line,
GL-7
cursor variables,
8-146
D
Data Control Language,
GL-8
Data Definition Language,
GL-8
data dictionary,
GL-8
Data Manipulation Language,
GL-8
data security,
GL-8
database,
GL-7
connect identifier,
8-47
dismounted,
GL-9
failure,
GL-7
link,
GL-7
local,
GL-12
mounting,
8-134
object,
GL-7
open,
GL-15
opening,
8-134
schema,
GL-19
server,
GL-7
specification,
GL-8
string,
GL-8
transaction,
GL-24
USERID,
GL-24
username,
GL-24
database administrator,
1-6
,
5-2
,
GL-7
database changes, saving automatically,
2-13
,
8-100
DATABASE clause,
8-83
database files
recovering,
8-82
database name at startup,
8-133
databases
and RECOVERY command,
8-82
connecting to default,
6-2
,
8-47
connecting to remote,
6-3
,
8-47
copying data between,
6-4
,
8-49
copying data between tables on a single,
6-9
disconnecting without leaving SQL*Plus,
6-2
,
8-63
mounting,
5-3
opening,
5-3
recovering,
5-5
,
8-82
shutting down,
5-2
,
5-3
starting,
5-2
DATAFILE clause,
8-84
datatype,
GL-9
LONG,
GL-13
NCHAR,
GL-14
NCLOB,
GL-14
NUMBER,
GL-14
NVARCHAR2,
GL-15
RAW,
GL-18
VARCHAR,
GL-24
VARCHAR2,
GL-25
DATE
datatype,
GL-9
date
Julian,
GL-12
DATE clause,
8-10
DATE columns
changing format,
4-6
,
8-33
,
8-39
default format,
4-6
date, storing current in variable for titles,
4-30
,
8-35
,
8-38
DB2,
8-103
DBA,
5-2
,
GL-7
DBA mode,
8-133
DBA privilege,
8-133
DBMS_APPLICATION_INFO package,
8-99
DCL,
GL-8
DDL,
GL-8
DECLARE command
disabling,
E-6
DECLARE command (PL/SQL),
2-10
default,
GL-9
database,
GL-9
DEFAULT clause,
8-11
DEFINE command,
3-21
,
8-52
,
GL-24
and host system editor,
3-8
,
8-53
CHAR values,
8-52
substitution variables,
3-24
,
8-52
DEFINE variable,
3-26
,
8-103
DEL command,
3-2
,
3-7
,
8-54
using an asterisk,
3-2
,
8-54
DELETE command
disabling,
E-6
DEMOBLD,
1-7
DEMODROP,
1-7
DEPT table,
1-5
DESCRIBE command (SQL*Plus),
2-16
,
8-56
connect_identifier,
8-56
PL/SQL properties listed by,
8-57
table properties listed by,
8-56
directory,
GL-9
DISABLED keyword, disabling commands,
E-4
disabling
PL/SQL commands,
E-6
SQL commands,
E-4
SQL*Plus commands,
E-4
DISCONNECT command,
6-2
,
8-63
dismounted database,
GL-9
display
format,
GL-9
width,
GL-10
DML,
GL-8
DOCUMENT command
Obsolete commands
DOCUMENT,
F-2
obsolete commands
DOCUMENT,
F-3
REMARK as newer version of,
F-4
DOCUMENT variable,
F-2
,
F-5
DROP command
disabling,
E-6
DUAL table,
GL-10
DUPLICATES clause,
8-22
E
ECHO variable,
3-16
,
8-104
EDIT command,
3-7
,
8-64
creating command files with,
3-11
defining _EDITOR,
3-8
,
8-64
disabling,
E-5
modifying command files,
3-18
,
8-64
setting default file name,
8-104
EDITFILE variable,
8-104
editor,
GL-10
EMBEDDED variable,
8-104
EMP table,
1-5
empty line, displaying,
8-78
end user,
GL-10
enhancement list,release 8.1,
B-2
entities, HTML,
4-47
ENTMAP,
7-5
ENTMAP clause,
4-47
,
7-5
,
8-31
error message,
GL-10
error messages, interpreting,
2-18
errors, making line containing current,
3-4
escape characters, definition of,
8-104
ESCAPE variable,
3-26
,
8-104
example
embedded CGI report,
4-42
interactive HTML report,
4-39
,
4-41
EXCLUSIVE clause,
8-133
EXECUTE command,
8-66
disabling,
E-5
executing
a CREATE command,
2-8
execution statistics
including in report,
8-101
EXIT clause
WHENEVER OSERROR,
8-151
WHENEVER SQLERROR,
8-153
EXIT command,
2-4
,
8-67
:BindVariable clause,
8-67
COMMIT clause,
8-67
disabling,
E-5
FAILURE clause,
8-67
in a command file,
8-132
ROLLBACK clause,
8-68
use with SET MARKUP,
4-39
WARNING clause,
8-67
exit, conditional,
8-151
,
8-153
expression,
GL-10
extension,
8-96
,
8-111
,
8-137
,
GL-10
F
FAILURE clause,
8-67
FEEDBACK variable,
8-105
file,
GL-10
file extension,
8-96
,
8-111
,
8-137
file extensions,
3-20
file names
in @ ("at" sign) command,
8-5
in @@ (double "at" sign) command,
8-7
in EDIT command,
8-64
in GET command,
8-69
in SAVE command,
3-8
,
8-96
in SPOOL command,
4-34
,
8-130
in SQLPLUS command,
7-10
in START command,
8-131
file type,
GL-11
filename,
GL-11
files
command files,
3-8
flat,
4-34
FLAGGER variable,
8-105
flat file,
4-34
FLUSH variable,
8-105
FOLD_AFTER clause,
8-32
FOLD_BEFORE clause,
8-32
footers
aligning elements,
8-92
displaying at bottom of page,
8-89
displaying system-maintained values,
8-91
formatting elements,
8-92
indenting,
8-92
listing current definition,
8-89
setting at the end of reports,
4-22
suppressing definition,
8-92
FORCE clause,
8-133
form feed,
GL-11
format,
GL-11
column,
GL-24
mask,
GL-11
model,
GL-11
FORMAT clause,
8-10
,
8-32
in ATTRIBUTE command,
8-18
in COLUMN command,
4-5
,
4-6
in REPHEADER and REPFOOTER commands,
8-92
in TTITLE and BTITLE commands,
4-27
,
8-142
format models, number,
4-5
,
8-34
formfeed, to begin a new page,
4-31
,
8-107
formula column,
GL-11
FROM clause,
8-83
FROM clause (SQL*Plus),
6-5
,
8-49
function,
GL-11
G
GET command,
3-15
,
8-69
disabling,
E-5
LIST clause,
8-69
modifying command files,
3-18
NOLIST clause,
8-69
retrieving command files,
3-15
,
8-69
GLOGIN.SQL,
3-19
,
3-38
,
3-41
,
7-10
See also
GRANT command,
E-2
disabling,
E-6
H
HEAD clause,
7-4
HEAD option,
7-4
headers
aligning elements,
4-24
displaying at top of page,
8-91
displaying system-maintained values,
8-91
setting at the start of reports,
4-22
suppressing,
4-24
heading,
GL-11
HEADING clause,
4-2
,
8-35
HEADING variable,
8-105
headings
aligning elements,
8-92
column headings,
8-105
formatting elements,
8-92
indenting,
8-92
listing current definition,
8-93
suppressing definition,
8-92
HEADSEP variable,
8-106
use in COLUMN command,
4-3
,
8-35
HELP command,
8-70
help, online,
2-5
,
7-12
,
8-70
HIDE clause,
8-11
HOST command,
2-16
,
8-71
disabling,
E-5
listing command file names with,
3-9
host computer,
GL-11
host operating system
command prompt,
2-3
editor,
3-7
,
8-64
file, loading into buffer,
8-69
running commands from SQL*Plus,
2-16
,
8-71
HTML,
4-38
,
4-42
,
GL-12
clause,
7-4
entities,
4-47
option,
7-4
spooling to file,
7-6
tag,
4-38
hyphen
continuing a long SQL*Plus command,
2-12
,
8-1
I
IMMEDIATE mode,
8-128
infinity sign (~),
8-35
initialization parameters
displaying,
8-124
INIT.ORA file
parameter file,
8-133
input
accepting [Return],
3-31
,
8-78
accepting values from the user,
3-28
,
8-10
INPUT command,
3-2
,
3-5
,
8-73
entering several lines,
8-73
using with SAVE to create command files,
3-9
INSERT clause,
6-7
,
8-50
INSERT command
disabling,
E-6
instance,
GL-12
failure,
GL-7
recovery,
GL-12
INSTANCE variable,
8-106
instances
multiple, sharing a database,
8-134
shutting down,
8-128
starting,
8-133
INTERNAL
See
J
Julian date,
GL-12
justification,
GL-12
JUSTIFY clause,
8-35
K
keyboard, significance of keys on,
2-2
keys
[Backspace] key,
2-2
[Cancel] key,
2-2
[Interrupt] key,
2-2
[Pause] key,
2-2
[Resume] key,
2-2
[Return] key,
2-2
L
label,
GL-12
LABEL variable
SHOW command,
F-2
,
F-7
labels
in COMPUTE command,
4-17
,
8-42
layout object
width,
GL-25
LEFT clause,
4-25
,
8-92
,
8-141
LGWR,
GL-13
LIKE clause,
4-8
,
8-18
,
8-35
limits, SQL*Plus,
C-1
line numbers, for SQL commands,
2-6
line wrapping,
GL-25
lines
adding at beginning of buffer,
8-73
adding at end of buffer,
8-73
adding new after current,
3-5
,
8-73
appending text to,
3-6
,
8-12
changing width,
4-32
,
8-106
deleting all in buffer,
8-54
deleting from buffer,
3-7
,
8-54
determining which is current,
3-3
editing current,
3-3
listing all in buffer,
3-2
,
8-75
removing blanks at end,
8-111
LINESIZE variable,
4-24
,
4-32
,
8-106
LIST clause,
8-13
,
8-69
LIST command,
3-2
,
8-75
determining current line,
3-3
,
8-75
making last line current,
3-4
,
8-75
using an asterisk,
3-2
,
8-75
LNO clause,
8-124
LOBOFFSET variable,
8-107
local database,
GL-12
LOCK TABLE command
disabling,
E-6
log in,
GL-13
log off,
GL-13
log on,
GL-13
log out,
GL-13
Log Writer,
GL-13
LOG_ARCHIVE_DEST parameter,
8-13
LOGFILE clause,
8-84
logging off
conditionally,
8-151
,
8-153
Oracle,
6-2
,
8-63
SQL*Plus,
2-4
,
8-67
logging on
Oracle,
6-2
,
6-3
,
8-47
SQL*Plus,
2-4
LOGIN.SQL,
3-19
,
7-10
including SET commands,
3-19
sample commands to include,
3-19
See also
storing current date in variable for titles,
4-30
logon string,
GL-13
LONG columns
changing format,
4-6
,
8-32
default format,
8-32
setting maximum width,
8-107
setting retrieval size,
8-107
LONG datatype,
GL-13
LONG variable,
8-107
effect on COPY command,
6-8
,
8-51
LONGCHUNKSIZE variable,
4-7
,
8-32
,
8-107
M
-MARKUP,
4-38
,
4-42
,
7-3
SPOOL clause,
7-4
SQLPLUS command clause,
7-4
MARKUP,
4-38
,
7-3
,
8-107
,
GL-13
BODY clause,
7-4
ENTMAP clause,
7-5
example,
8-117
HEAD clause,
7-4
PREFORMAT clause,
7-7
SPOOL clause,
7-4
TABLE clause,
7-5
mask format,
GL-11
MAXDATA variable,
F-2
,
F-6
MAXIMUM function,
4-16
media recovery,
8-134
message, sending to screen,
3-28
,
8-80
MINIMUM function,
4-16
model format,
GL-11
MOUNT clause,
8-134
mounted,
GL-13
mounting
shared databases,
8-134
mounting a database,
8-134
multi-threaded server,
GL-14
N
NCHAR clause
VARIABLE command,
8-145
NCHAR columns
changing format,
4-6
,
8-32
default format,
4-6
,
8-32
NCHAR datatype,
GL-14
NCLOB clause
VARIABLE command,
8-146
NCLOB columns
changing format,
4-6
,
8-32
default format,
8-32
setting maximum width,
8-107
setting retrieval position,
8-107
setting retrieval size,
8-107
NCLOB datatype,
GL-14
negative infinity sign (-~),
8-35
Net8,
GL-14
,
GL-21
connect identifier,
8-47
protocol,
6-3
network,
GL-14
NEW_VALUE clause,
4-29
,
8-35
storing current date in variable for titles,
4-30
,
8-35
,
8-38
NEWLINE clause,
8-35
NEWPAGE command,
F-2
,
F-4
NEWPAGE variable,
4-31
,
8-107
NEXT clause,
8-14
NLS_DATE_FORMAT,
8-10
,
8-39
NOAUDIT command
disabling,
E-6
NOLIST clause,
8-69
NOLOG,
7-10
/NOLOG option,
7-10
NOMOUNT clause,
8-134
NONE clause
WHENEVER OSERROR,
8-151
WHENEVER SQLERROR,
8-153
NOPARALLEL clause,
8-86
NOPRINT clause,
4-17
,
4-29
,
8-36
NOPROMPT clause,
8-11
NORMAL mode,
8-128
NULL clause,
8-36
NULL value,
GL-14
null values
setting text displayed,
8-36
,
8-107
NULL variable,
8-107
NUMBER clause,
3-30
,
8-10
VARIABLE command,
8-145
NUMBER columns
changing format,
4-4
,
8-33
default format,
4-4
,
8-34
NUMBER datatype,
GL-14
number formats
$,
4-5
0,
4-5
9,
4-5
comma,
4-5
setting default,
8-108
NUMBER function,
4-16
NUMFORMAT clause
in LOGIN.SQL,
3-19
NUMFORMAT variable,
8-108
NUMWIDTH variable,
8-108
effect on NUMBER column format,
4-4
,
8-34
NVARCHAR2 columns
changing format,
4-6
,
8-32
default format,
4-6
,
8-32
NVARCHAR2 datatype,
GL-15
O
object,
GL-15
object type,
GL-15
object-relational model,
GL-15
objects
describing,
8-104
obsolete commands
BTITLE,
F-3
COLUMN command DEFAULT clause,
F-3
NEWPAGE,
F-2
,
F-4
SET command BUFFER variable,
F-4
SET command CLOSECURSOR variable,
F-2
,
F-5
SET command DOCUMENT variable,
F-2
,
F-5
SET command MAXDATA variable,
F-2
,
F-6
SET command SCAN variable,
F-2
,
F-6
SET command SPACE variable,
F-2
,
F-6
SET command TRUNCATE variable,
F-2
,
F-7
SHOW command LABEL variable,
F-2
,
F-7
TTITLE command old form,
F-7
OF clause,
4-16
OFF clause,
8-37
in ATTRIBUTE command,
8-18
in COLUMN command,
4-9
,
8-37
in REPFOOTER commands,
8-92
in REPHEADER commands,
8-92
in SPOOL command,
4-34
,
8-130
in TTITLE and BTITLE commands,
4-28
,
8-141
OLD_VALUE clause,
4-30
,
8-36
ON clause
in ATTRIBUTE command,
8-18
in COLUMN command,
4-9
,
8-37
in TTITLE and BTITLE commands,
4-28
ON column clause
in BREAK command,
4-12
,
8-19
in COMPUTE command,
4-16
,
8-42
ON expr clause
in BREAK command,
8-20
in COMPUTE command,
8-42
ON REPORT clause
in BREAK command,
4-19
,
8-21
in COMPUTE command,
4-19
,
8-42
ON ROW clause
in BREAK command,
4-13
,
8-21
in COMPUTE command,
8-42
online help,
2-5
,
7-12
,
8-70
online redo log,
GL-15
OPEN clause,
8-134
open database,
GL-15
opening a database,
8-134
operating system,
GL-15
Oracle
USERID,
GL-24
Oracle Server,
GL-16
ORDER BY clause
displaying column values in titles,
4-29
displaying values together in output,
4-11
OUT clause,
4-35
,
8-130
output,
GL-16
formatting white space in,
8-111
pausing during display,
2-17
,
8-108
query results,
1-2
output file,
GL-16
P
packages,
GL-16
page,
GL-16
PAGE clause,
8-91
page number, including in titles,
4-14
,
4-27
pages
changing length,
4-31
,
8-108
default dimensions,
4-31
matching dimensions to screen or paper size,
4-31
setting dimensions,
4-31
PAGESIZE variable,
2-7
,
4-32
,
8-108
PAGESIZEclause
in LOGIN.SQL,
3-19
PARALLEL clause,
8-134
parallel server,
GL-16
parameter,
GL-16
width,
GL-25
parameter file,
GL-16
parameter files (INIT.ORA files)
specifying alternate,
8-133
parameters,
3-27
,
8-5
,
8-131
PARAMETERS clause,
8-124
password,
1-6
,
GL-17
changing with the PASSWORD command,
8-77
in CONNECT command,
6-2
,
6-3
,
8-47
in COPY command,
6-5
,
6-7
,
6-9
in SQLPLUS command,
2-3
,
6-4
,
7-9
PASSWORD command,
8-47
,
8-77
disabling,
E-5
paths, creating
Installation and User's Guide,
8-51
PAUSE command,
3-31
,
8-78
in LOGIN.SQL,
3-19
PAUSE variable,
2-17
,
8-108
performance
of SQL statements,
3-36
performance, over dial-up lines,
8-111
Period (.)
terminating PL/SQL blocks,
8-102
period (.)
terminating PL/SQL blocks,
2-10
PLAN_TABLE table,
3-37
PL/SQL,
1-2
,
2-10
,
GL-17
blocks, PL/SQL,
2-10
executing,
8-66
formatting output in SQL*Plus,
8-146
listing definitions,
2-17
mode in SQL*Plus,
2-8
within SQL commands,
2-8
PLUSTRACE role,
3-37
PNO clause,
8-125
pound sign (#),
8-35
PREFORMAT,
7-7
PREFORMAT clause,
7-7
print
spooling,
GL-20
PRINT clause,
8-36
PRINT command,
8-79
printing
bind variables automatically,
8-101
REFCURSOR variables,
8-147
SPOOL command,
8-130
procedure,
GL-17
process,
GL-17
PRODUCT_USER_PROFILE table,
E-2
prompt,
GL-17
PROMPT clause,
3-29
,
8-11
PROMPT command,
3-28
,
8-80
customizing prompts for value,
3-30
prompts for value
bypassing with parameters,
3-27
customizing,
3-30
through ACCEPT,
3-28
through substitution variables,
3-23
PUPBLD.SQL,
E-2
Q
queries,
1-2
displaying number of records retrieved,
2-7
,
8-105
in COPY command,
6-6
,
8-51
query,
GL-17
results,
GL-18
,
GL-19
query execution path
including in report,
8-101
query results,
1-2
displaying on-screen,
2-6
sending to a printer,
4-35
,
8-130
storing in a file,
4-34
,
8-130
QUIT command,
8-67
See also
R
RAW datatype,
GL-18
RDBMS,
GL-18
record,
GL-18
,
GL-19
record separators, printing,
4-9
,
8-108
RECOVER
clause,
8-134
recover,
GL-18
RECOVER command,
8-82
AUTOMATIC clause,
8-82
CANCEL clause,
8-84
CONTINUE clause,
8-84
DATABASE clause,
8-83
DATAFILE clause,
8-84
FROM clause,
8-83
LOGFILE clause,
8-84
NOPARALLEL clause,
8-86
STANDBY DATABASE clause,
8-83
STANDBY DATAFILE clause,
8-84
STANDBY TABLESPACE clause,
8-84
TABLESPACE clause,
8-84
UNTIL CANCEL clause,
8-83
UNTIL CHANGE clause,
8-83
UNTIL CONTROLFILE clause,
8-84
UNTIL TIME clause,
8-83
USING BACKUP CONTROL FILE clause,
8-84
recovery
RECOVER command,
8-82
RECOVERY command
and database recovery,
5-5
RECSEP variable,
4-9
,
8-108
RECSEPCHAR variable,
4-9
,
8-108
redo log,
GL-15
,
GL-18
file,
GL-18
redo Log Files
ARCHIVE LOG command,
8-13
REFCURSOR bind variables,
3-33
in a stored function,
3-33
REFCURSOR clause
VARIABLE command,
8-146
Relational Database Management System,
GL-18
RELEASE clause,
8-125
remark,
GL-18
REMARK command,
3-12
,
8-88
,
GL-18
remote computer,
GL-19
remote database,
GL-19
RENAME command
disabling,
E-6
REPFOOTER clause,
8-125
REPFOOTER command,
4-22
,
8-89
aligning footer elements,
8-92
BOLD clause,
8-92
CENTER clause,
8-92
COL clause,
8-92
FORMAT clause,
8-92
indenting report footers,
8-92
LEFT clause,
8-92
OFF clause,
8-92
RIGHT clause,
8-92
SKIP clause,
8-92
suppressing current definition,
8-92
TAB clause,
8-92
REPHEADER clause,
8-125
REPHEADER command,
4-22
,
8-91
aligning header elements,
4-24
aligning heading elements,
8-92
BOLD clause,
8-92
CENTER clause,
8-92
COL clause,
8-92
FORMAT clause,
8-92
indenting headings,
8-92
LEFT clause,
8-92
OFF clause,
8-92
PAGE clause,
8-91
RIGHT clause,
8-92
SKIP clause,
8-92
suppressing current definition,
8-92
TAB clause,
8-92
REPLACE clause
in COPY command,
6-6
,
8-50
in SAVE command,
3-18
,
8-96
report
breaks,
8-19
title,
F-2
reports,
1-2
,
GL-19
CGI scripts,
4-42
clarifying with spacing and summary lines,
4-11
columns,
8-31
creating bottom titles,
4-22
,
8-24
,
F-2
creating footers,
8-89
creating headers,
8-91
creating headers and footers,
4-22
creating master/detail,
4-29
,
8-36
creating top titles,
4-22
,
8-140
,
F-2
displaying,
8-101
embedded CGI example,
4-42
embedded using SQLPLUS -MARKUP,
4-42
formatting column headings,
4-2
,
8-30
formatting columns,
4-4
,
4-6
,
8-30
interactive HTML example,
4-39
,
4-41
interactive using SET MARKUP HTML,
4-38
line wrapping,
GL-25
on the web,
4-38
,
4-42
SILENT mode,
4-46
starting on a new page,
8-104
subtotal,
GL-22
summary,
GL-22
summary line,
GL-22
title,
8-140
,
GL-24
reserved word,
GL-19
RESTRICT,
7-8
,
8-133
,
E-8
RETRY clause,
8-134
return code, specifying,
3-18
,
8-68
,
8-154
REVOKE command,
E-2
disabling,
E-6
RIGHT clause,
4-25
,
8-92
,
8-141
roles,
E-7
,
GL-19
disabling,
E-7
re-enabling,
E-7
rollback,
GL-19
ROLLBACK clause,
8-68
WHENEVER OSERROR,
8-151
WHENEVER SQLERROR,
8-153
row,
GL-18
,
GL-19
rows
performing computations on,
4-15
,
8-41
setting number retrieved at one time,
8-100
setting the number after which COPY commits,
8-103
RUN command,
2-10
,
8-95
disabling,
E-5
executing current PL/SQL block,
2-10
executing current SQL command or PL/SQL block,
2-10
making last line current,
3-4
similar to / (slash) command,
2-10
,
8-95
S
sample tables,
1-4
access to,
1-7
DEMOBLD,
1-7
DEMODROP,
1-7
SAVE command,
3-8
,
8-96
APPEND clause,
3-18
,
8-96
CREATE clause,
8-96
disabling,
E-5
modifying command files,
3-18
REPLACE clause,
3-18
,
8-96
storing commands in command files,
3-8
,
8-96
using with INPUT to create command files,
3-10
saving environment attributes,
8-137
SCAN variable,
F-2
,
F-6
schema,
GL-19
SCREEN clause,
3-31
,
8-28
screen, clearing,
3-31
,
8-28
script,
GL-21
CGI,
4-42
,
GL-6
search paths
Installation and User's Guide,
8-51
Security
RESTRICT,
7-8
,
E-8
security
changing password,
8-77
embedded web reports,
4-43
PRODUCT_USER_PROFILE table,
E-2
security level,
GL-19
select,
GL-20
SELECT command
and BREAK command,
4-11
,
8-20
,
8-21
and COLUMN command,
8-31
and COMPUTE command,
4-11
and COPY command,
6-6
,
8-51
and DEFINE command,
8-52
and ORDER BY clause,
4-11
disabling,
E-6
storing current date in variable for titles,
4-30
SELECT list,
GL-20
SELECT statement,
GL-20
formatting results,
3-33
semicolon (;)
in PL/SQL blocks,
2-10
in SQL commands,
2-6
,
2-8
in SQL*Plus commands,
2-13
,
8-1
not needed when inputting a command file,
3-10
not stored in buffer,
3-3
Server,
GL-16
server,
GL-20
SERVEROUTPUT variable,
8-109
service Name
in COPY command,
6-9
service name
in CONNECT command,
6-3
in COPY command,
6-5
,
6-7
in SQLPLUS command,
6-4
session,
GL-20
SET AUTOTRACE,
3-36
SET clause,
8-137
SET command,
2-13
,
3-20
,
4-38
,
8-98
,
GL-23
APPINFO variable,
8-99
ARRAYSIZE variable,
6-8
,
8-100
AUTOCOMMIT variable,
2-14
,
8-100
AUTOPRINT variable,
8-101
,
8-146
AUTORECOVERY variable,
8-101
AUTOTRACE variable,
8-101
BLOCKTERMINATOR variable,
8-102
BUFFER variable,
F-4
CLOSECURSOR variable,
F-2
,
F-5
CMDSEP variable,
8-102
COLSEP variable,
4-34
,
8-102
COMPATIBILITY clause,
3-19
COMPATIBILITY variable,
8-103
CONCAT variable,
3-26
,
8-103
COPYCOMMIT variable,
6-8
,
8-103
COPYTYPECHECK variable,
8-103
DEFINE clause,
3-26
DEFINE variable,
8-103
DESCRIBE variable,
8-104
disabling,
E-5
DOCUMENT variable,
F-2
,
F-5
ECHO variable,
3-16
,
8-104
EDITFILE variable,
8-104
EMBEDDED variable,
8-104
ESCAPE variable,
3-26
,
8-104
FEEDBACK variable,
8-105
FLAGGER variable,
8-105
FLUSH variable,
8-105
HEADING variable,
8-105
HEADSEP variable,
4-3
,
8-106
INSTANCE variable,
8-106
LINESIZE variable,
4-24
,
4-32
,
8-106
LOBOFFSET variable,
8-107
LOGSOURCE variable,
8-107
LONG variable,
6-8
,
8-107
LONGCHUNKSIZE variable,
8-107
MARKUP clause,
8-107
MAXDATA variable,
F-2
,
F-6
NEWPAGE variable,
4-31
,
8-107
NULL variable,
8-107
NUMFORMAT clause,
3-19
NUMFORMAT variable,
8-108
NUMWIDTH variable,
4-4
,
8-34
,
8-108
PAGESIZE clause,
3-19
PAGESIZE variable,
2-7
,
4-32
,
8-108
PAUSE clause,
3-19
PAUSE variable,
2-17
,
8-108
RECSEP variable,
4-9
,
8-108
RECSEPCHAR variable,
4-9
,
8-108
SCAN variable,
F-2
,
F-6
SERVEROUTPUT variable,
8-109
SHIFTINOUT clause,
3-19
SHIFTINOUT variable,
8-109
SPACE variable,
F-2
,
F-6
SQLBLANKLINES variable,
8-110
SQLCASE variable,
8-110
SQLCONTINUE variable,
8-110
SQLNUMBER variable,
8-110
SQLPREFIX variable,
8-110
SQLPROMPT variable,
8-110
SQLTERMINATOR variable,
8-110
SUFFIX variable,
8-111
TAB variable,
8-111
TERMOUT variable,
4-30
,
8-111
TIME clause,
3-19
TIME variable,
8-111
TIMING variable,
8-111
TRIMOUT variable,
8-111
TRIMSPOOL variable,
8-112
TRUNCATE variable,
F-2
,
F-7
UNDERLINE variable,
4-3
,
8-112
used to format a REFCURSOR variable,
8-147
VERIFY clause,
3-23
VERIFY variable,
3-26
,
8-112
WRAP variable,
4-7
,
8-112
SET command variables
system variables,
2-13
SET MARKUP
BODY clause,
7-4
embedded CGI example,
4-42
ENTMAP clause,
4-47
,
7-5
HEAD clause,
7-4
HTML,
7-4
interactive HTML example,
4-39
,
4-41
PREFORMAT clause,
7-7
See also
SPOOL clause,
7-4
TABLE clause,
7-5
SET ROLE command
disabling,
E-6
SET TRANSACTION command
disabling,
E-6
SGA,
GL-23
SGA clause,
8-125
shared disk systems
mounting shared,
8-134
shared mode
database,
8-134
SHIFTINOUT clause
in LOGIN.SQL,
3-19
SHIFTINOUT variable,
8-109
SHOW clause,
8-138
SHOW command,
2-13
,
8-123
,
GL-23
ALL clause,
8-123
BTITLE clause,
8-124
ERRORS clause,
8-124
LABEL variable,
F-2
,
F-7
listing current page dimensions,
4-33
LNO clause,
8-124
PNO clause,
8-125
RELEASE clause,
8-125
REPFOOTER clause,
8-125
REPHEADER clause,
8-125
SPOOL clause,
8-125
SQLCODE clause,
8-125
TTITLE clause,
8-125
USER clause,
8-125
SHOWMODE variable,
8-109
SHUTDOWN command,
8-128
ABORT,
8-128
IMMEDIATE,
8-128
NORMAL,
8-128
-SILENT option,
4-46
,
7-8
site profile
GLOGIN.SQL,
7-10
LOGIN.SQL,
7-10
See also
SKIP clause
in BREAK command,
4-13
,
8-21
in REPHEADER and REPFOOTER commands,
8-92
in TTITLE and BTITLE commands,
4-25
,
8-141
used to place blank lines before bottom title,
4-25
SKIP PAGE clause,
4-13
,
4-14
,
8-22
slash (/) command,
8-9
using with files loaded with GET command,
8-69
SPACE variable,
F-2
,
F-6
SPOOL clause,
7-4
,
7-6
,
8-125
SPOOL command,
4-33
,
8-130
,
GL-20
disabling,
E-5
file name,
4-34
,
8-130
OFF clause,
4-34
,
8-130
OUT clause,
4-35
,
8-130
to HTML file,
7-6
turning spooling off,
4-34
,
8-130
use with SET MARKUP,
4-39
spooling,
GL-20
SQL,
GL-20
buffer,
GL-21
command,
GL-21
query,
GL-17
query results,
GL-18
reports,
GL-19
rollback,
GL-19
script,
GL-21
select,
GL-20
statement,
GL-21
transaction,
GL-24
SQL buffer,
2-9
SQL clause,
8-29
SQL commands, list of major,
D-1
SQL database language,
1-2
SQL DML statements
reporting on,
8-101
SQL*Loader,
GL-21
SQL*Net,
GL-14
,
GL-21
SQL*Plus,
GL-21
basic concepts,
1-2
command prompt,
2-4
command summary,
8-2
database administration,
5-2
exiting,
2-4
,
8-67
exiting conditionally,
8-151
,
8-153
limits,
C-1
LOGIN.SQL,
3-19
obsolete command alternatives,
F-2
overview,
1-2
running commands in batch mode,
3-18
,
8-68
setting up environment,
3-19
shortcuts to starting,
2-4
starting,
2-3
,
7-2
substitution variable,
GL-22
variable,
GL-25
what you need to run,
1-6
who can use,
1-3
SQLBLANKLINES variable,
8-110
SQLCASE variable,
8-110
SQLCODE clause,
8-125
SHOW command,
8-125
SQLCONTINUE variable,
8-110
SQLNUMBER variable,
8-110
SQLPLUS command,
2-3
,
4-42
,
7-2
- clause,
7-2
-? clause,
7-3
and @ ("at" sign),
3-17
,
6-4
,
7-2
and EXIT FAILURE,
7-11
BODY option,
7-4
connect identifier,
7-9
connecting to a remote database,
6-4
display syntax,
7-2
ENTMAP option,
7-5
HEAD option,
7-4
HTML option,
7-4
-MARKUP clause,
7-4
-MARKUP option,
7-3
-MARKUP SPOOL clause,
7-4
/NOLOG clause,
7-10
PREFORMAT option,
7-7
RESTRICT,
7-8
,
E-8
running command files,
3-17
service name,
6-4
,
7-9
-SILENT clause,
7-8
-SILENT option,
4-46
,
7-8
SPOOL clause,
7-6
syntax,
7-2
SYSDBA clause,
7-9
TABLE option,
7-5
unsuccessful connection,
7-10
username/password,
2-3
,
7-9
SQL.PNO, referencing in report titles,
4-27
SQLPREFIX variable,
8-110
SQLPROMPT variable,
8-110
SQL.SQLCODE
using in EXIT command,
8-67
SQLTERMINATOR,
8-110
SQLTERMINATOR variable,
8-71
,
8-110
STANDBY DATAFILE clause,
8-84
STANDBY TABLESPACE clause,
8-84
START clause,
8-14
,
8-138
START command,
3-16
,
8-131
,
GL-24
arguments,
3-27
,
8-131
command file,
3-16
,
8-131
disabling,
E-5
passing parameters to a command file,
3-27
,
8-131
similar to @ ("at" sign) command,
3-16
,
8-6
,
8-132
similar to @@ (double "at" sign) command,
8-7
,
8-132
starting SQL*Plus,
2-3
shortcuts,
2-4
STARTUP command,
8-133
EXCLUSIVE clause,
8-133
FORCE clause,
8-133
MOUNT clause,
8-134
NOMOUNT clause,
8-134
OPEN clause,
8-134
PARALLEL clause,
8-134
PFILE clause,
8-133
RECOVER clause,
8-134
RESTRICT clause,
8-133
RETRY clause,
8-134
SHARED clause,
8-134
specifying a database,
8-134
statement
SQL,
GL-21
statistics,
3-38
STD function,
4-16
STOP clause,
8-14
,
8-138
STORE command,
3-20
,
8-137
SET clause,
8-137
stored functions,
3-33
stored procedures
creating,
2-8
string,
GL-21
Structured Query Language,
GL-20
substitution variables,
3-22
,
GL-22
,
GL-25
appending characters immediately after,
3-24
avoiding unnecessary prompts for value,
3-24
concatenation character,
8-103
DEFINE command,
3-24
,
8-52
prefixing,
8-103
,
F-2
restrictions,
3-26
single and double ampersands,
3-24
system variables used with,
3-26
undefined,
3-23
where and how to use,
3-22
subtotal,
GL-22
SUFFIX variable,
8-111
used with @ ("at" sign) command,
8-5
used with EDIT command,
8-64
used with GET command,
8-69
used with SAVE command,
8-96
used with START command,
8-131
SUM function,
4-16
summary,
GL-22
summary lines,
GL-22
computing and printing,
4-15
,
8-41
computing and printing at ends of reports,
4-19
computing same type on different columns,
4-20
printing "grand" and "sub" summaries (totals),
4-20
printing multiple on same break column,
4-21
syntax,
GL-22
conventions,
1-3
COPY command,
6-5
syntax rules
SQL commands,
2-7
SQL*Plus commands,
2-12
SYSDATE,
4-31
SYSDBA,
GL-22
SYSDBA clause,
8-48
SYSOPER,
GL-22
SYSOPER clause,
7-9
,
8-48
system administrator,
GL-22
system editor,
GL-22
System Global Area,
GL-23
SYSTEM username,
GL-23
system variables,
2-13
,
8-112
,
GL-23
changing current settings,
8-98
listing current settings,
2-13
,
8-123
listing old and new values,
8-109
storing and restoring,
3-20
used with substitution variables,
3-26
system-maintained values
displaying in headers and footers,
8-91
displaying in titles,
4-27
,
8-140
formatting in titles,
4-28
T
TAB clause,
8-92
,
8-141
TAB variable,
8-111
TABLE clause,
7-5
TABLE option,
7-5
tables,
1-2
,
GL-23
access to sample,
1-7
alias,
GL-23
controlling destination when copying,
6-6
,
8-50
copying values between,
6-4
,
6-9
,
8-49
DEPT,
1-5
EMP,
1-4
listing column definitions,
2-16
,
8-56
referring to another user's when copying,
6-8
sample,
1-4
TABLESPACE clause,
8-84
tablespaces
recovering,
8-82
tag, HTML,
4-38
TERMOUT variable,
8-111
storing current date in variable for titles,
4-30
using with SPOOL command,
8-130
text,
7-4
,
7-5
adding to current line with APPEND,
3-6
,
8-12
changing old to new with CHANGE,
3-3
,
8-25
clearing from buffer,
3-2
,
8-28
text editor,
GL-23
text editor, host operating system,
3-7
,
8-64
TIME clause
in LOGIN.SQL,
3-19
TIME variable,
8-111
timer,
GL-24
TIMING clause,
8-29
TIMING command,
2-15
,
8-138
deleting all areas created by,
8-29
deleting current area,
8-138
SHOW clause,
8-138
START clause,
8-138
STOP clause,
8-138
TIMING variable,
8-111
titles,
GL-24
aligning elements,
4-24
,
8-141
displaying at bottom of page,
4-22
,
8-24
,
F-2
displaying at top of page,
4-22
,
8-140
,
F-2
displaying column values,
4-29
,
8-35
,
8-36
displaying current date,
4-30
,
8-35
,
8-38
displaying page number,
4-27
,
8-143
displaying system-maintained values,
4-27
,
8-140
formatting elements,
8-142
formatting system-maintained values in,
4-28
indenting,
4-26
,
8-141
listing current definition,
4-28
,
8-24
,
8-142
restoring definition,
4-28
setting at start or end of report,
4-22
setting lines from top of page to top title,
4-31
,
8-107
,
F-2
setting lines from top title to end of page,
8-108
setting top and bottom,
4-22
,
8-24
,
8-140
,
F-2
spacing between last row and bottom title,
4-25
suppressing definition,
4-28
,
8-141
TO clause,
6-5
,
8-49
tracing statements,
3-36
for performance statistics,
3-38
for query execution path,
3-38
using a database link,
3-40
with parallel query option,
3-41
transaction,
GL-24
transaction rollback,
GL-19
TRIMOUT variable,
8-111
TRIMSPOOL variable,
8-112
truncate,
GL-24
TRUNCATE command
disabling,
E-6
TRUNCATE variable,
F-2
,
F-7
TRUNCATED clause,
4-7
,
8-37
TTITLE clause,
8-125
TTITLE command,
4-22
,
8-140
,
GL-24
aligning title elements,
4-24
,
8-141
BOLD clause,
8-141
CENTER clause,
4-25
,
8-141
COL clause,
4-26
,
8-141
FORMAT clause,
4-27
,
8-142
indenting titles,
4-26
,
8-141
LEFT clause,
4-25
,
8-141
listing current definition,
4-28
,
8-142
OFF clause,
4-28
,
8-141
old form,
F-7
ON clause,
4-28
referencing column value variable,
4-29
,
8-35
restoring current definition,
4-28
RIGHT clause,
4-25
,
8-141
SKIP clause,
4-25
,
8-141
suppressing current definition,
4-28
,
8-141
TAB clause,
8-141
tuning,
3-36
type
column,
GL-24
U
UNDEFINE command,
3-22
,
8-144
and DEFINE command,
8-52
UNDERLINE variable,
4-3
,
8-112
UNTIL CANCEL clause,
8-83
UNTIL CHANGE clause,
8-83
UNTIL CONTROLFILE clause,
8-84
UNTIL TIME clause,
8-83
UPDATE command
disabling,
E-6
USER clause,
8-125
user profile,
3-19
LOGIN.SQL,
7-10
See also
user variables,
3-21
,
GL-24
defining,
3-21
,
8-52
deleting,
3-22
,
8-144
displaying in headers and footers,
8-91
displaying in titles,
8-140
in ACCEPT command,
3-28
,
8-10
listing definition of one,
3-21
,
8-52
listing definitions of all,
3-21
,
8-52
USERID,
GL-24
username,
1-6
,
GL-23
,
GL-24
connecting under different,
6-2
,
8-47
in CONNECT command,
6-2
,
6-3
,
8-47
in COPY command,
6-5
,
6-7
,
6-9
in SQLPLUS command,
2-3
,
6-4
,
7-9
userprofile
GLOGIN.SQL,
7-10
USING BACKUP CONTROL FILE clause,
8-84
USING clause,
6-6
,
8-51
V
V$SESSION virtual table,
8-99
V$SQLAREA virtual table,
8-100
VARCHAR columns
changing format,
4-6
default format,
4-6
,
8-32
VARCHAR datatype,
GL-24
VARCHAR2 clause
VARIABLE command,
8-145
VARCHAR2 columns
changing format,
4-6
,
8-32
default format,
4-6
VARCHAR2 datatype,
GL-25
VARIABLE command,
8-145
CHAR clause,
8-145
CLOB clause,
8-146
NCHAR clause,
8-145
NCLOB clause,
8-146
NUMBER clause,
8-145
REFCURSOR clause,
8-146
VARCHAR2 clause,
8-145
variable clause,
8-145
variables,
GL-22
,
GL-23
,
GL-25
bind variables,
3-31
substitution variables,
3-22
system variables,
2-13
user variables,
8-52
VARIANCE function,
4-16
VERIFY clause,
3-23
VERIFY variable,
3-26
,
8-112
W
WARNING clause,
8-67
web
outputting reports,
4-38
web browser,
4-38
WHENEVER OSERROR command,
8-151
COMMIT clause,
8-151
CONTINUE clause,
8-151
EXIT clause,
8-151
NONE clause,
8-151
ROLLBACK clause,
8-151
WHENEVER SQLERROR command,
3-18
,
8-153
COMMIT clause,
8-153
CONTINUE clause,
8-153
EXIT clause,
8-153
NONE clause,
8-153
ROLLBACK clause,
8-153
width,
GL-25
WORD_WRAPPED clause,
4-7
,
4-10
,
8-37
WRAP variable,
4-7
,
8-112
WRAPPED clause,
4-7
,
8-37
wrapping,
GL-25
Copyright © 1996-2000 Oracle Corporation.
All Rights Reserved.
Library
Product
Contents