SQL*Plus User's Guide and Reference
Release 8.1.5

A66736-01

Library

Product

Contents

Prev

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)
continuing a long SQL*Plus command, 2-12, 8-1
- (hyphen) clause, 7-3
. (period), 2-10
/ (slash) command, 8-10
entered at buffer line-number prompt, 2-8, 8-10
entered at command prompt, 2-10, 8-10
executing current PL/SQL block, 2-11
executing current SQL command, 2-10
similar to RUN, 2-10, 8-10, 8-97
/ (slash), default logon, 7-3, 8-49
# Pound sign, 8-36
$ number format, 4-5
& (ampersand)
substitution variables, 3-20
* (asterisk)
in DEL command, 3-2, 8-56
in LIST command, 3-2, 8-77
/*...*/ (comment delimiters), 3-12
: (colon)
bind variables, 3-30
:BindVariable clause
EXIT command, 8-69
; (semicolon), 2-7
-? clause, 7-3
@ ("at" sign)
in CONNECT command, 6-3, 8-49
in COPY command, 6-5, 8-51
in SQLPLUS command, 3-15, 6-3, 7-2
@ ("at" sign) command, 3-14, 3-18, 8-6
arguments, 8-6
command file, 3-15, 8-6
passing parameters to a command file, 8-6
similar to START, 3-15, 8-7, 8-131
@@ (double "at" sign) command, 3-18, 8-8
command file, 8-8
similar to START, 8-8, 8-131
[Backspace] key, 2-2
[Cancel] key, 2-2, 2-15
[Interrupt] key, 2-3
[Pause] key, 2-2, 2-17
[Resume] key, 2-2
[Return] key, 2-2
_EDITOR, in EDIT command, 3-7, 8-66
~ Infinity sign, 8-36
-~ Negative infinity sign, 8-36
0, number format, 4-5
9, number format, 4-5

A

ABORT mode, 8-127
ACCEPT command, 3-27, 8-11
and DEFINE command, 8-54
CHAR clause, 8-11
customizing prompts for value, 3-28
DATE clause, 8-11
DEFAULT clause, 8-12
FORMAT clause, 8-11
HIDE clause, 8-12
NOPROMPT clause, 8-12
NUMBER clause, 3-29
PROMPT clause, 3-28, 8-12
Access, denying and granting, E-2
ALIAS clause, 8-33
in ATTRIBUTE command, 8-19
ALL clause, 8-123
ALTER command
disabling, E-6
Ampersands (&)
in parameters, 3-25, 8-6, 8-130
substitution variables, 3-20
ANALYZE command
disabling, E-6
APPEND clause
in COPY command, 6-7, 8-52
in SAVE command, 3-16, 8-98
APPEND command, 3-2, 3-6, 8-13
APPINFO variable, 8-101
ARCH background process, 8-16
ARCHIVE LOG command, 5-4, 8-15
ARCHIVE LOG mode, 5-4
Arguments, in START command, 3-25, 8-130
ARRAYSIZE variable, 8-102
relationship to COPY command, 6-8, 8-53
Attribute
display characteristics, 8-19
ATTRIBUTE command, 8-19
ALIAS clause, 8-19
and CLEAR COLUMN command, 8-20
CLEAR clause, 8-20
clearing columns, 8-30, 8-33
controlling an attribute's display charcteristics, 8-20
entering multiple, 8-20
FORMAT clause, 8-20
LIKE clause, 8-20
listing all attributes' display characteristics, 8-19
listing an attribute's display characteristics, 8-19
OFF clause, 8-20
ON clause, 8-20
restoring column display attributes, 8-20
suppressing column display attributes, 8-20
AUDIT command
disabling, E-6
AUTOCOMMIT variable, 2-14, 8-102
AUTOMATIC clause, 8-85
AUTOPRINT variable, 8-103
AUTORECOVERY variable, 8-103
AUTOTRACE variable, 3-35
AVG function, 4-17

B

Background processes
startup after abnormal termination, 8-127
Batch mode, 3-17, 8-70
BEGIN command, 2-10
disabling, E-6
Bind variables, 3-30
creating, 8-144
displaying, 8-82
displaying automatically, 8-103, 8-145
in PL/SQL blocks, 8-145
in SQL statements, 8-145
in the COPY command, 8-145
REFCURSOR, 3-32
Blank line
in PL/SQL blocks, 2-10
in SQL commands, 2-8
Blank lines
preserving in SQL commands, 8-111
Blocks, PL/SQL, 1-2
continuing, 2-10
editing in buffer, 3-2
editing with host system editor, 3-7, 8-66
entering and executing, 2-10
listing current in buffer, 3-3
run from SQL buffer, 2-10
saving current, 3-8, 8-98
setting character used to end, 8-104
stored in SQL buffer, 2-10
storing in command files, 3-8
timing statistics, 8-113
within SQL commands, 2-9
BLOCKTERMINATOR variable, 8-104
BOLD clause, 8-94, 8-140
Break columns, 4-11, 8-21
inserting space when value changes, 4-13
specifying multiple, 4-14
suppressing duplicate values in, 4-12
BREAK command, 4-11, 8-21
and SQL ORDER BY clause, 4-11, 4-12, 4-14, 8-22
clearing BREAKS, 4-16
displaying column values in titles, 4-30
DUPLICATES clause, 8-24
inserting space after every row, 4-14
inserting space when break column changes, 4-13
listing current break definition, 4-16, 8-24
ON column clause, 4-12, 8-21
ON expr clause, 8-23
ON REPORT clause, 4-20, 8-23
ON ROW clause, 4-14, 8-23
printing "grand" and "sub" summaries, 4-21
printing summary lines at ends of reports, 4-20
removing definition, 8-30
SKIP clause, 4-14, 8-23
SKIP PAGE clause, 4-13, 4-14, 8-24
specifying multiple break columns, 4-14, 8-22
storing current date in variable for titles, 4-32
suppressing duplicate values, 4-12
used in conjunction with COMPUTE, 4-16, 8-21, 8-22, 8-23, 8-45
used in conjunction with SET COLSEP, 8-105
used to format a REFCURSOR variable, 8-146
Break definition
listing current, 4-16, 8-24
removing current, 4-16, 8-30
BREAKS clause, 4-16, 8-30
BTITLE clause, 8-124
BTITLE command, 4-23, 8-26
aligning title elements, 8-140
BOLD clause, 8-140
CENTER clause, 8-140
COL clause, 8-140
FORMAT clause, 8-141
indenting titles, 8-140
LEFT clause, 8-140
most often used clauses, 4-23
OFF clause, 8-140
old form, F-2
printing blank lines before bottom title, 4-27
referencing column value variable, 8-38
RIGHT clause, 8-140
SKIP clause, 8-140
suppressing current definition, 8-140
TAB clause, 8-140
TTITLE command, 8-26
Buffer, 2-10
appending text to a line in, 3-6, 8-13
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-56
deleting a single line, 8-56
deleting all lines, 3-2, 8-30, 8-56
deleting lines from, 3-7, 8-56
deleting the current line, 8-56
deleting the last line, 8-56
executing contents, 2-10, 8-10, 8-97
inserting new line in, 3-5, 8-75
listing a range of lines, 3-3, 8-77
listing a single line, 3-2, 8-77
listing all lines, 3-2, 8-77
listing contents, 3-3, 8-77
listing the current line, 3-2, 8-77
listing the last line, 3-3, 8-77
loading contents into host system editor, 3-7, 8-66
saving contents, 3-8, 8-98
BUFFER clause, 3-2, 3-9, 8-30
BUFFER variable, F-3

