SQL*Plus User's Guide and Reference -- Index

-- (comment delimiter), 1

- (hyphen)

clause, 1

continuing a long SQL*Plus command, 1, 2

. (period), 1

/ (slash) command

default logon, 1, 2

entered at buffer line-number prompt, 1, 2

entered at command prompt, 1, 2

executing current PL/SQL block, 1

executing current SQL command, 1

similar to RUN, 1, 2, 3

usage, 1

# pound sign, 1

$ number format, 1

& (ampersand)

substitution variables, 1

&&, 1

* (asterisk)

in DEL command, 1, 2

in LIST command, 1, 2

/*...*/ (comment delimiters), 1

: (colon)

bind variables, 1

:BindVariable clause

EXIT command, 1

; (semicolon), 1

@ ("at" sign)

command, 1, 2, 3

command arguments, 1

command file, 1, 2

in CONNECT command, 1, 2

in COPY command, 1, 2

in SQLPLUS command, 1, 2, 3

passing parameters to a command file, 1

similar to START, 1, 2, 3

@@ (double "at" sign) command, 1, 2

command file, 1

similar to START, 1, 2

[Cancel] key, 1

_EDITOR, in EDIT command, 1, 2

~ infinity sign, 1

-~ negative infinity sign, 1

0, number format, 1

3 tier, 1

9, number format, 1

ABORT mode, 1

abort query, 1

ACCEPT command, 1, 2

and DEFINE command, 1

CHAR clause, 1

customizing prompts for value, 1

DATE clause, 1

DEFAULT clause, 1

FORMAT clause, 1

HIDE clause, 1

NOPROMPT clause, 1

NUMBER clause, 1

PROMPT clause, 1, 2

access, denying and granting, 1

ALIAS clause, 1

in ATTRIBUTE command, 1

ALL clause, 1

ALTER command

disabling, 1

ampersands (&)

in parameters, 1, 2, 3

substitution variables, 1

ANALYZE command

disabling, 1

APPEND clause

in COPY command, 1, 2

in SAVE command, 1, 2

APPEND command, 1, 2, 3

APPINFO clause, 1

ARCH background process, 1

ARCHIVE LOG

command, 1, 2

mode, 1

argument

in START command, 1, 2

ARRAYSIZE variable, 1

relationship to COPY command, 1, 2

attribute

display characteristics, 1

ATTRIBUTE command, 1

ALIAS clause, 1

and CLEAR COLUMN command, 1

CLEAR clause, 1

clearing columns, 1, 2

controlling display characteristics, 1

entering multiple, 1

FORMAT clause, 1

LIKE clause, 1

listing all attributes' display characteristics, 1

listing an attribute's display characteristics, 1

OFF clause, 1

ON clause, 1

restoring column display attributes, 1

suppressing column display attributes, 1

AUDIT command

disabling, 1

AUTOCOMMIT variable, 1, 2

AUTOMATIC clause, 1

AUTOPRINT variable, 1

AUTORECOVERY variable, 1

AUTOTRACE variable, 1, 2

AVG function, 1

background process

startup after abnormal termination, 1

batch mode, 1, 2

BEGIN command, 1

disabling, 1

bind variables, 1

creating, 1

displaying, 1

displaying automatically, 1, 2

in PL/SQL blocks, 1

in SQL statements, 1

in the COPY command, 1

REFCURSOR, 1

blank line

in PL/SQL blocks, 1

in SQL commands, 1

preserving in SQL commands, 1

blocks, PL/SQL, 1

continuing, 1

editing in buffer, 1

editing with host system editor, 1, 2

entering and executing, 1

listing current in buffer, 1

run from SQL buffer, 1

saving current, 1, 2

setting character used to end, 1

stored in SQL buffer, 1

storing in command files, 1

timing statistics, 1

within SQL commands, 1

BLOCKTERMINATOR, 1, 2, 3

BODY clause, 1

BODY option, 1

BOLD clause, 1, 2

break columns, 1, 2

inserting space when value changes, 1

specifying multiple, 1

suppressing duplicate values in, 1

BREAK command, 1, 2

and SQL ORDER BY clause, 1, 2, 3, 4

clearing BREAKS, 1

displaying column values in titles, 1

BREAK command (continued)

DUPLICATES clause, 1

inserting space after every row, 1

inserting space when break column changes, 1

listing current break definition, 1, 2

ON column clause, 1, 2

ON expr clause, 1

ON REPORT clause, 1, 2

ON ROW clause, 1, 2

printing "grand" and "sub" summaries, 1

printing summary lines at ends of reports, 1

removing definition, 1

SKIP clause, 1, 2

SKIP PAGE clause, 1, 2, 3

specifying multiple break columns, 1, 2

storing current date in variable for titles, 1

suppressing duplicate values, 1

used in conjunction with COMPUTE, 1, 2, 3, 4

used in conjunction with SET COLSEP, 1

used to format a REFCURSOR variable, 1

break definition

listing current, 1, 2

removing current, 1, 2

BREAKS clause, 1, 2

browser, web, 1

BTITLE clause, 1

BTITLE command, 1, 2

aligning title elements, 1

BOLD clause, 1

CENTER clause, 1

COL clause, 1

FORMAT clause, 1

indenting titles, 1

LEFT clause, 1

OFF clause, 1

old form, 1

printing blank lines before bottom title, 1

referencing column value variable, 1

RIGHT clause, 1

SKIP clause, 1

suppressing current definition, 1

TAB clause, 1

TTITLE command, 1

buffer, 1

appending text to a line in, 1, 2

delete a single line, 1

delete the current line, 1

delete the last line, 1

deleting a range of lines, 1, 2

