Index

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

Symbols

-- (comment delimiter), 5.3.3

- (hyphen)

clause, 3.5.1.1

continuing a long SQL*Plus command, 4.6.1.1, 12

. (period), 4.5

/ (slash) command

default logon, 3.5.2, 12

entered at buffer line-number prompt, 4.4.1.2, 12

entered at command prompt, 12

executing current PL/SQL block, 4.5

similar to RUN, 12, 12

usage, 12

# pound sign

overflow indication, 12

SET SQLPREFIX character, 12

$ number format, 6.1.2.2

& (ampersand)

disabling substitution variables, 5.9.4

substitution variables, 5.9

&&, 5.9.2

* (asterisk)

in DEL command, 5.2, 12

in LIST command, 5.2, 12

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

: (colon)

bind variables, 5.12

:BindVariable clause

EXIT command, 12

; (semicolon), 4.4, 5.2, 12

@ (at sign)

command, 2.2.3.1, 5.4, 12

command arguments, 12, 12

in CONNECT command, 12

in COPY command, B.1, B.2.1

in SQLPLUS command, 3.5

passing parameters to a script, 12, 12

script, 5.4, 12

similar to START, 5.4, 12

@ at sign)

similar to START, 12

@@ (double at sign) command, 2.2.3.1, 12

script, 12

similar to START, 12, 12

_CONNECT_IDENTIFIER predefined variable, 2.2.2.1, 12, 12

_DATE predefined variable, 12, 12

_EDITOR predefined variable, 5.1.1, 12, 12, 12, 12

_EDITOR substitution variable, 12

_EDITOR, in EDIT command, 5.1.1, 12, 12

_O_RELEASE predefined variable, 12, 12

_O_VERSION predefined variable, 12, 12

_PRIVILEGE predefined variable, 12, 12

_RC predefined variable, 12

_SQLPLUS_RELEASE predefined variable, 12, 12, 12

_USER predefined variable, 12, 12

~ infinity sign, 12

-~ negative infinity sign, 12

Numerics

0, number format, 6.1.2.2

9, number format, 6.1.2.2

A

ABORT mode, 12

abort query, 4.8

ACCEPT command, 5.11.1, 12, 12

and DEFINE command, 12

BINARY_DOUBLE clause, 12, 12

BINARY_FLOAT clause, 12, 12

customizing prompts for value, 5.11.2

DATE clause, 12

DEFAULT clause, 12

FORMAT clause, 12

HIDE clause, 12

NOPROMPT clause, 12

NUMBER clause, 5.11.2

PROMPT clause, 5.11.1, 12

access, denying and granting, 9.1

alias, 3.2.2

ALIAS clause, 12, 12

in ATTRIBUTE command, 12

ALL clause, 12

ALTER command

disabling, 9.2

ampersands &(amp;)

in parameters, 5.10, 12, 12, 12

substitution variables, 5.9

ANALYZE command

disabling, 9.2

APPEND clause

in COPY command, B.1.1, B.2.2

in SAVE command, 12, 12

APPEND command, 5.2, 5.2.3, 12

APPINFO clause, 8.5.2, 12

ARCHIVE LOG

command, 10.3.1, 12

mode, 10.3.1

argument

in START command, 5.10

ARRAYSIZE variable, 8.5.3, 12, 12

relationship to COPY command, B.1.2, B.2.3

ASSOCIATE command

disabling, 9.2

ATTRIBUTE command, 12

ALIAS clause, 12

and CLEAR COLUMN command, 12

CLEAR clause, 12

clearing columns, 12, 12

controlling display characteristics, 12

display characteristics, 12

entering multiple, 12

FORMAT clause, 12

LIKE clause, 12

listing attribute display characteristics, 12, 12

OFF clause, 12

ON clause, 12

restoring column display attributes, 12

suppressing column display attributes, 12

AUDIT command

disabling, 9.2

AUTOCOMMIT variable, 4.11, 12, 12

AUTOMATIC clause, 12

AUTOPRINT variable, 12, 12

AUTORECOVERY variable, 12, 12

autotrace report, 8.1.1

AUTOTRACE variable, 8.1.1, 12, 12

B

background process

startup after abnormal termination, 12

BASEURI variable, 12

basic OCI package, D.1.1

BASURI XQUERY option, 12

batch jobs, authenticating users in, 3.1.1

batch mode, 12

BEGIN command, 4.5

disabling, 9.2

BFILE clause

VARIABLE command, 12

BINARY_DOUBLE clause

ACCEPT command, 12, 12

VARIABLE command, 12

BINARY_FLOAT clause

ACCEPT command, 12, 12

VARIABLE command, 12

bind variables, 5.12

creating, 12

displaying, 12

displaying automatically, 12, 12

in PL/SQL blocks, 12

in SQL statements, 12

in the COPY command, 12

blank line

in PL/SQL blocks, 4.5

in SQL commands, 4.4.1.2

preserving in SQL commands, 12, 12

BLOB

column width, 6.1.3.1

formating in reports, 6.1.3

BLOB clause

VARIABLE command, 12

BLOB columns

default format, 12

setting maximum width, 12, 12

setting retrieval position, 12, 12

setting retrieval size, 8.5.7, 12, 12

blocks, PL/SQL

continuing, 4.5

editing in buffer, 5.2

editing with system editor, 5.1, 12

entering and executing, 4.5

listing current in buffer, 5.2.1

saving current, 12

setting character used to end, 12, 12

stored in SQL buffer, 4.5

timing statistics, 12

within SQL commands, 4.5.1

BLOCKTERMINATOR, 12, 12, 12, 12

BODY clause, 3.5.1.5

BODY option, 3.5.1.5

BOLD clause, 12, 12

break columns, 6.2, 12

inserting space when value changes, 6.2.2

specifying multiple, 6.2.4

suppressing duplicate values in, 6.2.1

BREAK command, 6.2, 12

and SQL ORDER BY clause, 6.2, 6.2.1, 6.2.4, 12

clearing BREAKS, 6.2.5

displaying column values in titles, 6.3.4

DUPLICATES clause, 12

inserting space after every row, 6.2.3

inserting space when break column changes, 6.2.2

listing current break definition, 6.2.5, 12

ON column clause, 6.2.1, 12

ON expr clause, 12

ON REPORT clause, 6.2.7, 12

ON ROW clause, 6.2.3, 12

printing grand and sub summaries, 6.2.7

printing summary lines at ends of reports, 6.2.7

removing definition, 12

SKIP clause, 6.2.3, 12

SKIP PAGE clause, 6.2.2, 6.2.2, 6.2.3, 12

specifying multiple break columns, 6.2.4, 12

suppressing duplicate values, 6.2.1

used in conjunction with COMPUTE, 6.2.6

used in conjunction with SET COLSEP, 12

used to format a REFCURSOR variable, 12

used with COMPUTE, 12, 12, 12, 12, 12

break definition

listing current, 6.2.5, 12

removing current, 6.2.5, 12

BREAKS clause, 6.2.5, 12

browser, web, 7.1.1

BTITLE clause, 12

BTITLE command, 6.3.1, 12

aligning title elements, 12

BOLD clause, 12

CENTER clause, 12

COL clause, 12

FORMAT clause, 12

indenting titles, 12

LEFT clause, 12

OFF clause, 12

old form, C.2

printing blank lines before bottom title, 6.3.1.1

referencing column value variable, 12