C

CANCEL clause, 8-87
CENTER clause, 4-24, 4-26, 8-94, 8-140
CHANGE command, 3-2, 3-4, 8-27
CHAR clause, 8-11
VARIABLE command, 8-144
CHAR columns
changing format, 4-7, 8-34
default format, 4-6, 8-34
CLEAR clause, 4-9, 8-33
in ATTRIBUTE command, 8-20
CLEAR command, 8-30
BREAKS clause, 4-16, 8-30
BUFFER clause, 3-2, 3-9, 8-30
COLUMNS clause, 4-9, 8-30
COMPUTES clause, 4-22, 8-30
SCREEN clause, 3-30, 8-30
SQL clause, 8-31
TIMING clause, 8-31
CLOB clause
VARIABLE command, 8-145
CLOB columns
changing format, 4-7, 8-34
default format, 8-34
setting maximum width, 8-109
setting retrieval position, 8-109
setting retrieval size, 8-109
CMDSEP variable, 8-104
COL clause, 4-24, 4-27, 8-94, 8-140
Colons (:)
bind variables, 3-30
COLSEP variable, 8-104
COLUMN command, 4-2, 8-32
ALIAS clause, 8-33
and BREAK command, 8-23
and DEFINE command, 8-54
CLEAR clause, 4-9, 8-33
DEFAULT clause, F-2
displaying column values in bottom titles, 4-31, 8-38
displaying column values in top titles, 4-30, 8-37
entering multiple, 8-39
FOLD_AFTER clause, 8-33
FOLD_BEFORE clause, 8-33
FORMAT clause, 4-5, 4-7, 8-34
formatting columns, 4-7
formatting NUMBER columns, 4-5, 8-34
HEADING clause, 4-2, 8-36
HEADSEP character, 8-36
JUSTIFY clause, 8-37
LIKE clause, 4-8, 8-37
listing a column's display attributes, 4-9, 8-32
listing all columns' display attributes, 8-32
listing all columnsdisplayattributes', 4-9
NEW_VALUE clause, 4-30, 4-32, 8-37
NEWLINE clause, 8-37
NOPRINT clause, 4-30, 8-38
NULL clause, 8-38
OFF clause, 4-10, 8-38
OLD_VALUE clause, 4-31, 8-38
ON clause, 4-10, 8-38
PRINT clause, 8-38
resetting a column to default display, 4-9, 8-33
restoring column display attributes, 4-10, 8-38
storing current date in variable for titles, 4-32, 8-40
suppressing column display attributes, 4-10, 8-38
TRUNCATED clause, 4-8, 8-38
used to format a REFCURSOR variable, 8-146
WORD_WRAPPED clause, 4-8, 4-10, 8-38
WRAPPED clause, 4-8, 8-38
Column headings
aligning, 8-37
changing, 4-2, 8-36
changing character used to underline, 4-3, 8-113
changing to two or more words, 4-3, 8-36
displaying on more than one line, 4-3, 8-36
suppressing printing in a report, 8-107
when truncated, 8-34
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-104
Columns
assigning aliases, 8-33
computing summary lines, 4-16, 8-43
copying display attributes, 4-8, 8-20, 8-37
copying values between tables, 6-4, 6-9, 8-51
displaying values in bottom titles, 4-31, 8-38
displaying values in top titles, 4-30, 8-37
formatting CHAR, VARCHAR, LONG, and DATE, 8-34
formatting in reports, 4-2, 8-32
formatting MLSLABEL, RAW MLSLABEL, ROWLABEL, 8-34
formatting NUMBER, 4-5, 8-34
listing display attributes for all, 4-9, 8-32
listing display attributes for one, 4-9, 8-32
names in destination table when copying, 6-5, 8-51
printing line after values that overflow, 4-10, 8-110
resetting a column to default display, 4-9, 8-33
resetting all columns to default display, 4-9, 8-30
restoring display attributes, 4-10, 8-20, 8-38
setting printing to off or on, 4-30, 8-38
starting new lines, 8-37
storing values in variables, 4-30, 8-37
suppressing display attributes, 4-10, 8-20, 8-38
truncating display for all when value overflows, 4-8, 8-114
truncating display for one when value overflows, 4-8, 8-38
wrapping display for all when value overflows, 4-8, 8-114
wrapping display for one when value overflows, 4-8, 8-38
wrapping whole words for one, 4-10
COLUMNS clause, 4-9, 8-30
Comma, number format, 4-5
Command file extension, 8-98, 8-112, 8-136
Command files, 3-8
aborting and exiting with a return code, 3-17, 8-151, 8-153
allowing end-user input, 3-19
creating with a system editor, 3-11
creating with INPUT and SAVE, 3-9
creating with SAVE, 3-8, 8-98
editing with GET and SAVE, 3-16
editing with host system editor, 3-16, 8-66
in @ ("at" sign) command, 3-14, 8-6
in @@ (double "at" sign) command, 8-8
in EDIT command, 3-16, 8-66
in GET command, 3-13, 8-71
in SAVE command, 3-8, 3-10, 8-98
in SQLPLUS command, 3-15, 7-2
in START command, 3-14, 8-130
including comments in, 3-11, 8-90
including more than one PL/SQL block, 3-10, 3-11
including more than one SQL command, 3-10, 3-11
listing names with HOST command, 3-9
nesting, 3-15
passing parameters to, 3-25, 8-6, 8-130
registering, 8-101
retrieving, 3-13, 8-71
running, 3-14, 8-6, 8-130
running a series in sequence, 3-15
running as you start SQL*Plus, 3-15, 7-2
running in batch mode, 3-17, 8-70
running nested, 8-8
saving contents of buffer in, 3-8, 8-98
Command prompt
host operating system, 2-3
SQL*Plus, 2-4
Commands, 1-2
case, 2-5
collecting timing statistics on, 2-16, 8-137
disabling, E-4
host operating system, running from SQL*Plus, 2-16, 8-74
listing current in buffer, 8-77
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-66
ending, 2-8
entering and executing, 2-6
entering without executing, 2-8
executing current, 2-10, 8-10, 8-97
following syntax, 2-7
list of major, D-1
listing current in buffer, 3-3
saving current, 3-8, 8-98
setting character used to end and run, 8-112
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-112
stopping while running, 2-15
storing in command files, 3-8
syntax conventions, 1-4
tabs, 2-5
types of, 2-5
variables that affect running, 2-13
writing interactive, 3-19
Comments
including in command files, 3-11, 8-90
using -- to create, 3-12
using /*...*/ to create, 3-12
using REMARK to create, 3-11, 8-90
COMMIT clause, 8-69
WHENEVER OSERROR, 8-150
WHENEVER SQLERROR, 8-152
COMMIT command, 2-14
COMPATIBILITY clause
in LOGIN.SQL, 3-17
COMPATIBILITY variable, 8-105
COMPUTE command, 4-11, 8-43
AVG function, 4-17
computing a summary on different columns, 4-21
COUNT function, 4-17
LABEL clause, 4-17, 4-20, 8-44
listing all definitions, 4-22, 8-45
MAXIMUM function, 4-17
maximum LABEL length, 8-44
MINIMUM function, 4-17
NUMBER function, 4-17
OF clause, 4-16
ON column clause, 4-16, 8-44
ON expr clause, 8-44
ON REPORT clause, 4-20, 8-44
ON ROW clause, 8-44
printing "grand" and "sub" summaries, 4-21
printing multiple summaries on same column, 4-21
printing summary lines at ends of reports, 4-20
printing summary lines on a break, 4-16
referencing a SELECT expression in OF, 8-44
referencing a SELECT expression in ON, 8-45
removing definitions, 4-23, 8-30
STD function, 4-17
SUM function, 4-17
used to format a REFCURSOR variable, 8-146
VARIANCE function, 4-17
COMPUTES clause, 4-22, 8-30
CONCAT variable, 3-25, 8-105
Concurrency
instances, multiple, 8-133
CONNECT command
changing password, 8-79
SYSDBA clause, 8-50
CONNECT command (SQL)
disabling, E-6
CONNECT command (SQL*Plus), 6-2, 6-3, 8-49
and @ ("at" sign), 6-3, 8-49
changing password, 8-49, 8-50
service name, 6-3
username/password, 6-2, 6-3, 6-4, 8-49
CONTINUE clause
WHENEVER OSERROR, 8-150
WHENEVER SQLERROR, 8-152
Continuing a long SQL*Plus command, 2-12, 8-1
Conventions, command syntax, 1-4
COPY command, 6-4, 8-51
and @ ("at" sign), 6-5, 8-51
and ARRAYSIZE variable, 6-8, 8-53
and COPYCOMMIT variable, 6-8, 8-53
and LONG variable, 6-8, 8-53
APPEND clause, 6-7, 8-52
copying data between databases, 6-4
copying data between tables on one database, 6-9
CREATE clause, 6-7, 8-52
creating a table, 6-6, 6-7, 8-52
destination table, 6-5, 8-51
determining actions, 6-5
determining source rows and columns, 6-6, 8-52
disabling, E-5
FROM clause, 6-5, 8-52
INSERT clause, 6-7, 8-52
inserting data in a table, 6-7, 8-52
interpreting messages, 6-8
mandatory net service name, 8-51
naming the source table with SELECT, 6-6, 8-52
query, 6-6, 8-52
referring to another user's table, 6-8
REPLACE clause, 6-6, 8-52
replacing data in a table, 6-6, 8-52
sample command, 6-5, 6-6
service name, 6-5, 6-7, 6-9
specifying column names for destination, 8-51
specifying the data to copy, 6-6, 8-52
TO clause, 6-5, 8-52
username/password, 6-5, 6-7, 6-9, 8-51, 8-52
USING clause, 6-6, 8-52
when a commit is performed, 8-53
Copy command
specifying column names for destination, 6-5
COPYCOMMIT variable, 8-105
relationship to COPY command, 6-8, 8-53
COPYTYPECHECK variable, 8-105
COUNT function, 4-17
CREATE clause
in COPY command, 6-7, 8-52
CREATE command
disabling, E-6
entering PL/SQL, 2-9
Creating flat files, 4-36
Creating the PRODUCT_USER_PROFILE table, E-2
Cursor Variables, 8-145