deleting a single line, 1

deleting all lines, 1, 2, 3

deleting lines from, 1, 2

deleting the current line, 1

deleting the last line, 1

executing contents, 1, 2, 3

inserting new line in, 1, 2

listing a range of lines, 1, 2

listing a single line, 1, 2

listing all lines, 1, 2

listing contents, 1, 2

listing the current line, 1, 2

listing the last line, 1, 2

loading into host system editor, 1, 2

saving contents, 1, 2

BUFFER clause, 1, 2, 3

BUFFER variable, 1

CANCEL clause, 1, 2

cancel query, 1

CENTER clause, 1, 2, 3

CHANGE command, 1, 2, 3

CHAR clause, 1

VARIABLE command, 1

CHAR columns

changing format, 1, 2

default format, 1, 2

CLEAR clause, 1, 2

in ATTRIBUTE command, 1

CLEAR command, 1

BREAKS clause, 1, 2

BUFFER clause, 1, 2, 3

COLUMNS clause, 1, 2

COMPUTES clause, 1

SCREEN clause, 1, 2

SQL clause, 1

TIMING clause, 1

CLOB clause

VARIABLE command, 1

CLOB columns

changing format, 1, 2

default format, 1

setting maximum width, 1

setting retrieval position, 1

setting retrieval size, 1

CLOSECURSOR variable, 1, 2

CMDSEP variable, 1

COL clause, 1, 2, 3

colons (:)

bind variables, 1

COLSEP variable, 1

COLUMN command, 1, 2

ALIAS clause, 1

and BREAK command, 1

and DEFINE command, 1

CLEAR clause, 1, 2

DEFAULT clause, 1

displaying column values in bottom titles, 1, 2

displaying column values in top titles, 1, 2

entering multiple, 1

ENTMAP clause, 1

FOLD_AFTER clause, 1, 2

FOLD_BEFORE clause, 1

FORMAT clause, 1, 2, 3

formatting columns, 1

formatting NUMBER columns, 1, 2

HEADING clause, 1, 2

HEADSEP character, 1

JUSTIFY clause, 1

LIKE clause, 1, 2

listing column display attributes, 1, 2

NEW_VALUE clause, 1, 2, 3

NEWLINE clause, 1

NOPRINT clause, 1, 2

NULL clause, 1

OFF clause, 1, 2

OLD_VALUE clause, 1, 2

ON clause, 1, 2

PRINT clause, 1

resetting to default display, 1, 2, 3

restoring column display attributes, 1, 2

storing current date in variable for titles, 1, 2

suppressing column display attributes, 1, 2

TRUNCATED clause, 1, 2

used to format a REFCURSOR variable, 1

WORD_WRAPPED clause, 1, 2, 3

WRAPPED clause, 1, 2

column headings

aligning, 1

changing, 1, 2

changing character used to underline, 1, 2

changing to two or more words, 1, 2

displaying on more than one line, 1, 2

suppressing printing in a report, 1

when truncated, 1

when truncated for CHAR and LONG columns, 1

when truncated for DATE columns, 1

when truncated for NUMBER columns, 1

column separator, 1, 2

columns

assigning aliases, 1

computing summary lines, 1, 2

copying display attributes, 1, 2, 3

copying values between tables, 1, 2, 3

displaying values in bottom titles, 1, 2

displaying values in top titles, 1, 2

formatting CHAR, VARCHAR, LONG, and DATE, 1

formatting in reports, 1, 2

formatting MLSLABEL, RAW MLSLABEL, ROWLABEL, 1

formatting NUMBER, 1, 2

listing display attributes for all, 1, 2

listing display attributes for one, 1, 2

names in destination table when copying, 1, 2

printing line after values that overflow, 1, 2

resetting a column to default display, 1, 2, 3

resetting all columns to default display, 1, 2

restoring display attributes, 1, 2, 3

columns (continued)

setting printing to off or on, 1, 2

starting new lines, 1

storing values in variables, 1, 2

suppressing display attributes, 1, 2, 3

truncating display for all when value overflows, 1, 2

truncating display for one when value overflows, 1, 2

wrapping display for all when value overflows, 1, 2

wrapping display for one when value overflows, 1, 2

wrapping whole words for one, 1

COLUMNS clause, 1, 2

comma, number format, 1

command file extension, 1, 2, 3

command files, 1

aborting and exiting with a return code, 1, 2, 3

allowing end-user input, 1

creating with a system editor, 1

creating with INPUT and SAVE, 1

creating with SAVE, 1, 2

editing with GET and SAVE, 1

editing with host system editor, 1, 2

in @ ("at" sign) command, 1, 2

in @@ (double "at" sign) command, 1

in EDIT command, 1, 2

in GET command, 1, 2

in SAVE command, 1, 2, 3

in SQLPLUS command, 1, 2

in START command, 1, 2

including comments in, 1, 2

including more than one PL/SQL block, 1

including more than one SQL command, 1

listing names with HOST command, 1

nesting, 1

passing parameters to, 1, 2, 3

registering, 1

retrieving, 1, 2

running, 1, 2, 3

running a series in sequence, 1

running as you start SQL*Plus, 1, 2

running in batch mode, 1, 2

running nested, 1

saving contents of buffer in, 1, 2

uniform resource identifier, 1, 2, 3

command prompt

host operating system, 1

SET SQLPROMPT, 1

SQL*Plus, 1

commands, 1

collecting timing statistics on, 1, 2

disabling, 1

host, running from SQL*Plus, 1, 2

listing current in buffer, 1

re-enabling, 1

spaces, 1

SQL

continuing on additional lines, 1

editing in buffer, 1

editing with host system editor, 1, 2