RIGHT clause, 12

SKIP clause, 12

suppressing current definition, 12

TAB clause, 12

TTITLE command, 12

buffer, 4.1.1

appending text to a line in, 5.2.3, 12

delete a single line, 5.2

delete the current line, 5.2

delete the last line, 5.2

deleting a range of lines, 5.2, 12

deleting a single line, 12

deleting all lines, 5.2, 12, 12

deleting lines from, 5.2.5, 12

deleting the current line, 12

deleting the last line, 12

executing contents, 12, 12

inserting new line in, 5.2.4, 12

listing a range of lines, 5.2, 12

listing a single line, 5.2, 12

listing all lines, 5.2, 12

listing contents, 5.2.1, 12

listing the current line, 5.2, 12

listing the last line, 5.2, 12

loading into system editor, 12

saving contents, 12

BUFFER clause, 5.1.1, 5.2, 12

BUFFER variable, C.6

C

CALL command

disabling, 9.2

CANCEL clause, 12, 12

Cancel key, 4.8

cancel query, 4.8

CENTER clause, 6.3.1.1, 12, 12

CHANGE command, 5.2, 5.2.2, 12

CHAR clause

VARIABLE command, 12

CHAR columns

changing format, 12

default format, 6.1.3.1

definition from DESCRIBE, 12

charset

SQL*Plus Instant Client, D.1.2

CLEAR clause, 6.1.5, 12

in ATTRIBUTE command, 12

CLEAR command, 12

BREAKS clause, 6.2.5, 12

BUFFER clause, 5.1.1, 5.2, 12

COLUMNS clause, 12

COMPUTES clause, 12

SCREEN clause, 5.11.4, 12

SQL clause, 12

TIMING clause, 12

CLOB clause

VARIABLE command, 12

CLOB columns

changing format, 12

default format, 12

setting maximum width, 12, 12

setting retrieval position, 12, 12

setting retrieval size, 8.5.7, 12, 12, 12

CLOSECURSOR variable, C.1, C.8

CMDSEP variable, 12, 12

COL clause, 6.3.1.2, 12, 12

colons &(colon;)

bind variables, 5.12

COLSEP variable, 12, 12

COLUMN command, 6.1, 12

ALIAS clause, 12

and BREAK command, 12

and DEFINE command, 12

CLEAR clause, 6.1.5, 12, 12

DEFAULT clause, C.3

displaying column values in bottom titles, 6.3.4, 12

displaying column values in top titles, 6.3.4, 12

entering multiple, 12

ENTMAP clause, 12

FOLD_AFTER clause, 12, 12, 12

FOLD_BEFORE clause, 12, 12

FORMAT clause, 6.1.2.2, 6.1.3.2, 12, 12

formatting a REFCURSOR variable, 12

formatting NUMBER columns, 6.1.2.1, 12

HEADING clause, 6.1.1.2, 12, 12

HEADSEP character, 12

JUSTIFY clause, 12

LIKE clause, 6.1.4, 12, 12

listing column display attributes, 6.1.5, 6.1.5, 12, 12

NEW_VALUE clause, 6.3.4, 12, 12

NEWLINE clause, 12, 12

NOPRINT clause, 6.3.4, 8.5.1, 12

NULL clause, 12, 12

OFF clause, 6.1.6, 12

OLD_VALUE clause, 6.3.4, 12, 12

ON clause, 6.1.6, 12

PRINT clause, 12

resetting a column to default display, C.1

resetting to default display, 6.1.5, 12, C.1

restoring column display attributes, 6.1.6, 12

storing current date in variable for titles, 12

suppressing column display attributes, 6.1.6, 12

TRUNCATED clause, 6.1.3.2, 12

WORD_WRAPPED clause, 6.1.3.2, 6.1.7, 12

WRAPPED clause, 6.1.3.2, 12

column headings

aligning, 12

changing, 6.1.1.1, 12

changing character used to underline, 12, 12

changing to two or more words, 6.1.1.2, 12

displaying on more than one line, 6.1.1.2, 12

suppressing printing in a report, 12, 12

when truncated, 12

when truncated for CHAR and LONG columns, 6.1.3.2

when truncated for DATE columns, 6.1.3.2

when truncated for NUMBER columns, 6.1.2.1

column separator, 12, 12, C.1

columns

assigning aliases, 12

computing summary lines, 6.2.6, 12

copying display attributes, 6.1.4, 12, 12

copying values between tables, B.1, B.2, B.3

displaying values in bottom titles, 6.3.4, 12

displaying values in top titles, 6.3.4, 12

formatting CHAR, VARCHAR, LONG, and DATE, 12

formatting in reports, 6.1, 12

formatting MLSLABEL, RAW MLSLABEL, ROWLABEL, 12

formatting NUMBER, 6.1.2.1, 12

listing display attributes for all, 6.1.5, 12

listing display attributes for one, 6.1.5, 12

names in destination table when copying, B.1.1, B.2.1

printing line after values that overflow, 6.1.7, 12, 12

resetting a column to default display, 6.1.5, 12, C.1, C.1

resetting all columns to default display, 12

restoring display attributes, 6.1.6, 12, 12

setting printing to off or on, 6.3.4, 8.5.1, 12

starting new lines, 12

storing values in variables, 6.3.4, 12

suppressing display attributes, 6.1.6, 12, 12

truncating display for all when value overflows, 6.1.3.2, 12

truncating display for one when value overflows, 6.1.3.2, 12

wrapping display for all when value overflows, 6.1.3.2, 12

wrapping display for one when value overflows, 6.1.3.2, 12

wrapping whole words for one, 6.1.7

COLUMNS clause, 12

comma, number format, 6.1.2.2

command files

aborting and exiting with a return code, 5.6, 12, 12

creating with a system editor, 5.1.1

creating with SAVE, 12, 12

editing with system editor, 12

in @ (at sign) command, 5.4, 12

in EDIT command, 12

in GET command, 12

in SAVE command, 5.1.1, 12

in SQLPLUS command, 3.5.3, 5.4.1

in START command, 5.4, 12

including comments in, 5.3, 12

including more than one PL/SQL block, 5.1.1

including more than one SQL command, 5.1.1

nesting, 5.5

passing parameters to, 5.10, 12, 12, 12

registering, 12, 12

retrieving, 12

running, 5.4, 12, 12

running a series in sequence, 5.5

running as you start SQL*Plus, 3.5.3, 5.4.1

running in batch mode, 5.6, 12

uniform resource locator, 12, 12, 12, 12

command prompt

SET SQLPROMPT, 8.5.10, 12, 12

SQL*Plus, 3.3.1

command-line

configuring globalization support, 11.1

installing help, 2.2.4

command-line interface

changing face and size, 1.2

commands

collecting timing statistics on, 8.2, 12

disabled in schema, 13.1

disabling, 9.2

echo on screen, 12

host, running from SQL*Plus, 4.9, 12

listing current in buffer, 12

re-enabling, 9.2

spaces, 4.1

SQL

continuing on additional lines, 4.4.1.1

editing in buffer, 5.2

editing with system editor, 12

ending, 4.4.1.2

entering and executing, 4.4

entering without executing, 4.4.1.2

executing current, 12, 12

following syntax, 4.4.1

listing current in buffer, 5.2.1

saving current, 12

setting character used to end and run, 12

SQL*Plus

command summary, 12

continuing on additional lines, 4.6.1.1, 12