D

Database
mounting, 8-132
opening, 8-132
Database administrator, 1-7, 5-2
Database changes, saving automatically, 2-14, 8-102
DATABASE clause, 8-86
Database files
recovering, 8-85
Database name
at startup, 8-132
Databases
and RECOVERY command, 8-85
connecting to default, 6-2, 8-49
connecting to remote, 6-3, 8-49
copying data between, 6-4, 8-51
copying data between tables on a single, 6-9
disconnecting without leaving SQL*Plus, 6-2, 8-65
mounting, 5-3
opening, 5-3
recovering, 5-5, 8-85
shutting down, 5-2, 5-3
starting, 5-2
DATAFILE clause, 8-87
DATE clause, 8-11
DATE columns
changing format, 4-7, 8-34, 8-41
default format, 4-6
Date, storing current in variable for titles, 4-32, 8-37, 8-40
DB2, 8-105
DBA mode, 8-132
DBA privilege, 8-132
DBMS_APPLICATION_INFO package, 8-101
DECLARE command
disabling, E-6
DECLARE command (PL/SQL), 2-10
DEFAULT clause, 8-12, F-2
DEFINE command, 3-19, 8-54
and host system editor, 3-7, 8-55
CHAR values, 8-54
substitution variables, 3-23, 8-54
DEFINE variable, 3-25, 8-105
DEL command, 3-2, 3-7, 8-56
using an asterisk, 3-2, 8-56
DELETE command
disabling, E-6
DEMOBLD, 1-8
DEMODROP, 1-8
DEPT table, 1-6
DESCRIBE command (SQL*Plus), 2-16, 8-58
net service name, 8-58
PL/SQL properties listed by, 8-59
table properties listed by, 8-58
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-65
DOCUMENT command, F-2
REMARK as newer version of, F-3
DOCUMENT variable, F-4
DROP command
disabling, E-6
DUPLICATES clause, 8-24