ending, 1

entering and executing, 1

entering without executing, 1

executing current, 1, 2, 3

following syntax, 1

list of major, 1

listing current in buffer, 1

saving current, 1, 2

setting character used to end and run, 1

SQL*Plus

abbreviations, 1

command summary, 1

continuing on additional lines, 1, 2

editing at command prompt, 1

ending, 1, 2

entering and executing, 1

entering during SQL command entry, 1

obsolete command alternatives, 1

stopping while running, 1

storing in command files, 1

tabs, 1

types of, 1

variables that affect running, 1

writing interactive, 1

comments

including in command files, 1, 2, 3

using -- to create, 1

comments (continued)

using /*...*/ to create, 1

using REMARK to create, 1, 2, 3

COMMIT clause, 1

WHENEVER OSERROR, 1

WHENEVER SQLERROR, 1

COMMIT command, 1

COMPATIBILITY variable, 1

COMPUTE command, 1, 2

AVG function, 1

computing a summary on different columns, 1

COUNT function, 1

LABEL clause, 1, 2, 3

listing all definitions, 1, 2

MAXIMUM function, 1

maximum LABEL length, 1

MINIMUM function, 1

NUMBER function, 1

OF clause, 1

ON column clause, 1, 2

ON expr clause, 1

ON REPORT clause, 1, 2

ON ROW clause, 1

printing "grand" and "sub" summaries, 1

printing multiple summaries on same column, 1

printing summary lines at ends of reports, 1

printing summary lines on a break, 1

referencing a SELECT expression in OF, 1

referencing a SELECT expression in ON, 1

removing definitions, 1, 2

STD function, 1

SUM function, 1

used to format a REFCURSOR variable, 1

VARIANCE function, 1

COMPUTES clause, 1

CONCAT variable, 1, 2

CONNECT command, 1, 2, 3

and @ ("at" sign), 1, 2

changing password, 1, 2, 3

connect identifier, 1

service name, 1

SYSDBA clause, 1, 2

SYSOPER clause, 1, 2

username/password, 1, 2, 3, 4

CONNECT command (SQL)

disabling, 1

connect identifier, 1, 2

in CONNECT command, 1

in COPY command, 1

in DESCRIBE command, 1

in SQLPLUS command, 1

CONTINUE clause

WHENEVER OSERROR, 1

WHENEVER SQLERROR, 1

continuing a long SQL*Plus command, 1, 2

COPY command, 1, 2

and @ ("at" sign), 1, 2

and ARRAYSIZE variable, 1, 2

and COPYCOMMIT variable, 1, 2

and LONG variable, 1, 2

APPEND clause, 1, 2

copying data between databases, 1

copying data between tables on one database, 1

CREATE clause, 1, 2

creating a table, 1, 2

destination table, 1, 2

determining actions, 1

determining source rows and columns, 1, 2

disabling, 1

FROM clause, 1, 2

INSERT clause, 1, 2

inserting data in a table, 1, 2

interpreting messages, 1

mandatory connect identifier, 1

naming the source table with SELECT, 1, 2

query, 1, 2

referring to another user's table, 1

REPLACE clause, 1, 2

replacing data in a table, 1, 2

sample command, 1, 2

service name, 1, 2, 3

specifying columns for destination, 1, 2

specifying the data to copy, 1, 2

TO clause, 1, 2

username/password, 1, 2, 3, 4

USING clause, 1, 2

when a commit is performed, 1

COPYCOMMIT variable, 1

relationship to COPY command, 1, 2

COPYTYPECHECK variable, 1

COUNT function, 1

CREATE clause

in COPY command, 1, 2

CREATE command

disabling, 1

entering PL/SQL, 1

creating flat files, 1

creating the PRODUCT_USER_PROFILE table, 1

cursor variables, 1

database

connect identifier, 1

mounting, 1

opening, 1

database administrator, 1, 2

database changes, saving automatically, 1, 2

DATABASE clause, 1

database files

recovering, 1

database name at startup, 1

databases

connecting to default, 1, 2

connecting to remote, 1, 2

copying data between, 1, 2

copying data between tables on a single, 1

disconnecting without leaving SQL*Plus, 1, 2

mounting, 1

opening, 1

recovering, 1, 2

shutting down, 1, 2

starting, 1

DATAFILE clause, 1

DATE clause, 1

DATE columns

changing format, 1, 2, 3

default format, 1

date, storing current in variable for titles, 1, 2, 3

DB2, 1

DBA, 1

DBA mode, 1

DBA privilege, 1

DBMS_APPLICATION_INFO package, 1

DECLARE command

disabling, 1

DECLARE command (PL/SQL), 1

DEFAULT clause, 1

default logins

created at installation, 1

DEFINE command, 1, 2

and host system editor, 1, 2

and UNDEFINE command, 1, 2

CHAR values, 1

SET DEFINE ON|OFF, 1

substitution variables, 1, 2

DEFINE variable, 1, 2

DEL command, 1, 2, 3

using an asterisk, 1, 2

DELETE command

disabling, 1

DESCRIBE command (SQL*Plus), 1, 2

connect_identifier, 1

PL/SQL properties listed by, 1

table properties listed by, 1

DISABLED keyword, disabling commands, 1

disabling

PL/SQL commands, 1

SQL commands, 1

SQL*Plus commands, 1

DISCONNECT command, 1, 2

DOCUMENT command

obsolete commands

DOCUMENT, 1, 2

REMARK as newer version of, 1

DOCUMENT variable, 1, 2

DROP command

disabling, 1

DUPLICATES clause, 1

dynamic reports, 1

ECHO variable, 1, 2

EDIT command, 1, 2