ending, 4.6.1, 12

entering and executing, 4.6

entering during SQL command entry, 12

obsolete command alternatives, C.1

stopping while running, 4.8

tabs, 4.1

types of, 4.1

variables that affect running, 4.7

COMMENT command

disabling, 9.2

comments

including in command files, C.1

including in scripts, 5.3, 12, C.1

using -- to create, 5.3.3

using /*...*/ to create, 5.3.2

using REMARK, C.1

using REMARK to create, 5.3.1, 12, C.1

COMMIT clause, 12

WHENEVER OSERROR, 12

WHENEVER SQLERROR, 12

COMMIT command, 4.11

disabling, 9.2

communication between tiers, Preface

COMPATIBILITY variable, C.1, C.7

compilation errors, 4.5.1, 12, 13.1

COMPUTE command, 6.2, 12

computing a summary on different columns, 6.2.8

LABEL clause, 6.2.6, 6.2.7, 12

listing all definitions, 6.2.9, 12

maximum LABEL length, 12

OF clause, 6.2.6

ON, 12

ON column clause, 6.2.6, 12

ON expr clause, 12

ON REPORT clause, 6.2.7, 12

printing grand and sub summaries, 6.2.7

printing multiple summaries on same column, 6.2.8

printing summary lines at ends of reports, 6.2.7

printing summary lines on a break, 6.2.6

referencing a SELECT expression in OF, 12

referencing a SELECT expression in ON, 12

removing definitions, 6.2.9, 12

used to format a REFCURSOR variable, 12

COMPUTES clause, 12

CONCAT variable, 5.9.4, 5.9.4, 12, 12, 12, 12

configuration

globalization support

configuring

Oracle Net, 2.2.5

SQL*Plus, 2

CONNECT / feature, 3.1.1

CONNECT command, 3.1, 12

and @ (at sign), 12

changing password, 12, 12, 12

SYSDBA clause, 3.5.2, 12, 12

SYSOPER clause, 3.5.2, 12

username/password, 12

connect identifier, 12

in CONNECT command, 12

in COPY command, B.1

in DESCRIBE command, 12

in SQLPLUS command, 3.5.2

connection identifier, 3.2.1

easy or abbreviated, 3.2.3

full, 3.2.2

net service name, 3.2.2

CONTEXT variable, 12

CONTEXT XQUERY option, 12

CONTINUE clause

WHENEVER OSERROR, 12

WHENEVER SQLERROR, 12

continuing a long SQL*Plus command, 4.6.1.1, 12

COPY command, 12, B.1, B.2

and @ (at sign), B.1, B.2.1

and ARRAYSIZE variable, B.1.2, B.2.3

and COPYCOMMIT variable, B.1.2, B.2.3

and LONG variable, B.1.2, B.2.3

APPEND clause, B.1.1, B.2.2

copying data between databases, B.2

copying data between tables on one database, B.3

CREATE clause, B.1.1, B.2.2

creating a table, B.1.1, B.2.2, B.2.2

destination table, B.1.1, B.2.1

determining actions, B.2.1

determining source rows and columns, B.1.1, B.2.1

error messages, 13.2

FROM clause, B.2.1

INSERT clause, B.1.1, B.2.2

inserting data in a table, B.1.1, B.2.2, B.2.2

interpreting messages, B.2.3

mandatory connect identifier, B.1.1

naming the source table with SELECT, B.1.1, B.2.1

query, B.1.1, B.2.1

referring to another user's table, B.2.4

REPLACE clause, B.1.1, B.2.2

replacing data in a table, B.1.1, B.2.2

sample command, B.2.1, B.2.1

service name, B.2.1, B.2.2, B.3

specifying columns for destination, B.1.1, B.2.1

specifying the data to copy, B.1.1, B.2.1

TO clause, B.2.1

username/password, B.1.1, B.2.1, B.2.2, B.3

USING clause, B.1.1, B.2.1

COPYCOMMIT variable, 12, 12

relationship to COPY command, B.1.2, B.2.3

COPYTYPECHECK variable, 12, 12

CREATE clause

in COPY command, B.1.1, B.2.2

CREATE command

disabling, 9.2

entering PL/SQL, 4.5.1

creating a PLAN_TABLE, 8.1.1

creating flat files, 6.4.1

creating PLUSTRACE role, 8.1.1

creating sample tables, Preface

creating the PRODUCT_USER_PROFILE table, 9.1.1

cursor variables, 12

D

database

administrator, 10.1

connect identifier, 12

mounting, 12, 12

opening, 12, 12

database changes, saving automatically, 12, 12

DATABASE clause, 12

database files

recovering, 12

database name at startup, 12

database schema, 8.1.1

default, 12

DESCRIBE parameter, 12

SHOW, 12, 12

databases

connecting to default, 12

connecting to remote, 12

copying data between, B.1, B.2

copying data between tables on a single, B.3

disconnecting without leaving SQL*Plus, 3.1, 12

mounting, 10.2.1

opening, 10.2.1

recovering, 10.4, 12

shutting down, 10.2, 10.2.2

starting, 10.2

DATAFILE clause, 12

DATE

column definition from DESCRIBE, 12

DATE clause, 12

DATE columns

changing format, 12, 12

default format, 6.1.3.1

date, storing current in variable for titles, 6.3.5, 12, 12

DB2, 12, 12

DBA, 10.1

mode, 12

privilege, 12

DBMS output, 8.5.9, 12

DBMS_APPLICATION_INFO package, 8.5.2, 12, 12

DECLARE command

disabling, 9.2

PL/SQL, 4.5

DEFAULT clause, 12

DEFINE command, 5.7, 12

and system editor, 5.1.1, 12

and UNDEFINE command, 5.7, 12

CHAR values, 12

SET DEFINE ON|OFF, 12, 12

substitution variables, 12

DEFINE variable

See substitution variable

DEL command, 5.2, 5.2.5, 12

using an asterisk, 5.2, 12

DELETE command

disabling, 9.2

DESCRIBE command (SQL*Plus), 4.2, 12

connect_identifier, 12

PL/SQL properties listed by, 12

table properties listed by, 12

DISABLED keyword, disabling commands, 9.1.3

disabling

PL/SQL commands, 9.2

SQL commands, 9.2

SQL*Plus commands, 9.2

DISASSOCIATE command

disabling, 9.2

DISCONNECT command, 3.1, 12

DOCUMENT command, C.1, C.4

REMARK as newer version of, C.4, C.4

DOCUMENT variable, C.1, C.9

DROP command

disabling, 9.2

DUPLICATES clause, 12

E

ECHO

SET command, 12

ECHO variable, 5.4, 12, 12

Ed on UNIX, 12

EDIT command, 5.1.1, 12, 12, 12

creating scripts with, 5.1.1

defining _EDITOR, 12

modifying scripts, 12

setting default file name, 12, 12

EDITFILE variable, 12, 12

edition, 3.5.2, 12

in CONNECT command, 12

in SQLPLUS command, 3.5.2, 3.5.2

EDITOR operating system variable, 12

EMBEDDED variable, 12, 12

entities, HTML, 7.1.3

ENTMAP, 3.5.1.5

ENTMAP clause, 3.5.1.5, 7.1.3, 12

environment variables

LD_LIBRARY_PATH, 2.1

LOCAL, 2.1

NLS_LANG, 2.1

ORA_EDITION, 2.1