E

ECHO variable, 3-14, 8-106
EDIT command, 3-7, 8-66
creating command files with, 3-11
defining _EDITOR, 3-7, 8-66
disabling, E-5
modifying command files, 3-16, 8-66
setting default file name, 8-106
EDITFILE variable, 8-106
EMBEDDED variable, 8-106
EMP table, 1-6
Empty line, displaying, 8-81
Enhancement list, Release 8.1, B-2
Error messages, interpreting, 2-18
Errors, making line containing current, 3-4
Escape characters, definition of, 8-106
ESCAPE variable, 3-25, 8-106
EXCLUSIVE clause, 8-133
EXECUTE command, 8-68
disabling, E-5
Executing
a CREATE command, 2-9
Execution statistics
including in report, 8-103
EXIT clause
WHENEVER OSERROR, 8-150
WHENEVER SQLERROR, 8-152
EXIT command, 2-4, 8-69
:BindVariable clause, 8-69
COMMIT clause, 8-69
disabling, E-5
FAILURE clause, 8-69
in a command file, 8-131
ROLLBACK clause, 8-69
WARNING clause, 8-69
Exit, conditional, 8-150, 8-152
Extension, 8-98, 8-112, 8-136

F

FAILURE clause, 8-69
FEEDBACK variable, 8-107
File extension, 8-98, 8-112, 8-136
File extensions, 3-18
File names
in @ ("at" sign) command, 8-6
in @@ (double "at" sign) command, 8-8
in EDIT command, 8-66
in GET command, 8-71
in SAVE command, 3-8, 8-98
in SPOOL command, 4-35, 8-129
in SQLPLUS command, 7-2
in START command, 8-130
Files
command files, 3-8
flat, 4-36
FLAGGER variable, 8-107
Flat file, 4-36
FLUSH variable, 8-107
FOLD_AFTER clause, 8-33
FOLD_BEFORE clause, 8-33
Footers
aligning elements, 8-94
displaying at bottom of page, 8-91
displaying system-maintained values, 8-93
formatting elements, 8-94
indenting, 8-94
listing current definition, 8-91
setting at the end of reports, 4-23
suppressing definition, 8-94
FORCE clause, 8-132
FORMAT clause, 8-11
in ATTRIBUTE command, 8-20
in COLUMN command, 4-5, 4-7, 8-34
in REPHEADER and REPFOOTER commands, 8-94
in TTITLE and BTITLE commands, 4-29, 8-141
Format models, number, 4-5, 8-36
Formfeed, to begin a new page, 4-33, 8-109
FROM clause, 8-86
FROM clause (SQL*Plus), 6-5, 8-52

G

GET command, 3-13, 8-71
disabling, E-5
LIST clause, 8-71
modifying command files, 3-16
NOLIST clause, 8-71
retrieving command files, 3-13, 8-71
GLOGIN.SQL, 3-17, 3-36, 3-40, 7-3
GRANT command, E-2
disabling, E-6

H

Headers
aligning elements, 4-26
displaying at top of page, 8-93
displaying system-maintained values, 8-93
setting at the start of reports, 4-23
suppressing, 4-25
HEADING clause, 4-2, 8-36
HEADING variable, 8-107
Headings
aligning elements, 8-94
column headings, 8-107
formatting elements, 8-94
indenting, 8-94
listing current definition, 8-95
suppressing definition, 8-94
HEADSEP variable, 8-108
use in COLUMN command, 4-3, 8-37
Help command, 8-73
Help, online, 2-6, 7-5, 8-73
HIDE clause, 8-12
HOST command, 2-16, 8-74
disabling, E-5
listing command file names with, 3-9
Host operating system
command prompt, 2-3
editor, 3-7, 8-66
file, loading into buffer, 8-71
running commands from SQL*Plus, 2-16, 8-74
Hyphen
continuing a long SQL*Plus command, 2-12, 8-1

I

IMMEDIATE mode, 8-127
Infinity sign (~), 8-36
Initialization parameters
displaying, 8-124
INIT.ORA file
Parameter file, 8-132
Input
accepting [Return], 3-30, 8-81
accepting values from the user, 3-27, 8-11
INPUT command, 3-2, 3-5, 8-75
entering several lines, 8-75
using with SAVE to create command files, 3-9
INSERT clause, 6-7, 8-52
INSERT command
disabling, E-6
INSTANCE variable, 8-108
Instances
multiple, sharing a database, 8-133
shutting down, 8-127
starting, 8-132

J

JDeveloper Suite, 1-3
JUSTIFY clause, 8-37

K

Keyboard, significance of keys on, 2-2
Keys
[Backspace] key, 2-2
[Cancel] key, 2-2
[Interrupt] key, 2-3
[Pause] key, 2-2
[Resume] key, 2-2
[Return] key, 2-2

L

Labels
in COMPUTE command, 4-17, 8-44
LEFT clause, 4-24, 4-26, 8-94, 8-140
LIKE clause, 4-8, 8-20, 8-37
Limits, SQL*Plus, C-1
Line numbers, for SQL commands, 2-6
Lines
adding at beginning of buffer, 8-75
adding at end of buffer, 8-75
adding new after current, 3-5, 8-75
appending text to, 3-6, 8-13
changing width, 4-33, 8-108
deleting all in buffer, 8-56
deleting from buffer, 3-7, 8-56
determining which is current, 3-4
editing current, 3-4
listing all in buffer, 3-2, 8-77
removing blanks at end, 8-113
LINESIZE variable, 4-26, 4-33, 8-108
LIST clause, 8-15, 8-71
LIST command, 3-2, 8-77
determining current line, 3-4, 8-77
making last line current, 3-4, 8-77
using an asterisk, 3-2, 8-77
LNO clause, 8-124
LOBOFFSET variable, 8-109
LOCK TABLE command
disabling, E-6
LOG_ARCHIVE_DEST parameter, 8-15
LOGFILE clause, 8-87
Logging off
conditionally, 8-150, 8-152
Oracle, 6-2, 8-65
SQL*Plus, 2-4, 8-69
Logging on
Oracle, 6-2, 6-3, 8-49
SQL*Plus, 2-4, 7-2
LOGIN.SQL, 3-17, 7-4
including SET commands, 3-17
sample commands to include, 3-17
storing current date in variable for titles, 4-32
LONG columns
changing format, 4-7, 8-34
default format, 8-34
setting maximum width, 8-109
setting retrieval size, 8-109
LONG variable, 8-109
effect on COPY command, 6-8, 8-53
LONGCHUNKSIZE variable, 4-7, 8-34, 8-109