creating command files with, 1

defining _EDITOR, 1, 2

disabling, 1

modifying command files, 1, 2

setting default file name, 1

EDITFILE variable, 1

EMBEDDED variable, 1

EMP table, 1

empty line, displaying, 1

Enhancement list, Release 8.1, 1

entities, HTML, 1

ENTMAP, 1

ENTMAP clause, 1, 2, 3

error messages, interpreting, 1

errors, making line containing current, 1

escape characters, definition of, 1

ESCAPE variable, 1, 2

example

embedded CGI report, 1

interactive HTML report, 1, 2

EXECUTE command, 1

disabling, 1

executing

a CREATE command, 1

execution statistics

including in report, 1

EXIT clause

WHENEVER OSERROR, 1

WHENEVER SQLERROR, 1

EXIT command, 1, 2

:BindVariable clause, 1

COMMIT clause, 1

disabling, 1

FAILURE clause, 1

in a command file, 1

ROLLBACK clause, 1

use with SET MARKUP, 1

WARNING clause, 1

exit, conditional, 1, 2

extension, 1, 2, 3

FAILURE clause, 1

FEEDBACK variable, 1

file extension, 1, 2, 3

file extensions, 1

file names

in @ ("at" sign) command, 1

in @@ (double "at" sign) command, 1

in EDIT command, 1

in GET command, 1

in SAVE command, 1, 2

in SPOOL command, 1, 2

in SQLPLUS command, 1

in START command, 1

files

command files, 1

flat, 1

FLAGGER variable, 1

flat file, 1

FLUSH variable, 1

FOLD_AFTER clause, 1

FOLD_BEFORE clause, 1

footers

aligning elements, 1

displaying at bottom of page, 1

displaying system-maintained values, 1

formatting elements, 1

indenting, 1

listing current definition, 1

setting at the end of reports, 1

suppressing definition, 1

FORCE clause, 1

FORMAT clause, 1, 2

in ATTRIBUTE command, 1

in COLUMN command, 1, 2

in REPHEADER and REPFOOTER commands, 1

in TTITLE and BTITLE commands, 1, 2

format models, number, 1, 2

formfeed, to begin a new page, 1, 2

FROM clause, 1

FROM clause (SQL*Plus), 1, 2

GET command, 1, 2

disabling, 1

LIST clause, 1

modifying command files, 1

NOLIST clause, 1

retrieving command files, 1, 2

GLOGIN.SQL, 1, 2, 3, 4

1

GRANT command, 1

disabling, 1

HEAD clause, 1

HEAD option, 1

headers

aligning elements, 1

displaying at top of page, 1

displaying system-maintained values, 1

setting at the start of reports, 1

suppressing, 1

HEADING clause, 1, 2

HEADING variable, 1

headings

aligning elements, 1

column headings, 1

formatting elements, 1

indenting, 1

listing current definition, 1

suppressing definition, 1

HEADSEP variable, 1

use in COLUMN command, 1, 2

HELP command, 1

help, online, 1, 2, 3

HIDE clause, 1

HOST command, 1, 2

disabling, 1

listing command file names with, 1

host operating system

command prompt, 1

editor, 1, 2

file, loading into buffer, 1

running commands from SQL*Plus, 1, 2

HTML, 1

clause, 1

entities, 1

option, 1

spooling to file, 1

tag, 1

hyphen

continuing a long SQL*Plus command, 1, 2

IMMEDIATE mode, 1

infinity sign (~), 1

initialization parameters

displaying, 1

INIT.ORA file

parameter file, 1

input

accepting [Return], 1, 2

accepting values from the user, 1, 2

INPUT command, 1, 2, 3

entering several lines, 1

using with SAVE to create command files, 1

INSERT clause, 1, 2

INSERT command

disabling, 1

installation

default users created, 1

INSTANCE variable, 1

instances

shutting down, 1

starting, 1

iSQL*Plus, 1

JUSTIFY clause, 1

LABEL variable

SHOW command, 1, 2

labels

in COMPUTE command, 1, 2

LEFT clause, 1, 2, 3

LIKE clause, 1, 2, 3

limits, SQL*Plus, 1

line numbers, for SQL commands, 1

lines

adding at beginning of buffer, 1

adding at end of buffer, 1

adding new after current, 1, 2

appending text to, 1, 2

changing width, 1, 2

deleting all in buffer, 1

deleting from buffer, 1, 2

determining which is current, 1

editing current, 1

listing all in buffer, 1, 2

removing blanks at end, 1

LINESIZE variable, 1, 2, 3

LIST clause, 1, 2

LIST command, 1, 2

determining current line, 1, 2

making last line current, 1, 2

using an asterisk, 1, 2

LNO clause, 1

LOBOFFSET variable, 1

LOCK TABLE command

disabling, 1

LOG_ARCHIVE_DEST parameter, 1

LOGFILE clause, 1

logging off

conditionally, 1, 2

Oracle, 1, 2

SQL*Plus, 1, 2

logging on

default users created at installation, 1

Oracle, 1, 2, 3

SQL*Plus, 1

LOGIN.SQL, 1, 2

including SET commands, 1

sample commands to include, 1

1

storing current date in variable for titles, 1

LONG columns

changing format, 1, 2

default format, 1

setting maximum width, 1

setting retrieval size, 1

LONG variable, 1

effect on COPY command, 1, 2

LONGCHUNKSIZE variable, 1, 2, 3, 4

-MARKUP, 1, 2

SPOOL clause, 1

SQLPLUS command clause, 1

MARKUP, 1, 2, 3

BODY clause, 1

ENTMAP clause, 1

example, 1

HEAD clause, 1

PREFORMAT clause, 1