ORA_NLS10, 2.1

ORACLE_HOME, 2.1

ORACLE_PATH, 2.1

ORACLE_SID, 2.1

PATH, 2.1

SQL*Plus, 2.1

SQLPATH, 2.1

TNS_ADMIN, 2.1

TWO_TASK, 2.1

error

SQL*Plus Instant Client unsupported charset, D.1.2.1

error messages

COPY command, 13.2

interpreting, 4.12

sqlplus, 13.1

ERRORLOGGING variable, 12

errors

compilation errors, 4.5.1, 12, 13.1

making line containing current, 5.2.2

escape characters, definition of, 12, 12

ESCAPE variable, 5.9.4, 12, 12, 12, 12, 12

ESCCHAR variable, 12

example

interactive HTML report, 7.1.1, 7.1.1

EXECUTE command, 12

executing

a CREATE command, 4.5.1

execution plan, 8.1.2

execution statistics

including in report, 12

EXIT clause

WHENEVER OSERROR, 12

WHENEVER SQLERROR, 12

EXIT command, 3.4, 12

:BindVariable clause, 12

COMMIT clause, 12

FAILURE clause, 12

in a script, 12

ROLLBACK clause, 12

use with SET MARKUP, 7.1.1

WARNING clause, 12

exit, conditional, 12

EXITCOMMIT variable, 12

EXPLAIN command

disabling, 9.2

extension, 12, 12, 12

F

FAILURE clause, 12

features

new, Preface

FEEDBACK variable, 12, 12

file extensions, 2.2.3, 12, 12, 12

file names

in @ (at sign) command, 12

in @@ (double at sign) command, 12

in EDIT command, 12

in GET command, 12

in SAVE command, 12

in SPOOL command, 6.4.2, 12

in SQLPLUS command, 3.5.3

files

flat, 6.4.1

required for SQL*Plus Instant Client, D.2.3

FLAGGER variable, 12, 12

FLASHBACK command

disabling, 9.2

flat file, 6.4.1

FLUSH variable, 8.5.5, 12, 12

FOLD_AFTER clause, 12

FOLD_BEFORE clause, 12

font

changing face and size in command-line, 1.2

footers

aligning elements, 12

displaying at bottom of page, 12

displaying system-maintained values, 12

formatting elements, 12

indenting, 12

listing current definition, 12

setting at the end of reports, 6.3

suppressing definition, 12

FORCE clause, 12

FORMAT clause, 12, 12

in ATTRIBUTE command, 12

in COLUMN command, 6.1.2.2, 6.1.3.2

in REPHEADER and REPFOOTER commands, 12

in TTITLE and BTITLE commands, 6.3.2, 12

format models, number, 6.1.2.2, 12

formfeed, to begin a new page, 6.3.6, 12

FROM clause, 12, B.2.1

G

GET command, 12

LIST clause, 12

NOLIST clause, 12

retrieving scripts, 12

globalization support

Oracle10g, 11.3

glogin

profile, 12

H

HEAD clause, 3.5.1.5

HEAD option, 3.5.1.5

headers

aligning elements, 6.3.1.1

displaying at top of page, 12

displaying system-maintained values, 12

setting at the start of reports, 6.3

suppressing, 6.3.1

HEADING clause, 6.1.1.2, 12

HEADING variable, 12

headings

aligning elements, 12

column headings, 12

formatting elements, 12

indenting, 12

listing current definition, 12

suppressing definition, 12

HEADSEP variable, 12, 12

use in COLUMN command, 6.1.1.2

help

installing command-line, 2.2.4

online, 3.3.2, 12

HELP command, ? command, 12

HIDE clause, 12

HOST command, 4.9, 12

HTML, 7.1.1

clause, 3.5.1.5

entities, 7.1.3

option, 3.5.1.5

spooling to file, 3.5.1.5

tag, 7.1

hyphen

continuing a long SQL*Plus command, 4.6.1.1, 12

I

IMMEDIATE mode, 12

infinity sign (~), 12

initialization parameters

displaying, 12, 12

INIT.ORA file

parameter file, 12

input

accepting [Return], 5.11.3

accepting values from the user, 5.11.1, 12

INPUT command, 5.2, 5.2.4, 12

entering several lines, 12

INSERT clause, B.1.1, B.2.2

INSERT command

disabling, 9.2

installation

SQL*Plus Instant Client, D

SQL*Plus Instant Client by copying, D.1

SQL*Plus Instant Client by copying from 10g Client, D.3

SQL*Plus Instant Client by download from OTN, D.1, D.2

SQL*Plus Instant Client on Linux, D.2.1

SQL*Plus Instant Client on UNIX or Windows, D.2.2

SQL*Plus Instant Client UNIX and Linux files to copy, D.3.1

SQL*Plus Instant Client Windows files to copy, D.3.2

installation by copying, D.1

installation by copying from 10g Client, D.3

installation by download from OTN, D.1, D.2

installation on Linux, D.2.1

installation on UNIX or Windows, D.2.2

installation, UNIX and Linux files to copy, D.3.1

installation, Windows files to copy, D.3.2

INSTANCE variable, 12, 12

instances

shutting down, 12

starting, 12

Instant Client

SQL*Plus, D

Instant Client packages, D.1

iSQL*Plus

configuring Oracle Net, 2.2.5

J

Japanese

JUSTIFY clause, 12, 12

L

LABEL variable

SHOW command, C.1

labels

in COMPUTE command, 6.2.6, 12

language

SQL*Plus Instant Client, D.1.2

LD_LIBRARY_PATH

environment variables, 2.1

LEFT clause, 6.3.1.1, 12, 12

lightweight OCI package, D.1.2

LIKE clause, 6.1.4, 12, 12

limits, SQL*Plus, A

lines

adding at beginning of buffer, 12

adding at end of buffer, 12

adding new after current, 5.2.4, 12

appending text to, 5.2.3, 12

changing width, 6.3.6, 8.5.6, 12, 12

deleting all in buffer, 12

deleting from buffer, 5.2.5, 12

determining which is current, 5.2.2

editing current, 5.2.2

listing all in buffer, 5.2, 12

removing blanks at end, 12

LINESIZE variable, 6.3.1.1, 6.3.6, 12, 12

Linux

installing SQL*Plus Instant Client, D.2.1

SQL*Plus Instant Client files to copy, D.3.1

LIST clause, 12, 12

LIST command, 5.2, 12

determining current line, 5.2.2, 12

making last line current, 5.2.2, 12

using an asterisk, 5.2, 12

LNO clause, 12

LOBOFFSET variable, 12, 12

LOCAL

environment variables, 2.1

LOCK TABLE command

disabling, 9.2

LOG_ARCHIVE_DEST parameter, 12

LOGFILE clause, 12

logging off

conditionally, 12, 12

Oracle Database, 3.1, 12

SQL*Plus, 3.4, 12

logging on

Oracle Database, 12

SQL*Plus, 3.3.1

user profile, 2.2.2.1

LONG

column definition from DESCRIBE, 12

LONG columns

changing format, 12

default format, 12

setting maximum width, 12, 12, 12

setting retrieval size, 8.5.7, 8.5.7, 12, 12, 12

LONG variable, 12, 12

effect on COPY command, B.1.2, B.2.3

LONGCHUNKSIZE variable, 6.1.3.1, 12, 12, 12, 12

LONGRAW