M

MAXIMUM function, 4-17
Media recovery, 8-133
Message, sending to screen, 3-27, 8-83
MINIMUM function, 4-17
MOUNT clause, 8-132
Mounting
shared databases, 8-133
Mounting a database, 8-132

N

NCHAR clause
VARIABLE command, 8-144
NCHAR columns
changing format, 4-7, 8-34
default format, 4-6, 8-34
NCLOB clause
VARIABLE command, 8-145
NCLOB columns
changing format, 4-7, 8-34
default format, 8-34
setting maximum width, 8-109
setting retrieval position, 8-109
setting retrieval size, 8-109
Negative infinity sign (-~), 8-36
Net service names
in DESCRIBE command, 8-58
Net8 protocol, 6-3
NEW_VALUE clause, 4-30, 8-37
storing current date in variable for titles, 4-32, 8-37, 8-40
NEWLINE clause, 8-37
NEWPAGE command, F-3
NEWPAGE variable, 4-33, 8-109
NEXT clause, 8-16
NLS_DATE_FORMAT, 8-11, 8-41
NOAUDIT command
disabling, E-6
NOLIST clause, 8-71
/NOLOG option, 7-3
NOMOUNT clause, 8-133
NONE clause
WHENEVER OSERROR, 8-150
WHENEVER SQLERROR, 8-152
NOPARALLEL clause, 8-88
NOPRINT clause, 4-17, 4-30, 8-38
NOPROMPT clause, 8-12
NORMAL mode, 8-127
NULL clause, 8-38
Null values
setting text displayed, 8-38, 8-109
NULL variable, 8-109
NUMBER clause, 3-29, 8-11
VARIABLE command, 8-144
NUMBER columns
changing format, 4-5, 8-34
default format, 4-4, 8-36
Number formats
$, 4-5
0, 4-5
9, 4-5
comma, 4-5
setting default, 8-109
NUMBER function, 4-17
NUMFORMAT clause
in LOGIN.SQL, 3-17
NUMFORMAT variable, 8-109
NUMWIDTH variable, 8-109
effect on NUMBER column format, 4-4, 8-36
NVARCHAR2 columns
changing format, 4-7, 8-34
default format, 4-6, 8-34

O

Objects
describing, 8-106
OF clause, 4-16
OFF clause
in ATTRIBUTE command, 8-20
in COLUMN command, 4-10, 8-38
in REPHEADER and REPFOOTER commands, 8-94
in SPOOL command, 4-35, 8-129
in TTITLE and BTITLE commands, 4-30, 8-140
OLD_VALUE clause, 4-31, 8-38
ON clause
in ATTRIBUTE command, 8-20
in COLUMN command, 4-10, 8-38
in TTITLE and BTITLE commands, 4-30
ON column clause
in BREAK command, 4-12, 8-21
in COMPUTE command, 4-16, 8-44
ON expr clause
in BREAK command, 8-23
in COMPUTE command, 8-44
ON REPORT clause
in BREAK command, 4-20, 8-23
in COMPUTE command, 4-20, 8-44
ON ROW clause
in BREAK command, 4-14, 8-23
in COMPUTE command, 8-44
Online help, 2-6, 7-5, 8-73
OPEN clause, 8-132
Opening a database, 8-132
Oracle Application Server, 1-3
Oracle Designer, 1-3
Oracle Developer, 1-3
Oracle Discoverer, 1-3
Oracle Enterprise Developer Suite, 1-3
Oracle Express, 1-4
Oracle Media Objects, 1-4
Oracle Mobile Agents, 1-4
Oracle Programmer, 1-3
Oracle Reports, 1-3
Oracle Workflow, 1-3
ORDER BY clause
displaying column values in titles, 4-30
displaying values together in output, 4-11
OUT clause, 4-36, 8-129
Output
formatting white space in, 8-113
pausing during display, 2-17, 8-110
query results, 1-2

P