SPOOL clause, 1

TABLE clause, 1

MAXDATA variable, 1, 2

MAXIMUM function, 1

media recovery, 1

message, sending to screen, 1, 2

MINIMUM function, 1

MOUNT clause, 1

mounting a database, 1

NCHAR clause

VARIABLE command, 1

NCHAR columns

changing format, 1, 2

default format, 1, 2

NCLOB clause

VARIABLE command, 1

NCLOB columns

changing format, 1, 2

default format, 1

setting maximum width, 1

setting retrieval position, 1

setting retrieval size, 1

negative infinity sign (-~), 1

NEW_VALUE clause, 1, 2

storing current date in variable for titles, 1, 2

NEWLINE clause, 1

NEWPAGE command, 1, 2

NEWPAGE variable, 1, 2

NEXT clause, 1

NLS_DATE_FORMAT, 1, 2

NOAUDIT command

disabling, 1

NOLIST clause, 1

NOLOG, 1

/NOLOG option, 1

NOMOUNT clause, 1

NONE clause

WHENEVER OSERROR, 1

WHENEVER SQLERROR, 1

NOPRINT clause, 1, 2, 3

NOPROMPT clause, 1

NORMAL mode, 1

NULL clause, 1

null values

setting text displayed, 1, 2

NULL variable, 1

NUMBER clause, 1, 2

VARIABLE command, 1

NUMBER columns

changing format, 1, 2

default format, 1, 2

number formats

$, 1

0, 1

9, 1

comma, 1

setting default, 1

NUMBER function, 1

NUMFORMAT clause

in LOGIN.SQL, 1

NUMFORMAT variable, 1

NUMWIDTH variable, 1

effect on NUMBER column format, 1, 2

NVARCHAR2 columns

changing format, 1, 2

default format, 1, 2

objects, describing, 1

obsolete commands

BTITLE, 1

COLUMN command DEFAULT clause, 1

NEWPAGE, 1, 2

SET command BUFFER variable, 1

SET command CLOSECURSOR variable, 1, 2

SET command DOCUMENT variable, 1, 2

SET command MAXDATA variable, 1, 2

SET command SCAN variable, 1, 2

SET command SPACE variable, 1, 2

SET command TRUNCATE variable, 1, 2

SHOW command LABEL variable, 1, 2

TTITLE command old form, 1

OF clause, 1

OFF clause, 1

in ATTRIBUTE command, 1

in COLUMN command, 1, 2

in REPFOOTER commands, 1

in REPHEADER commands, 1

in SPOOL command, 1, 2

in TTITLE and BTITLE commands, 1, 2

OLD_VALUE clause, 1, 2

ON clause

in ATTRIBUTE command, 1

in COLUMN command, 1, 2

in TTITLE and BTITLE commands, 1

ON column clause

in BREAK command, 1, 2

in COMPUTE command, 1, 2

ON expr clause

in BREAK command, 1

in COMPUTE command, 1

ON REPORT clause

in BREAK command, 1, 2

in COMPUTE command, 1, 2

ON ROW clause

in BREAK command, 1, 2

in COMPUTE command, 1

online help, 1, 2, 3

OPEN clause, 1

opening a database, 1

Oracle Net

connect identifier, 1

protocol, 1

ORDER BY clause

displaying column values in titles, 1

displaying values together in output, 1

OUT clause, 1, 2

output

formatting white space in, 1

pausing during display, 1, 2

query results, 1

PAGE clause, 1

page number, including in titles, 1, 2

pages

changing length, 1, 2

default dimensions, 1

matching to screen or paper size, 1

setting dimensions, 1

PAGESIZE variable, 1, 2, 3

PAGESIZEclause

in LOGIN.SQL, 1

parameter files (INIT.ORA files)

specifying alternate, 1

parameters, 1, 2, 3

PARAMETERS clause, 1

password, 1

changing with the PASSWORD command, 1

in CONNECT command, 1, 2, 3

in COPY command, 1, 2, 3

in SQLPLUS command, 1, 2, 3

PASSWORD command, 1, 2

disabling, 1

PAUSE command, 1, 2

in LOGIN.SQL, 1

PAUSE variable, 1, 2

performance

of SQL statements, 1

performance, over dial-up lines, 1

Period (.)

terminating PL/SQL blocks, 1

period (.)

terminating PL/SQL blocks, 1

PLAN_TABLE table, 1

PL/SQL, 1, 2

blocks, PL/SQL, 1

executing, 1

formatting output in SQL*Plus, 1

listing definitions, 1

mode in SQL*Plus, 1

within SQL commands, 1

PLUSTRACE role, 1

PNO clause, 1

pound sign (#), 1

PREFORMAT, 1

PREFORMAT clause, 1

PRINT clause, 1

PRINT command, 1

printing

bind variables automatically, 1

REFCURSOR variables, 1

SPOOL command, 1

PRODUCT_USER_PROFILE table, 1

prompt

SET SQLPROMPT, 1

PROMPT clause, 1, 2

PROMPT command, 1, 2

customizing prompts for value, 1

prompts for value

bypassing with parameters, 1

customizing, 1

through ACCEPT, 1

through substitution variables, 1

PUPBLD.SQL, 1

queries, 1

in COPY command, 1, 2

show number of records retrieved, 1, 2

query execution path

including in report, 1

query results, 1

displaying on-screen, 1

sending to a printer, 1, 2

storing in a file, 1, 2

QUIT command, 1

1

record separators, printing, 1, 2

RECOVER

clause, 1

RECOVER command, 1

AUTOMATIC clause, 1

CANCEL clause, 1, 2

CONTINUE clause, 1

DATABASE clause, 1

FROM clause, 1

LOGFILE clause, 1

STANDBY DATABASE clause, 1

STANDBY DATAFILE clause, 1

STANDBY TABLESPACE clause, 1, 2

UNTIL CANCEL clause, 1

UNTIL CONTROLFILE clause, 1

UNTIL TIME clause, 1

USING BACKUP CONTROL FILE clause, 1

recovery

RECOVER command, 1

RECOVERY command

and database recovery, 1

RECSEP variable, 1, 2

RECSEPCHAR variable, 1, 2

redo Log Files

ARCHIVE LOG command, 1

REFCURSOR bind variables, 1

in a stored function, 1

REFCURSOR clause

VARIABLE command, 1

RELEASE clause, 1

REMARK command, 1, 2

RENAME command

disabling, 1

REPFOOTER clause, 1

REPFOOTER command, 1, 2

aligning footer elements, 1

BOLD clause, 1

CENTER clause, 1

COL clause, 1

FORMAT clause, 1

indenting report footers, 1

LEFT clause, 1

OFF clause, 1

RIGHT clause, 1

SKIP clause, 1

suppressing current definition, 1

TAB clause, 1

REPHEADER clause, 1

REPHEADER command, 1, 2

aligning header elements, 1

aligning heading elements, 1

BOLD clause, 1

CENTER clause, 1

COL clause, 1

FORMAT clause, 1

indenting headings, 1

LEFT clause, 1

OFF clause, 1

PAGE clause, 1

RIGHT clause, 1

SKIP clause, 1

suppressing current definition, 1

TAB clause, 1

REPLACE clause

in COPY command, 1, 2

in SAVE command, 1, 2

report

breaks, 1

title, 1

reports, 1

clarifying with spacing and summary lines, 1

columns, 1

creating bottom titles, 1, 2, 3

creating footers, 1

creating headers, 1

creating headers and footers, 1

creating master/detail, 1, 2

creating top titles, 1, 2, 3

displaying, 1

dynamic, 1

embedded CGI example, 1

formatting column headings, 1, 2

formatting columns, 1, 2, 3

interactive HTML example, 1, 2

on the web, 1

SILENT mode, 1

starting on a new page, 1

title, 1

RESTRICT, 1, 2, 3

return code, specifying, 1, 2, 3

REVOKE command, 1

disabling, 1

RIGHT clause, 1, 2, 3

roles, 1

disabling, 1

re-enabling, 1

ROLLBACK clause, 1

WHENEVER OSERROR, 1

WHENEVER SQLERROR, 1

rows

performing computations on, 1, 2

setting number retrieved at one time, 1

setting the number after which COPY commits, 1

RUN command, 1, 2

disabling, 1

executing current PL/SQL block, 1

executing current SQL command or PL/SQL block, 1

making last line current, 1

similar to / (slash) command, 1, 2

sample tables

access to, 1

SAVE command, 1, 2

APPEND clause, 1, 2

CREATE clause, 1

disabling, 1

modifying command files, 1

REPLACE clause, 1, 2

storing commands in command files, 1, 2

using with INPUT to create command files, 1

saving environment attributes, 1

SCAN variable, 1, 2

SCREEN clause, 1, 2

screen, clearing, 1, 2

Security

RESTRICT, 1, 2

security

changing password, 1

embedded web reports, 1

PRODUCT_USER_PROFILE table, 1

SELECT command

and BREAK command, 1, 2, 3

and COLUMN command, 1

and COMPUTE command, 1

and COPY command, 1, 2

and DEFINE command, 1

and ORDER BY clause, 1

disabling, 1

storing current date in variable for titles, 1

SELECT statement

formatting results, 1

semicolon (;)

in PL/SQL blocks, 1

in SQL commands, 1, 2

in SQL*Plus commands, 1, 2

not needed when inputting a command file, 1

not stored in buffer, 1

SERVEROUTPUT variable, 1

service Name

in COPY command, 1

service name

in CONNECT command, 1

in COPY command, 1, 2

in SQLPLUS command, 1

SET AUTOTRACE, 1

SET clause, 1

SET command, 1, 2, 3

APPINFO variable, 1

ARRAYSIZE variable, 1, 2

AUTOCOMMIT variable, 1, 2

AUTOPRINT variable, 1, 2

AUTORECOVERY variable, 1

AUTOTRACE variable, 1

BLOCKTERMINATOR variable, 1

BUFFER variable, 1

CLOSECURSOR variable, 1, 2

CMDSEP variable, 1

COLSEP variable, 1, 2

COMPATIBILITY variable, 1

CONCAT variable, 1, 2

COPYCOMMIT variable, 1, 2

COPYTYPECHECK variable, 1

DEFINE clause, 1

SET command (continued)

DEFINE variable, 1

DESCRIBE variable, 1

disabling, 1

DOCUMENT variable, 1, 2

ECHO variable, 1, 2

EDITFILE variable, 1

EMBEDDED variable, 1

ESCAPE variable, 1, 2

FEEDBACK variable, 1

FLAGGER variable, 1

FLUSH variable, 1

HEADING variable, 1

HEADSEP variable, 1, 2

INSTANCE variable, 1

LINESIZE variable, 1, 2, 3

LOBOFFSET variable, 1

LOGSOURCE variable, 1

LONG variable, 1, 2

LONGCHUNKSIZE variable, 1

MARKUP clause, 1

MAXDATA variable, 1, 2

NEWPAGE variable, 1, 2

NULL variable, 1

NUMFORMAT clause, 1

NUMFORMAT variable, 1

NUMWIDTH variable, 1, 2, 3

PAGESIZE clause, 1

PAGESIZE variable, 1, 2, 3

PAUSE clause, 1

PAUSE variable, 1, 2

RECSEP variable, 1, 2

RECSEPCHAR variable, 1, 2

SCAN variable, 1, 2

SERVEROUTPUT variable, 1

SHIFTINOUT variable, 1

SPACE variable, 1, 2

SQLBLANKLINES variable, 1

SQLCASE variable, 1

SQLCONTINUE variable, 1

SQLNUMBER variable, 1

SQLPLUSCOMPATIBILITY variable, 1, 2

SQLPREFIX variable, 1

SQLPROMPT variable, 1

SQLTERMINATOR variable, 1

SUFFIX variable, 1

TAB variable, 1

TERMOUT variable, 1, 2

TIME clause, 1

TIME variable, 1

TIMING variable, 1

TRIMOUT variable, 1

TRIMSPOOL variable, 1

TRUNCATE variable, 1, 2

UNDERLINE variable, 1, 2

used to format a REFCURSOR variable, 1

VERIFY clause, 1

VERIFY variable, 1, 2

WRAP variable, 1, 2

SET command variables

system variables, 1

SET MARKUP

BODY clause, 1

embedded CGI example, 1

ENTMAP clause, 1, 2

HEAD clause, 1

HTML, 1

interactive HTML example, 1, 2

PREFORMAT clause, 1

1

SPOOL clause, 1

TABLE clause, 1

SET ROLE command

disabling, 1

SET TRANSACTION command

disabling, 1

SGA clause, 1

SHIFTINOUT variable, 1

SHOW clause, 1

SHOW command, 1, 2

ALL clause, 1

BTITLE clause, 1

ERRORS clause, 1

LABEL variable, 1, 2

listing current page dimensions, 1

LNO clause, 1

PNO clause, 1

RELEASE clause, 1

REPFOOTER clause, 1

REPHEADER clause, 1

SHOW command (continued)

SPOOL clause, 1

SQLCODE clause, 1

TTITLE clause, 1

USER clause, 1

SHOWMODE variable, 1

SHUTDOWN command, 1

ABORT, 1

IMMEDIATE, 1

NORMAL, 1

-SILENT option, 1, 2

site profile

GLOGIN.SQL, 1

LOGIN.SQL, 1

1

SKIP clause

in BREAK command, 1, 2, 3

in REPHEADER and REPFOOTER commands, 1

in TTITLE and BTITLE commands, 1, 2

used to place blank lines before bottom title, 1

SKIP PAGE clause, 1, 2, 3

slash (/) command, 1

using with files loaded with GET command, 1

SPACE variable, 1, 2

SPOOL clause, 1, 2, 3

SPOOL command, 1, 2

disabling, 1

file name, 1, 2

OFF clause, 1, 2

OUT clause, 1, 2

to HTML file, 1

turning spooling off, 1, 2

use with SET MARKUP, 1

SQL buffer, 1

SQL clause, 1

SQL commands, list of major, 1

SQL database language, 1

SQL DML statements

reporting on, 1

SQL*Plus

basic concepts, 1

command prompt, 1

command summary, 1

database administration, 1

exiting, 1, 2

exiting conditionally, 1, 2

limits, 1

LOGIN.SQL, 1

obsolete command alternatives, 1

overview, 1

running commands in batch mode, 1, 2

setting up environment, 1

shortcuts to starting, 1

starting, 1, 2

what you need to run, 1

who can use, 1

SQLBLANKLINES variable, 1

SQLCASE variable, 1

SQLCODE clause, 1

SHOW command, 1

SQLCONTINUE variable, 1

SQLNUMBER variable, 1, 2

SQLPLUS command, 1, 2

- clause, 1

-? clause, 1

and @ ("at" sign), 1, 2, 3

and EXIT FAILURE, 1

BODY option, 1

connect identifier, 1

connecting to a remote database, 1

display syntax, 1

ENTMAP option, 1

HEAD option, 1

HTML option, 1

-MARKUP clause, 1

-MARKUP option, 1

-MARKUP SPOOL clause, 1

/NOLOG clause, 1

PREFORMAT option, 1

RESTRICT, 1, 2

running command files, 1

service name, 1, 2

-SILENT clause, 1

-SILENT option, 1, 2

SPOOL clause, 1

syntax, 1

SYSDBA clause, 1

SQLPLUS command (continued)

TABLE option, 1

unsuccessful connection, 1

username/password, 1, 2

SQL.PNO, referencing in report titles, 1

SQLPREFIX variable, 1

SQLPROMPT variable, 1

SQL.SQLCODE

using in EXIT command, 1

SQLTERMINATOR, 1

SQLTERMINATOR variable, 1, 2

STANDBY DATAFILE clause, 1

STANDBY TABLESPACE clause, 1

START clause, 1, 2

START command, 1, 2

arguments, 1, 2

command file, 1, 2

disabling, 1

passing parameters to a command file, 1, 2

similar to @ ("at" sign) command, 1, 2, 3

similar to @@ (double "at" sign) command, 1, 2

starting SQL*Plus, 1

shortcuts, 1

STARTUP command, 1

FORCE clause, 1

MOUNT clause, 1

NOMOUNT clause, 1

OPEN clause, 1

PFILE clause, 1

RECOVER clause, 1

RESTRICT clause, 1

specifying a database, 1

statistics, 1

STD function, 1

STOP clause, 1, 2

stop query, 1

STORE command, 1, 2

SET clause, 1

stored functions, 1

stored procedures

creating, 1

substitution variables, 1

appending characters immediately after, 1

avoiding unnecessary prompts for value, 1

concatenation character, 1

DEFINE command, 1, 2

defined, 1

prefixing, 1, 2

restrictions, 1

single and double ampersands, 1

system variables used with, 1

undefined, 1

where and how to use, 1

SUFFIX variable, 1

used with @ ("at" sign) command, 1

used with EDIT command, 1

used with GET command, 1

used with SAVE command, 1

used with START command, 1

SUM function, 1

summary lines

computing and printing, 1, 2

computing and printing at ends of reports, 1

computing same type on different columns, 1

printing "grand" and "sub" summaries (totals), 1

printing multiple on same break column, 1

syntax

COPY command, 1

syntax rules

SQL commands, 1

SQL*Plus commands, 1

SYSDATE, 1

SYSDBA clause, 1

SYSOPER clause, 1, 2

system variables, 1, 2

changing current settings, 1

listing current settings, 1, 2

listing old and new values, 1

storing and restoring, 1

used with substitution variables, 1

system-maintained values

displaying in headers and footers, 1

displaying in titles, 1, 2

formatting in titles, 1

TAB clause, 1, 2

TAB variable, 1

TABLE clause, 1

TABLE option, 1

tables, 1

access to sample, 1

controlling destination when copying, 1, 2

copying values between, 1, 2, 3

listing column definitions, 1, 2

referring to another user's when copying, 1

TABLESPACE clause, 1

tablespaces

recovering, 1

tag, HTML, 1

TERMOUT variable, 1

storing current date in variable for titles, 1

using with SPOOL command, 1

text, 1

adding to current line with APPEND, 1, 2

changing old to new with CHANGE, 1, 2

clearing from buffer, 1, 2

text editor, host operating system, 1, 2

three-tier architecture, 1

TIME clause

in LOGIN.SQL, 1

TIME variable, 1

TIMING clause, 1

TIMING command, 1, 2

deleting all areas created by, 1

deleting current area, 1

SHOW clause, 1

START clause, 1

STOP clause, 1

TIMING variable, 1

titles

aligning elements, 1, 2

displaying at bottom of page, 1, 2, 3

displaying at top of page, 1, 2, 3

displaying column values, 1, 2, 3

displaying current date, 1, 2, 3

displaying page number, 1, 2

displaying system-maintained values, 1, 2

formatting elements, 1

formatting system-maintained values in, 1

indenting, 1, 2

listing current definition, 1, 2, 3

restoring definition, 1

setting at start or end of report, 1

setting lines from top of page to top title, 1, 2, 3

setting lines from top title to end of page, 1

setting top and bottom, 1, 2, 3, 4

spacing between last row and bottom title, 1

suppressing definition, 1, 2

TO clause, 1, 2

tracing statements, 1

for performance statistics, 1

for query execution path, 1

using a database link, 1

with parallel query option, 1

TRIMOUT variable, 1

TRIMSPOOL variable, 1

TRUNCATE command

disabling, 1

TRUNCATE variable, 1, 2

TRUNCATED clause, 1, 2

TTITLE clause, 1

TTITLE command, 1, 2

aligning title elements, 1, 2

BOLD clause, 1

CENTER clause, 1, 2

COL clause, 1, 2

FORMAT clause, 1, 2

indenting titles, 1, 2

LEFT clause, 1, 2

listing current definition, 1, 2

OFF clause, 1, 2

old form, 1

ON clause, 1

referencing column value variable, 1, 2

restoring current definition, 1

RIGHT clause, 1, 2

SKIP clause, 1, 2

suppressing current definition, 1, 2

TAB clause, 1

tuning, 1

UNDEFINE command, 1, 2

and DEFINE command, 1

UNDERLINE variable, 1, 2

UNTIL CANCEL clause, 1

UNTIL CHANGE clause, 1

UNTIL CONTROLFILE clause, 1

UNTIL TIME clause, 1

UPDATE command

disabling, 1

USER clause, 1

user profile, 1

LOGIN.SQL, 1

1

user variables, 1

defining, 1, 2

deleting, 1, 2

displaying in headers and footers, 1

displaying in titles, 1

in ACCEPT command, 1, 2

listing definition of one, 1, 2

listing definitions of all, 1, 2

username, 1

connecting under different, 1, 2

created at installation, 1

in CONNECT command, 1, 2, 3

in COPY command, 1, 2, 3

in SQLPLUS command, 1, 2, 3

userprofile

GLOGIN.SQL, 1

USING BACKUP CONTROL FILE clause, 1

USING clause, 1, 2

V$SESSION virtual table, 1

V$SQLAREA virtual table, 1

VARCHAR columns

changing format, 1

default format, 1, 2

VARCHAR2 clause

VARIABLE command, 1

VARCHAR2 columns

changing format, 1, 2

default format, 1

VARIABLE command, 1

CHAR clause, 1

CLOB clause, 1

NCHAR clause, 1

NCLOB clause, 1

NUMBER clause, 1

REFCURSOR clause, 1

VARCHAR2 clause, 1

variable clause, 1

variables

bind variables, 1

substitution variables, 1

system variables, 1

user variables, 1

VARIANCE function, 1

VERIFY clause, 1

VERIFY variable, 1, 2

WARNING clause, 1

web

outputting reports, 1

web browser, 1

WHENEVER OSERROR command, 1

COMMIT clause, 1

CONTINUE clause, 1

EXIT clause, 1

NONE clause, 1

ROLLBACK clause, 1

WHENEVER SQLERROR command, 1, 2

COMMIT clause, 1

CONTINUE clause, 1

EXIT clause, 1

NONE clause, 1

ROLLBACK clause, 1

WORD_WRAPPED clause, 1, 2, 3

WRAP variable, 1, 2

WRAPPED clause, 1, 2