column definition from DESCRIBE, 12

M

-MARKUP, 3.5.1.5, 3.5.1.5, 7.1, 7.1, 12

BODY clause, 3.5.1.5

ENTMAP clause, 3.5.1.5

HEAD clause, 3.5.1.5

PREFORMAT clause, 3.5.1.5

SQLPLUS command clause, 3.5.1.5

TABLE clause, 3.5.1.5

MAXDATA variable, C.1, C.10

media recovery, 12

MERGE command

disabling, 9.2

message, sending to screen, 5.11.1, 12

MOUNT clause, 12

mounting a database, 12

N

national language support

O

objects, describing, 12

obsolete commands

BTITLE, C.2

COLUMN command DEFAULT clause, C.3

DOCUMENT, C.1, C.4

NEWPAGE, C.1, C.5

SET command BUFFER variable, C.6

SET command CLOSECURSOR variable, C.1, C.8

SET command COMPATIBILITY variable, C.1, C.7

SET command DOCUMENT variable, C.1, C.9

SET command MAXDATA variable, C.1, C.10

SET command SCAN variable, C.1, C.11

SET command SPACE variable, C.1, C.12

SET command TRUNCATE variable, C.1, C.13

SHOW command LABEL variable, C.1

TTITLE command old form, C.14

OCI Instant Client, D

OCI package

basic, D.1.1

lightweight, D.1.2

OF clause, 6.2.6

OFF clause, 12

in ATTRIBUTE command, 12

in COLUMN command, 6.1.6, 12

in REPFOOTER commands, 12

in REPHEADER commands, 12

in SPOOL command, 6.4, 12

in TTITLE and BTITLE commands, 6.3.3, 12

OLD_VALUE clause, 6.3.4, 12

ON clause

in ATTRIBUTE command, 12

in COLUMN command, 6.1.6, 12

in TTITLE and BTITLE commands, 6.3.3

ON column clause

in BREAK command, 12

in COMPUTE command, 6.2.6, 12

ON expr clause

in BREAK command, 12

in COMPUTE command, 12

ON REPORT clause

in BREAK command, 6.2.7, 12

in COMPUTE command, 6.2.7, 12

ON ROW clause

in BREAK command, 6.2.3, 12

in COMPUTE command, 12

online help, 3.3.2, 3.3.2, 12

OPEN clause, 12

opening a database, 12

operating system

editor, 5.1.1, 12, 12

file, loading into buffer, 12

running commands from SQL*Plus, 4.9, 12

text editor, 5.1.1

ORA_EDITION

environment variables, 2.1

ORA_NLS10

environment variables, 2.1

Oracle Application Editions

edition, 3.5.2

Oracle Database Client, D

Oracle Net

configuring, 2.2.5

connect identifier, 12

Oracle Session Editions

edition, 12

ORACLE_HOME

environment variables, 2.1

ORACLE_PATH

environment variables, 2.1

ORACLE_SID

environment variables, 2.1

Oracle10g

globalization support, 11.3

ORDER BY clause

displaying column values in titles, 6.3.4

displaying values together in output, 6.2

ORDERING variable, 12

ORDERING XQUERY option, 12

OUT clause, 6.4.3, 12

output

formatting white space in, 8.5.11, 12

pausing during display, 4.10, 12

P

packages

SQL*Plus and OCI for Instant Client, D.1

PAGE clause, 12

page number, including in titles, 6.2.4, 6.3.2

pages

changing length, 6.3.6, 8.5.8, 12, 12

default dimensions, 6.3.6

matching to screen or paper size, 6.3.6

setting dimensions, 6.3.6

PAGESIZE clause

in LOGIN.SQL, 2.2.2.1

PAGESIZE variable, 4.4, 6.3.6, 8.5.8, 12, 12

parameter, 5.10, 12, 12, 12

SQLPATH, 2.1.1

parameter files (INIT.ORA files)

specifying alternate, 12

PARAMETERS clause, 12, 12

password

changing with the PASSWORD command, 12

in CONNECT command, 3.1, 12

in COPY command, B.2.1, B.2.2, B.3

in SQLPLUS command, 3.3.1, 3.5.2

viewable warning, 3.5.2

PASSWORD command, 12, 12

PATH

environment variables, 2.1

PAUSE command, 5.11.3, 12

PAUSE variable, 4.10, 12, 12

performance

of SQL statements, 8.1

over dial-up lines, 12

period (.)

terminating PL/SQL blocks, 4.5, 12, 12

PLAN_TABLE

creating, 8.1.1

table, 8.1.1

PL/SQL, 4.5

blocks, PL/SQL, 4.5

executing, 12

formatting output in SQL*Plus, 12

listing definitions, 4.3

mode in SQL*Plus, 4.5.1

within SQL commands, 4.5.1

PLUSTRACE

creating role, 8.1.1

role, 8.1.1

PNO clause, 12

pound sign (#), 12

predefined variable

_CONNECT_IDENTIFIER, 2.2.2.1, 12, 12

_DATE, 12, 12

_EDITOR, 5.1.1, 12, 12, 12, 12

_O_RELEASE, 12, 12

_O_VERSION, 12, 12

_PRIVILEGE, 12, 12

_RC, 12

_SQLPLUS_RELEASE, 12, 12, 12

_USER, 12, 12

PREFORMAT, 3.5.1.5

PREFORMAT clause, 3.5.1.5

PRINT clause, 12

PRINT command, 12

printing

bind variables automatically, 12

REFCURSOR variables, 12

SPOOL command, 12

Product User Profile table, 9.1

prompt

SET SQLPROMPT, 8.5.10, 12, 12

PROMPT clause, 5.11.1, 12

PROMPT command, 5.11.1, 12

customizing prompts for value, 5.11.2

prompts for value

bypassing with parameters, 5.10

customizing, 5.11.2

through ACCEPT, 5.11.1

through substitution variables, 5.9.1

PUPBLD.SQL, 9.1.1

PURGE command

disabling, 9.2

Q

queries

in COPY command, B.1.1, B.2.1

show number of records retrieved, 4.4, 12, 12

tracing, 8.3, 8.4

query execution path

including in report, 12

query results

displaying on-screen, 4.4

sending to a printer, 6.4.3, 12

storing in a file, 6.4.2, 12

QUIT command, 12

R

RAW

column definition from DESCRIBE, 12

record separators, printing, 6.1.7, 12, 12

RECOVER clause, 12

RECOVER command, 12

and database recovery, 10.4

AUTOMATIC clause, 12

CANCEL clause, 12, 12

CONTINUE clause, 12

DATABASE clause, 12

FROM clause, 12

LOGFILE clause, 12

NOPARALLEL clause, 12

STANDBY DATABASE clause, 12

STANDBY DATAFILE clause, 12

STANDBY TABLESPACE clause, 12, 12

UNTIL CANCEL clause, 12

UNTIL CONTROLFILE clause, 12

UNTIL TIME clause, 12

USING BACKUP CONTROL FILE clause, 12

recovery

RECOVER command, 12

RECSEP variable, 6.1.7, 12, 12

RECSEPCHAR variable, 6.1.7, 12, 12

REFCURSOR bind variables

in a stored function, 5.13

REFCURSOR clause

VARIABLE command, 12

registry

editor, 2.1.1

registry entry

SQLPATH, 2.1, 2.1.1

RELEASE clause, 12

REMARK command, 5.3.1, 12

removing sample tables, Preface

RENAME command

disabling, 9.2

REPFOOTER clause, 12

REPFOOTER command, 6.3.1, 12

aligning footer elements, 12

BOLD clause, 12

CENTER clause, 12

COL clause, 12

FORMAT clause, 12

indenting report footers, 12

LEFT clause, 12

OFF clause, 12

RIGHT clause, 12

SKIP clause, 12

suppressing current definition, 12

TAB clause, 12

REPHEADER clause, 12

REPHEADER command, 6.3.1, 12

aligning header elements, 6.3.1.1

aligning heading elements, 12

BOLD clause, 12

CENTER clause, 12

COL clause, 12

FORMAT clause, 12

indenting headings, 12

LEFT clause, 12

OFF clause, 12

PAGE clause, 12

RIGHT clause, 12

SKIP clause, 12

suppressing current definition, 12

TAB clause, 12

REPLACE clause

in COPY command, B.1.1, B.2.2

in SAVE command, 12, 12

reports

autotrace, 8.1.1

breaks, 12

clarifying with spacing and summary lines, 6.2

columns, 12

creating bottom titles, 6.3, 12, C.1, C.1

creating footers, 12

creating headers, 12

creating headers and footers, 6.3

creating master/detail, 6.3.4, 12, 12

creating top titles, 6.3, 12, C.1

displaying, 12, 12

formatting column headings, 6.1.1.2, 12

formatting columns, 6.1.2.1, 6.1.3.1, 12

interactive HTML example, 7.1.1, 7.1.1

on the web, 7.1

SILENT mode, 7.1.2

starting on a new page, 12

title, 12, C.1

RESTRICT, 3.5.1.7, 9.4, 12

return code, specifying, 5.6, 12, 12

REVOKE command, 9.1

disabling, 9.2

RIGHT clause, 6.3.1.1, 12, 12

roles, 9.3

disabling, 9.3.2

re-enabling, 9.3.2

ROLLBACK clause, 12

WHENEVER OSERROR, 12

WHENEVER SQLERROR, 12

ROLLBACK command

disabling, 9.2

ROWID

column definition from DESCRIBE, 12

rows

performing computations on, 6.2.6, 12

setting number retrieved at one time, 8.5.3, 12, 12

setting the number after which COPY commits, 12

RUN command, 12

executing current PL/SQL block, 4.5

making last line current, 5.2.2

similar to / (slash) command, 12

S

sample schemas, Preface, Preface, Preface, Preface, Preface

see Oracle Database Sample Schemas guide, Preface

using HR in COLUMN example, 12

using HR in examples, 5, 6

sample tables

access to, Preface

creating, Preface

removing, Preface

unlocking, Preface

SAVE command, 12

APPEND clause, 12

CREATE clause, 12

REPLACE clause, 12

storing commands in scripts, 12

using with INPUT to create scripts, 5.1.1

SAVEPOINT command

disabling, 9.2

saving environment attributes, 12

SCAN variable, C.1, C.11

schemas

command, 13.1

database, 8.1.1

database default, 12

DESCRIBE parameter, 12

disabled commands, 13.1

HR sample, Preface, Preface

installing own copy of HR, Preface

sample, Preface

SHOW parameter, 12, 12

unlocking HR, Preface

using HR in COLUMN example, 12

using HR in examples, 5, 6

SCREEN clause, 5.11.4, 12

screens

clearing, 5.11.4, 12

scripts

extension, 12, 12, 12

registering, 8.5.2

scripts, authenticating users in, 3.1.1

security

changing password, 12

password viewable, 3.5.2

PRODUCT_USER_PROFILE table, 9.1

RESTRICT, 3.5.1.7, 9.4

SELECT command

and BREAK command, 6.2, 12, 12, 12

and COLUMN command, 12

and COMPUTE command, 6.2

and COPY command, B.1.1, B.2.1

and DEFINE command, 12

and ORDER BY clause, 6.2

disabling, 9.2

formatting results, 5.13

semicolon (;)

in PL/SQL blocks, 4.5

in SQL commands, 4.4, 4.4.1.2

in SQL*Plus commands, 4.6.1, 12

not stored in buffer, 5.2.1

SERVEROUTPUT variable, 12

service name

in COPY command, B.2.1, B.2.2, B.3

Session Editions, 12

SET AUTOTRACE, 8.1.1

SET clause, 12

SET command, 2.2.3, 4.7, 12

APPINFO variable, 8.5.2, 12

ARRAYSIZE variable, 8.5.3, 12, 12, B.2.3

AUTOCOMMIT variable, 12, 12

AUTOPRINT variable, 12, 12, 12

AUTORECOVERY variable, 12, 12

AUTOTRACE variable, 12, 12

BLOCKTERMINATOR variable, 12, 12

BUFFER variable, C.6

CLOSECURSOR variable, C.1, C.8

CMDSEP variable, 12, 12

COLSEP variable, 6.4.1, 12, 12

COMPATIBILITY variable, C.1, C.7

CONCAT variable, 5.9.4, 5.9.4, 12, 12

COPYCOMMIT variable, 12, 12, B.2.3

COPYTYPECHECK variable, 12, 12

DEFINE clause, 5.9.4

DEFINE variable, 12

DESCRIBE variable, 12, 12

DOCUMENT variable, C.1, C.9

ECHO variable, 12, 12

EDITFILE variable, 12, 12

EMBEDDED variable, 12, 12

ERRORLOGGING variable, 12

ESCAPE variable, 5.9.4, 12, 12, 12, 12, 12

ESCCHAR variable, 12

EXITCOMMIT variable, 12

FEEDBACK variable, 12, 12

FLAGGER variable, 12, 12

FLUSH variable, 8.5.5, 12, 12

HEADING variable, 12

HEADSEP variable, 6.1.1.2, 12, 12

INSTANCE variable, 12, 12

LINESIZE variable, 6.3.1.1, 6.3.6, 12, 12

LOBOFFSET variable, 12, 12

LOGSOURCE variable, 12, 12

LONG variable, 12, 12, B.2.3

LONGCHUNKSIZE variable, 12, 12

MARKUP clause, 12

MAXDATA variable, C.1, C.10

NEWPAGE variable, 6.3.6, 12, 12

NULL variable, 12, 12

NUMFORMAT clause, 2.2.2.1

NUMFORMAT variable, 12, 12

NUMWIDTH variable, 6.1.2.1, 12, 12, 12

PAGESIZE clause, 2.2.2.1

PAGESIZE variable, 4.4, 6.3.6, 8.5.8, 12, 12

PAUSE variable, 12, 12

RECSEP variable, 6.1.7, 12, 12

RECSEPCHAR variable, 6.1.7, 12, 12

SCAN variable, C.1, C.11

SERVEROUTPUT variable, 12

SHIFTINOUT variable, 12, 12

SPACE variable, C.1, C.12

SQLBLANKLINES variable, 12

SQLCASE variable, 12, 12

SQLCONTINUE variable, 12, 12

SQLNUMBER variable, 12, 12

SQLPLUSCOMPATIBILITY variable, 12, 12

SQLPREFIX variable, 12, 12

SQLPROMPT variable, 8.5.10, 12, 12

SQLTERMINATOR variable, 12, 12

substitution variable, 12

SUFFIX variable, 12, 12

TAB variable, 8.5.11, 12, 12

TERMOUT variable, 8.5.12, 12, 12

TIME variable, 12, 12

TIMING variable, 12, 12

TRIMOUT variable, 12, 12

TRIMSPOOL variable, 12, 12

TRUNCATE variable, C.1, C.13

UNDERLINE variable, 12, 12

used to format a REFCURSOR variable, 12

VERIFY clause, 5.9.1

VERIFY variable, 5.9.4, 5.9.4, 12, 12

WRAP variable, 6.1.3.2, 12, 12

XQUERY BASEURI variable, 12

XQUERY CONTEXT variable, 12

XQUERY NODE variable, 12

XQUERY ORDERING variable, 12

SET CONSTRAINTS command

disabling, 9.2

SET MARKUP

BODY clause, 3.5.1.5

ENTMAP clause, 3.5.1.5, 7.1.3

HEAD clause, 3.5.1.5

HTML, 3.5.1.5

interactive HTML example, 7.1.1, 7.1.1

PREFORMAT clause, 3.5.1.5

TABLE clause, 3.5.1.5

SET ROLE command

disabling, 9.2

SET system variable summary, 12

SET TRANSACTION command

disabling, 9.2

SET variables, 4.7

See system variables

SET XQUERY BASURI, 12

SET XQUERY CONTEXT, 12

SET XQUERY NODE, 12

SET XQUERY ORDERING, 12

SGA clause, 12

SHIFTINOUT variable, 12, 12

SHOW

schema parameter, 12, 12

SHOW clause, 12

SHOW command, 4.7, 12

ALL clause, 12

BTITLE clause, 12

ERRORS clause, 12

LABEL variable, C.1

listing current page dimensions, 6.3.6

LNO clause, 12

PNO clause, 12

RELEASE clause, 12

REPFOOTER clause, 12

REPHEADER clause, 12

SPOOL clause, 12

SQLCODE clause, 12

TTITLE clause, 12

USER clause, 12

XQUERY clause, 12

SHOWMODE variable, 12, 12

SHUTDOWN command, 12, 12

ABORT, 12

IMMEDIATE, 12

NORMAL, 12

TRANSACTIONAL LOCAL, 12

-SILENT option, 3.5.1.8, 7.1.2

site profile

glogin, 2.2, 2.2.1, 2.2.2.1, 3.5.1.7, 12, 12

SKIP clause

in BREAK command, 6.2.2, 6.2.3, 12

in REPHEADER and REPFOOTER commands, 12

in TTITLE and BTITLE commands, 6.3.1.1, 12

used to place blank lines before bottom title, 6.3.1.1

SKIP PAGE clause, 6.2.2, 6.2.3, 12

slash (/) command, 12

files loaded with GET command, 12

SPACE variable, C.1, C.12

SPOOL clause, 3.5.1.5, 12

SPOOL command, 6.3.6, 12

APPEND clause, 12

CREATE clause, 12

file name, 6.4.2, 12

OFF clause, 6.4, 12

OUT clause, 6.4.3, 12

REPLACE clause, 12

to HTML file, 3.5.1.5

turning spooling off, 6.4, 12

use with SET MARKUP, 7.1.1

SQL clause, 12

SQL DML statements

reporting on, 12, 12

SQL optimizer, 8.1.2

SQL*Plus

command prompt, 3.3.1

command summary, 12

configuring globalization support, 11.1

database administration, 10.1

environment variables, 2.1

error messages, 13.1

execution plan, 8.1.2

exiting, 3.4, 12, 12

limits, A

obsolete command alternatives, C.1

setting up environment, 2.2

starting, 3.3, 3.3.1, 3.5

statistics, 8.1.3

system variables affecting performance, 8.5

tuning, 8.1

who can use, Preface

SQL*Plus and OCI packages, D.1

SQL*Plus command-line vs SQL*Plus Instant Client, D

SQL*Plus Instant Client, D, D, D.1, D.1, D.2, D.2.1, D.2.2, D.3, D.3.1, D.3.2

basic, D.1.1

installation, D

lightweight, D.1.2

NLS_LANG, D.1.2

NLS_LANG charset parameter, D.1.2

NLS_LANG language parameter, D.1.2

NLS_LANG territory parameter, D.1.2

required files in packages, D.2.3

unsupported charset error, D.1.2.1

SQLBLANKLINES variable, 12, 12

SQLCASE variable, 12, 12

SQLCODE clause, 12

SHOW command, 12

SQLCONTINUE variable, 12, 12

SQL.PNO, referencing in report titles, 6.3.2

SQLNUMBER variable, 12, 12, 12, 12

SQLPATH

environment variables, 2.1

registry entry, 2.1, 2.1.1

SQLPLUS command, 3.3.1

- clause, 3.5.1.1

-? clause, 3.5.1.2

and @ (at sign), 3.5

and EXIT FAILURE, 3.4

Application Editions, 3.5.2

BODY option, 3.5.1.5

commands

SQLPLUS, 3.5

connect identifier, 3.5.2

display syntax, 3.5.1.1

edition, 3.5.2

ENTMAP option, 3.5.1.5

HEAD option, 3.5.1.5

HTML option, 3.5.1.5

-MARKUP clause, 3.5.1.5

-MARKUP option, 3.5.1.5

/NOLOG clause, 3.5.2

PREFORMAT option, 3.5.1.5

RESTRICT, 3.5.1.7, 9.4

service name, 3.5.2

-SILENT clause, 3.5.1.8

-SILENT option, 3.5.1.8, 7.1.2

SPOOL clause, 3.5.1.5

syntax, 3.5

SYSDBA clause, 3.5.2

TABLE option, 3.5.1.5

unsuccessful connection, 3.4

username/password, 3.3.1, 3.5.2

SQLPREFIX variable, 12, 12

SQLPROMPT variable, 8.5.10, 12, 12

SQL.SQLCODE

using in EXIT command, 12

SQLTERMINATOR variable, 12, 12, 12, 12

STANDBY DATAFILE clause, 12

STANDBY TABLESPACE clause, 12

START clause, 12

START command, 5.4, 12

arguments, 5.10

passing parameters to a script, 5.10

script, 5.4, 12

similar to @ (at sign) command, 5.4, 12, 12

similar to @@ (double at sign) command, 12

starting

SQL*Plus, 1.1, 3.3, 3.3.1

STARTUP command, 12

FORCE clause, 12

MOUNT clause, 12

NOMOUNT clause, 12

OPEN clause, 12

PFILE clause, 12

RECOVER clause, 12

RESTRICT clause, 12

specifying a database, 12

statistics, 8.1.3

collecting TIMING statistics, 8.2

STOP clause, 12

stop query, 4.8

STORE command, 2.2.3, 12

SET clause, 12

stored functions, 5.13

stored procedures

creating, 4.5.1

subkey, registry, 2.1.1

substitution variables, 5.7, 5.9, 5.9.4, 12, 12

_EDITOR, 12

appending characters immediately after, 5.9.1

avoiding unnecessary prompts for value, 5.9.2

concatenation character, 12, 12

DEFINE command, 12

defining, 5.7, 5.9.2, 12

deleting, 5.7, 12

displaying in headers and footers, 12

displaying in titles, 12

in ACCEPT command, 5.11.1, 12

listing definitions, 5.7, 5.7, 12, 12

parsing, 8.5.4

prefixing, 12, C.1

related system variables, 5.9.4

restrictions, 5.9.3

single and double ampersands, 5.9.2

system variables used with, 5.9.4

undefined, 5.9.1

where and how to use, 5.9.1

SUFFIX variable, 12, 12

used with EDIT command, 12

used with GET command, 12

used with SAVE command, 12

used with START command, 12

SUM function, 6.2.6

summary lines

computing and printing, 6.2.6, 12

computing and printing at ends of reports, 6.2.7

computing same type on different columns, 6.2.8

printing grand and sub summaries (totals), 6.2.7

printing multiple on same break column, 6.2.8

syntax

COPY command, B.2.1

syntax rules

SQL commands, 4.4.1

SQL*Plus commands, 4.6.1

SYSDBA clause, 12

SYSOPER clause, 3.5.2, 12

system variables, 4.7, 12

affecting SQL*Plus performance, 8.5

affecting substitution variables, 5.9.4

listing current settings, 4.7, 12

listing old and new values, 12, 12

storing and restoring, 2.2.3

summary of SET commands, 12

system-maintained values

displaying in headers and footers, 12

displaying in titles, 6.3.2, 12

formatting in titles, 6.3.2

T

TAB clause, 12, 12

TAB variable, 8.5.11, 12, 12

TABLE clause, 3.5.1.5

TABLE option, 3.5.1.5

tables

access to sample, Preface

controlling destination when copying, B.1.1, B.2.2

copying values between, B.2, B.3

listing column definitions, 4.2, 12

referring to another user's when copying, B.2.4

TABLESPACE clause, 12

tablespaces, recovering, 12

tag, HTML, 7.1

TERMOUT variable, 8.5.12, 12, 12

using with SPOOL command, 12

territory

SQL*Plus Instant Client, D.1.2

text, 3.5.1.5, 3.5.1.5

adding to current line with APPEND, 5.2.3, 12

changing old to new with CHANGE, 5.2.2, 12

clearing from buffer, 5.2, 12

text editor

operating system, 5.1.1, 12

TIME variable, 12, 12

TIMING clause, 12

TIMING command, 8.2, 12

deleting all areas created by, 12

deleting current area, 12

SHOW clause, 12

START clause, 12

STOP clause, 12

TIMING variable, 12, 12

titles

aligning elements, 6.3.1.1, 12

displaying at bottom of page, 6.3, 12, C.1, C.1

displaying at top of page, 6.3, 12, C.1

displaying column values, 6.3.4, 12, 12

displaying current date, 6.3.5, 12, 12

displaying page number, 6.3.2, 12

displaying system-maintained values, 6.3.2, 12

formatting elements, 12

formatting system-maintained values in, 6.3.2

indenting, 6.3.1.2, 12

listing current definition, 6.3.3, 12, 12

restoring definition, 6.3.3

setting at start or end of report, 6.3

setting lines from top of page to top title, 6.3.6, 12, 12, C.1

setting lines from top title to end of page, 8.5.8, 12, 12

setting top and bottom, 6.3, 12, 12, C.1, C.1, C.1

spacing between last row and bottom title, 6.3.1.1

suppressing definition, 6.3.3, 12

TNS_ADMIN

environment variables, 2.1

TO clause, B.2.1

tracing queries, 8.3, 8.4

tracing statements

for performance statistics, 8.1.3

for query execution path, 8.1.3

with parallel query option, 8.3

TRIMOUT variable, 12, 12

TRIMSPOOL variable, 12, 12

TRUNCATE command

disabling, 9.2

TRUNCATE variable, C.1, C.13

TRUNCATED clause, 6.1.3.2, 12

TTITLE clause, 12

TTITLE command, 6.3.1, 12

aligning title elements, 6.3.1.1, 12

BOLD clause, 12

CENTER clause, 6.3.1.1, 12

COL clause, 6.3.1.2, 12

FORMAT clause, 6.3.2, 12

indenting titles, 6.3.1.2, 12

LEFT clause, 6.3.1.1, 12

listing current definition, 6.3.3, 12

OFF clause, 6.3.3, 12

old form, C.14

ON clause, 6.3.3

referencing column value variable, 6.3.4, 12

restoring current definition, 6.3.3

RIGHT clause, 6.3.1.1, 12

SKIP clause, 6.3.1.1, 12

suppressing current definition, 6.3.3, 12

TAB clause, 12

tuning

SET APPINFO OFF, 8.5.2

SET ARRAYSIZE, 8.5.3

SET DEFINE OFF, 8.5.4

SET FLUSH OFF, 8.5.5

SET TRIMOUT ON, 8.5.13

SET TRIMSPOOL ON, 8.5.13

SQL*Plus, 8.1

system variables, 8.5

TWO_TASK

environment variables, 2.1

U

UNDEFINE command, 5.7, 12

and DEFINE command, 12

UNDERLINE variable, 12, 12

unicode

UNIX

ed, 12

installing SQL*Plus Instant Client, D.2.2

SQL*Plus Instant Client files to copy, D.3.1

unlocking sample tables, Preface

UNTIL CANCEL clause, 12

UNTIL CHANGE clause, 12

UNTIL CONTROLFILE clause, 12

UNTIL TIME clause, 12

UPDATE command, disabling, 9.2

USER clause, 12

user profile, 2.2.2

glogin.sql, 2.2.2

V

V$SESSION virtual table, 12

V$SQLAREA virtual table, 12

VALIDATE command

disabling, 9.2

VARCHAR columns

default format, 6.1.3.1

VARCHAR2

column definition from DESCRIBE, 12

VARCHAR2 clause

VARIABLE command, 12

VARCHAR2 columns

changing format, 12

default format, 6.1.3.1

VARIABLE command, 12

BFILE clause, 12

BINARY_DOUBLE clause, 12

BINARY_FLOAT clause, 12

BLOB clause, 12

CHAR clause, 12

CLOB clause, 12

NCHAR clause, 12

NCLOB clause, 12

NUMBER clause, 12

REFCURSOR clause, 12

VARCHAR2 clause, 12

variable clause, 12

variables

bind variables, 5.12

substitution variables, 12

system variables, 4.7

VERIFY clause, 5.9.1

VERIFY variable, 5.9.4, 5.9.4, 12, 12

W

WARNING clause, 12

web browser, 7.1.1

web, outputting reports, 7.1

WHENEVER OSERROR command, 12

COMMIT clause, 12

CONTINUE clause, 12

EXIT clause, 12

NONE clause, 12

ROLLBACK clause, 12

WHENEVER SQLERROR command, 12

COMMIT clause, 12

CONTINUE clause, 12

EXIT clause, 12

NONE clause, 12

ROLLBACK clause, 12

Windows

installing SQL*Plus Instant Client, D.2.2

notepad, 12

SQL*Plus Instant Client files to copy, D.3.2

WORD_WRAPPED clause, 6.1.3.2, 6.1.7, 12

WRAP variable, 6.1.3.2, 12, 12

WRAPPED clause, 6.1.3.2, 12, 12

X

XMLType

column definition from DESCRIBE, 12

column formatting, 6.1.3.2

column width, 6.1.3.1

creating, 6.1.3.2

formatting in reports, 6.1.3

inserting values, 6.1.3.2

selecting data, 6.1.3.2

setting column retrieval size, 8.5.7, 12

setting maximum column width, 12

XQUERY clause, 12

XQUERY command, 12

XQUERY options

BASURI, 12

CONTEXT, 12

NODE, 12

ORDERING, 12