PAGE clause, 8-93
Page number, including in titles, 4-15, 4-28
Pages
changing length, 4-33, 8-110
default dimensions, 4-32
matching dimensions to screen or paper size, 4-33
setting dimensions, 4-32
PAGESIZE variable, 2-7, 4-33, 8-110
PAGESIZEclause
in LOGIN.SQL, 3-17
PARALLEL clause, 8-133
PARALLEL DEGREE clause, 8-87
PARALLEL DEGREE DEFAULT clause, 8-87
PARALLEL INSTANCES clause, 8-88
PARALLEL INSTANCES DEFAULT clause, 8-88
Parameter files (INIT.ORA files)
specifying alternate, 8-132
Parameters, 3-25, 8-6, 8-130
PARAMETERS clause, 8-124
Password, 1-7
changing with the PASSWORD command, 8-79
in CONNECT command, 6-2, 6-3, 8-49
in COPY command, 6-5, 6-7, 6-9, 8-51
in SQLPLUS command, 2-4, 6-4, 7-2
PASSWORD command, 8-49, 8-79
disabling, E-5
Paths, creating
Installation and User's Guide, 8-53
PAUSE command, 3-30, 8-81
in LOGIN.SQL, 3-17
PAUSE variable, 2-17, 8-110
Performance
of SQL statements, 3-35
Performance, over dial-up lines, 8-113
Period (.)
terminating PL/SQL blocks, 2-10
PLAN_TABLE table, 3-36
PL/SQL, 1-2, 2-10
blocks, PL/SQL, 2-10
executing, 8-68
formatting output in SQL*Plus, 8-145
listing definitions, 2-17
mode in SQL*Plus, 2-9
within SQL commands, 2-9
PLUSTRACE role, 3-36
PNO clause, 8-125
Pound sign (#), 8-36
PRINT clause, 8-38
PRINT command, 8-82
Printing
bind variables automatically, 8-103
REFCURSOR variables, 8-146
SPOOL command, 8-129
PRODUCT_USER_PROFILE table, E-2
PROMPT clause, 3-28, 8-12
PROMPT command, 3-27, 8-83
customizing prompts for value, 3-28
Prompts for value
bypassing with parameters, 3-25
customizing, 3-28
through ACCEPT, 3-27
through substitution variables, 3-21
PUPBLD.SQL, E-2

Q

Queries, 1-2
displaying number of records retrieved, 2-7, 8-107
in COPY command, 6-6, 8-52
Query execution path
including in report, 8-103
Query results, 1-2
displaying on-screen, 2-7
sending to a printer, 4-36, 8-129
storing in a file, 4-35, 8-129
QUIT command, 8-69
disabling, E-5
in a command file, 8-131

R

Record separators, printing, 4-10, 8-110
RECOVER clause, 8-133
RECOVER command, 8-85
AUTOMATIC clause, 8-85
CANCEL clause, 8-87
CONTINUE clause, 8-87
DATABASE clause, 8-86
DATAFILE clause, 8-87
FROM clause, 8-86
LOGFILE clause, 8-87
NOPARALLEL clause, 8-88
PARALLEL DEGREE clause, 8-87
PARALLEL DEGREE DEFAULT clause, 8-87
PARALLEL INSTANCES clause, 8-88
PARALLEL INSTANCES DEFAULT clause, 8-88
STANDBY DATABASE clause, 8-86
STANDBY DATAFILE clause, 8-87
STANDBY TABLESPACE clause, 8-87
TABLESPACE clause, 8-87
UNTIL CANCEL clause, 8-86
UNTIL CHANGE clause, 8-86
UNTIL CONTROLFILE clause, 8-87
UNTIL TIME clause, 8-86
USING BACKUP CONTROL FILE clause, 8-86
Recovery
RECOVER command, 8-85
RECOVERY command
and database recovery, 5-5
RECSEP variable, 4-10, 8-110
RECSEPCHAR variable, 4-10, 8-110
Redo Log Files
ARCHIVE LOG command, 8-15
REFCURSOR bind variables, 3-32
in a stored function, 3-32
REFCURSOR clause
VARIABLE command, 8-145
RELEASE clause, 8-125
REMARK command, 3-11, 8-90
RENAME command
disabling, E-6
REPFOOTER clause, 8-125
REPFOOTER command, 4-23, 8-91
aligning footer elements, 8-94
BOLD clause, 8-94
CENTER clause, 8-94
COL clause, 8-94
FORMAT clause, 8-94
indenting report footers, 8-94
LEFT clause, 8-94
most often used clauses, 4-23
OFF clause, 8-94
RIGHT clause, 8-94
SKIP clause, 8-94
suppressing current definition, 8-94
TAB clause, 8-94
REPHEADER clause, 8-125
REPHEADER command, 4-23, 8-93
aligning header elements, 4-26
aligning heading elements, 8-94
BOLD clause, 8-94
CENTER clause, 4-24, 8-94
COL clause, 4-24, 8-94
FORMAT clause, 8-94
indenting headings, 8-94
LEFT clause, 4-24, 8-94
most often used clauses, 4-23
OFF clause, 8-94
PAGE clause, 8-93
RIGHT clause, 4-24, 8-94
SKIP clause, 4-24, 8-94
suppressing current definition, 8-94
TAB clause, 8-94
REPLACE clause
in COPY command, 6-6, 8-52
in SAVE command, 3-16, 8-98
Report breaks
BREAK command, 8-21
Report columns
Columns, 8-33
Report titles
Titles, 8-139
Reports, 1-2
clarifying with spacing and summary lines, 4-11
creating bottom titles, 4-23, 8-26
creating footers, 8-91
creating headers, 8-93
creating headers and footers, 4-23
creating master/detail, 4-30, 8-37, 8-38
creating top titles, 4-23, 8-139
displaying, 8-103
formatting column headings, 4-2, 8-32
formatting columns, 4-4, 4-6, 8-32
starting on a new page, 8-106
RESTRICT clause, 8-132
RETRY clause, 8-133
Return code, specifying, 3-17, 8-70, 8-153
REVOKE command, E-2
disabling, E-6
RIGHT clause, 4-24, 4-26, 8-94, 8-140
Roles, E-8
disabling, E-7
re-enabling, E-7
ROLLBACK clause, 8-69
WHENEVER OSERROR, 8-150
WHENEVER SQLERROR, 8-152
Rows
performing computations on, 4-16, 8-43
setting number retrieved at one time, 8-102
setting the number after which COPY commits, 8-105
RUN command, 2-10, 8-97
disabling, E-5
executing current PL/SQL block, 2-11
executing current SQL command or PL/SQL block, 2-10
making last line current, 3-4
similar to / (slash) command, 2-10, 8-97

S

Sample tables, 1-5
access to, 1-8
DEMOBLD, 1-8
DEMODROP, 1-8
SAVE command, 3-8, 8-98
APPEND clause, 3-16, 8-98
disabling, E-5
modifying command files, 3-16
REPLACE clause, 3-16, 8-98
storing commands in command files, 3-8, 8-98
using with INPUT to create command files, 3-10
Saving environment attributes, 8-136
SCAN variable, F-5
SCREEN clause, 3-30, 8-30
Screen, clearing, 3-30, 8-30
Search paths
Installation and User's Guide, 8-53
Security
changing password, 8-79
PRODUCT_USER_PROFILE table, E-2
SELECT command
and BREAK command, 4-11, 8-22, 8-23
and COLUMN command, 8-33
and COMPUTE command, 4-11
and COPY command, 6-6, 8-52
and DEFINE command, 8-54
and ORDER BY clause, 4-11
disabling, E-6
storing current date in variable for titles, 4-32
SELECT statement
formatting results, 3-32
Semicolon (;)
in PL/SQL blocks, 2-10
in SQL commands, 2-7, 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
SERVEROUTPUT variable, 8-111
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-3
Service names
in SQLPLUS command, 7-3
SET AUTOTRACE, 3-35
SET clause, 8-136
SET command, 2-13, 3-18, 8-100
APPINFO variable, 8-101
ARRAYSIZE variable, 6-8, 8-102
AUTOCOMMIT variable, 2-14, 8-102
AUTOPRINT variable, 8-103, 8-145
AUTORECOVERY variable, 8-103
BLOCKTERMINATOR variable, 8-104
BUFFER variable, F-3
CMDSEP variable, 8-104
COLSEP variable, 4-36, 8-104
COMPATIBILITY clause, 3-17
COMPATIBILITY variable, 8-105
CONCAT variable, 3-25, 8-105
COPYCOMMIT variable, 6-8, 8-105
COPYTYPECHECK variable, 8-105
DEFINE clause, 3-25
DEFINE variable, 8-105
DESCRIBE variable, 8-106
disabling, E-5
DOCUMENT variable, F-4
ECHO variable, 3-14, 8-106
EDITFILE variable, 8-106
EMBEDDED variable, 8-106
ESCAPE variable, 3-25, 8-106
FEEDBACK variable, 8-107
FLAGGER variable, 8-107
FLUSH variable, 8-107
HEADING variable, 8-107
HEADSEP variable, 4-3, 8-108
INSTANCE variable, 8-108
LINESIZE variable, 4-26, 4-33, 8-108
LOBOFFSET variable, 8-109
LOGSOURCE variable, 8-109
LONG variable, 6-8, 8-109
LONGCHUNKSIZE variable, 8-109
MAXDATA variable, F-5
NEWPAGE variable, 4-33, 8-109
NULL variable, 8-109
NUMFORMAT clause, 3-17
NUMFORMAT variable, 8-109
NUMWIDTH variable, 4-4, 8-36, 8-109
PAGESIZE clause, 3-17
PAGESIZE variable, 2-7, 4-33, 8-110
PAUSE clause, 3-17
PAUSE variable, 2-17, 8-110
RECSEP variable, 4-10, 8-110
RECSEPCHAR variable, 4-10, 8-110
SCAN variable, F-5
SERVEROUTPUT variable, 8-111
SHIFTINOUT clause, 3-18
SHIFTINOUT variable, 8-111
SPACE variable, F-5
SQLBLANKLINES variable, 8-111
SQLCASE variable, 8-112
SQLCONTINUE variable, 8-112
SQLNUMBER variable, 8-112
SQLPREFIX variable, 8-112
SQLPROMPT variable, 8-112
SQLTERMINATOR variable, 8-112
SUFFIX variable, 8-112
TAB variable, 8-113
TERMOUT variable, 4-32, 8-113
TIME clause, 3-18
TIME variable, 8-113
TIMING variable, 8-113
TRIMOUT variable, 8-113
TRIMSPOOL variable, 8-113
TRUNCATE variable, F-6
UNDERLINE variable, 4-3, 8-113
used to format a REFCURSOR variable, 8-146
VERIFY clause, 3-21
VERIFY variable, 3-25, 8-114
WRAP variable, 4-8, 8-114
SET command variables
system variables, 2-13
SET ROLE command
disabling, E-6
SET TRANSACTION command
disabling, E-6
SGA clause, 8-125
Shared disk systems
mounting shared, 8-133
Shared mode
database, 8-133
SHIFTINOUT clause
in LOGIN.SQL, 3-18
SHIFTINOUT variable, 8-111
SHOW clause, 8-137
SHOW command, 2-14, 8-123
ALL clause, 8-123
BTITLE clause, 8-124
ERRORS clause, 8-124
listing current page dimensions, 4-35
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-111
SHUTDOWN command, 8-127
ABORT variable, 8-127
IMMEDIATE variable, 8-127
NORMAL variable, 8-127
TRANSACTIONAL variable, 8-127
-SILENT clause, 7-2
Site Profile, 7-3
SKIP clause
in BREAK command, 4-13, 4-14, 8-23
in REPHEADER and REPFOOTER commands, 8-94
in TTITLE and BTITLE commands, 4-26, 8-140
in TTITLE, BTITLE, REPHEADER and REPFOOTER commands, 4-24
used to place blank lines before bottom title, 4-27
SKIP PAGE clause, 4-13, 4-14, 8-24
Slash (/) command, 8-10
using with files loaded with GET command, 8-71
SPACE variable, F-5
SPOOL clause, 8-125
SPOOL command, 4-35, 8-129
disabling, E-5
file name, 4-35, 8-129
OFF clause, 4-35, 8-129
OUT clause, 4-36, 8-129
turning spooling off, 4-35, 8-129
SQL buffer, 2-10
SQL clause, 8-31
SQL commands, list of major, D-1
SQL database language, 1-2
SQL DML statements
reporting on, 8-103
SQL*Plus
basic concepts, 1-2
command prompt, 2-4
command summary, 8-2
database administration, 5-2
exiting, 2-4, 8-69
exiting conditionally, 8-150, 8-152
limits, C-1
LOGIN.SQL, 3-17
overview, 1-2
running commands in batch mode, 3-17, 8-70
setting up environment, 3-17
shortcuts to starting, 2-4
starting, 2-3, 7-2
what you need to run, 1-7
who can use, 1-3
SQLBLANKLINES variable, 8-111
SQLCASE variable, 8-112
SQLCODE clause, 8-125
SQLCONTINUE variable, 8-112
SQLNUMBER variable, 8-112
SQLPLUS command, 2-3, 7-2
- (hyphen) clause, 7-3
-? clause, 7-3
and @ ("at" sign), 3-15, 6-3, 7-2
and EXIT FAILURE, 7-4
connecting to a remote database, 6-3
display syntax, 7-3
/NOLOG clause, 7-3
running command files, 3-15
service name, 6-3, 6-4, 7-3
-SILENT clause, 7-2
unsuccessful connection, 7-4
username/password, 2-4, 7-2
SQL.PNO, referencing in report titles, 4-28
SQLPREFIX variable, 8-112
SQLPROMPT variable, 8-112
SQL.SQLCODE
using in EXIT command, 8-69
SQLTERMINATOR variable, 8-74, 8-112
STANDBY DATAFILE clause, 8-87
STANDBY TABLESPACE clause, 8-87
START clause, 8-16, 8-137
START command, 3-14, 8-130
arguments, 3-25, 8-130
command file, 3-14, 8-130
disabling, E-5
passing parameters to a command file, 3-25, 8-130
similar to @ ("at" sign) command, 3-15, 8-7, 8-131
similar to @@ (double "at" sign) command, 8-8, 8-131
Starting SQL*Plus, 2-3
shortcuts, 2-4
STARTUP command, 8-132
EXCLUSIVE clause, 8-133
FORCE clause, 8-132
MOUNT clause, 8-132
NOMOUNT clause, 8-133
OPEN clause, 8-132
PARALLEL clause, 8-133
PFILE clause, 8-132
RECOVER clause, 8-133
RESTRICT clause, 8-132
RETRY clause, 8-133
SHARED clause, 8-133
specifying a database, 8-133
Statistics, 3-35
STD function, 4-17
STOP clause, 8-16, 8-137
STORE command, 3-18, 8-136
SET clause, 8-136
Stored functions, 3-32
Stored procedures
creating, 2-9
Substitution variables, 3-20
appending characters immediately after, 3-23
avoiding unnecessary prompts for value, 3-23
concatenation character, 8-105
DEFINE command, 3-23, 8-54
prefixing, 8-105
restrictions, 3-25
single and double ampersands, 3-23
system variables used with, 3-25
undefined, 3-21
where and how to use, 3-21
SUFFIX variable, 8-112
used with @ ("at" sign) command, 8-6
used with EDIT command, 8-66
used with GET command, 8-71
used with SAVE command, 8-98
used with START command, 8-130
SUM function, 4-17
Summary lines
computing and printing, 4-16, 8-43
computing and printing at ends of reports, 4-20
computing same type on different columns, 4-21
printing "grand" and "sub" summaries (totals), 4-21
printing multiple on same break column, 4-21
Syntax
conventions, 1-4
COPY command, 6-5
Syntax rules
SQL commands, 2-7
SQL*Plus commands, 2-12
SYSDATE, 4-32
SYSDBA clause, 8-50
SYSOPER clause, 8-50
System variables, 2-13, 8-114
changing current settings, 8-100
listing current settings, 2-14, 8-123
listing old and new values, 8-111
storing and restoring, 3-18
used with substitution variables, 3-25
System-maintained values
displaying in headers and footers, 8-93
displaying in titles, 4-28, 8-139
formatting in titles, 4-29

T

TAB clause, 8-94, 8-140
TAB variable, 8-113
Tables, 1-2
access to sample, 1-8
controlling destination when copying, 6-6, 8-52
copying values between, 6-4, 6-9, 8-51
DEPT, 1-6
EMP, 1-6
listing column definitions, 2-16, 8-58
referring to another user's when copying, 6-8
sample, 1-5
TABLESPACE clause, 8-87
Tablespaces
recovering, 8-85
TERMOUT variable, 8-113
storing current date in variable for titles, 4-32
using with SPOOL command, 8-129
Text
adding to current line with APPEND, 3-6, 8-13
changing old to new with CHANGE, 3-4, 8-28
clearing from buffer, 3-2, 8-30
Text editor, host operating system, 3-7, 8-66
TIME clause
in LOGIN.SQL, 3-18
TIME variable, 8-113
TIMING clause, 8-31
TIMING command, 2-16, 8-137
deleting all areas created by, 8-31
deleting current area, 8-137
SHOW clause, 8-137
START clause, 8-137
STOP clause, 8-137
TIMING variable, 8-113
Titles
aligning elements, 4-26, 8-140
displaying at bottom of page, 4-23, 8-26
displaying at top of page, 4-23, 8-139
displaying column values, 4-30, 8-37, 8-38
displaying current date, 4-32, 8-37, 8-40
displaying page number, 4-28, 8-142
displaying system-maintained values, 4-28, 8-139
formatting elements, 8-141
formatting system-maintained values in, 4-29
indenting, 4-27, 8-140
listing current definition, 4-30, 8-26, 8-141
restoring definition, 4-30
setting at start or end of report, 4-23
setting lines from top of page to top title, 4-33, 8-109
setting lines from top title to end of page, 8-110
setting top and bottom, 4-23, 8-26, 8-139
spacing between last row and bottom title, 4-26
suppressing definition, 4-30, 8-140
TO clause, 6-5, 8-52
Tracing Statements, 3-35
for performance statistics, 3-37
for query execution path, 3-37
using a database link, 3-40
with parallel query option, 3-41
TRIMOUT variable, 8-113
TRIMSPOOL variable, 8-113
TRUNCATE command
disabling, E-6
TRUNCATE variable, F-6
TRUNCATED clause, 4-8, 8-38
TTITLE clause, 8-125
TTITLE command, 4-23, 8-139
aligning title elements, 4-26, 8-140
BOLD clause, 8-140
CENTER clause, 4-24, 4-26, 8-140
COL clause, 4-24, 4-27, 8-140
FORMAT clause, 4-29, 8-141
indenting titles, 4-27, 8-140
LEFT clause, 4-24, 4-26, 8-140
listing current definition, 4-30, 8-141
most often used clauses, 4-23
OFF clause, 4-30, 8-140
old form, F-7
ON clause, 4-30
referencing column value variable, 4-30, 8-37
restoring current definition, 4-30
RIGHT clause, 4-24, 4-26, 8-140
SKIP clause, 4-24, 4-26, 8-140
suppressing current definition, 4-30, 8-140
TAB clause, 8-140
Tuning, 3-35

U

UNDEFINE command, 3-20, 8-143
and DEFINE command, 8-54
UNDERLINE variable, 4-3, 8-113
UNTIL CANCEL clause, 8-86
UNTIL CHANGE clause, 8-86
UNTIL CONTROLFILE clause, 8-87
UNTIL TIME clause, 8-86
UPDATE command
disabling, E-6
USER clause, 8-125
User Profile, 3-17, 7-4
User variables, 3-19
defining, 3-19, 8-54
deleting, 3-20, 8-143
displaying in headers and footers, 8-93
displaying in titles, 8-139
in ACCEPT command, 3-27, 8-11
listing definition of one, 3-20, 8-54
listing definitions of all, 3-20, 8-54
Username, 1-7
connecting under different, 6-2, 8-49
in CONNECT command, 6-2, 6-3, 8-49
in COPY command, 6-5, 6-7, 6-9, 8-51
in SQLPLUS command, 2-4, 6-4, 7-2
USING BACKUP CONTROL FILE clause, 8-86
USING clause, 6-6, 8-52

V

V$SESSION virtual table, 8-102
V$SQLAREA virtual table, 8-102
VARCHAR columns
changing format, 4-7
default format, 4-6, 8-34
VARCHAR2 clause
VARIABLE command, 8-144
VARCHAR2 columns
changing format, 4-7, 8-34
default format, 4-6
VARIABLE command, 8-144
CHAR clause, 8-144
CLOB clause, 8-145
NCHAR clause, 8-144
NCLOB clause, 8-145
NUMBER clause, 8-144
REFCURSOR clause, 8-145
VARCHAR2 clause, 8-144
variable clause, 8-144
Variables
bind variables, 3-30
substitution variables, 3-20
system variables, 2-13
user variables, 8-54
VARIANCE function, 4-17
VERIFY clause, 3-21
VERIFY variable, 3-25, 8-114

W

WARNING clause, 8-69
WHENEVER OSERROR command, 8-150
COMMIT clause, 8-150
CONTINUE clause, 8-150
EXIT clause, 8-150
NONE clause, 8-150
ROLLBACK clause, 8-150
WHENEVER SQLERROR command, 3-17, 8-152
COMMIT clause, 8-152
CONTINUE clause, 8-152
EXIT clause, 8-152
NONE clause, 8-152
ROLLBACK clause, 8-152
WORD_WRAPPED clause, 4-8, 4-10, 8-38
WRAP variable, 4-8, 8-114
WRAPPED clause, 4-8, 8-38

Prev
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents