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.2

continuing a long SQL*Plus command, 4.6.1.1, 12

. (period), 4.5

# 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

/(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

* (asterisk)

in DEL command, 5.2, 12

in LIST command, 5.2, 12

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

: (colon)

bind variables, 5.13

: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, 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, 1.2.3.2, 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.12.1, 12, 12

and DEFINE command, 12

BINARY_DOUBLE clause, 12, 12

BINARY_FLOAT clause, 12, 12

customizing prompts for value, 5.12.2

DATE clause, 12

DEFAULT clause, 12

FORMAT clause, 12

HIDE clause, 12

NOPROMPT clause, 12

NUMBER clause, 5.12.2

PROMPT clause, 5.12.1, 12

access, denying and granting, 9.1

AFIEDT.BUF

See editor

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.11, 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

Application Server

authentication, 1.3.3.2, 9.6.3

isqlplusctl utility, 3.3.4

port in use, 2.3.1

Product User Profile table, 9.6.5

starting, 3.3.4

starting the Windows service, 3.3.4

stopping, 3.3.6

test if running, 2.3.2

ARCH background process, 12

ARCHIVE LOG

command, 10.3.1, 12

mode, 10.3.1

argument

in START command, 5.11

ARRAYSIZE variable, 8.5.3, 12, 12

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

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

authentication

adding username/password entries, 9.6.3

DBA access in iSQL*Plus, 9.6.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, E.1.1

BASURI XQUERY option, 12

batch jobs, authenticating users in, 3.1.1

batch mode, 12

BEGIN command, 4.5

disabling, 9.2

BINARY_DOUBLE clause

ACCEPT command, 12, 12

VARIABLE command, 12

BINARY_FLOAT clause

ACCEPT command, 12, 12

VARIABLE command, 12

bind variables, 5.13

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

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

clearing your screen, 1.2.3.2

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

screen area, 1.2.3.4

SQL, 1.2.3.1

BUFFER clause, 5.1.1, 5.2, 12

BUFFER variable, C.6

buttons

cancel, 1.3.7.3, 1.3.8.1, 1.3.8.1, 3.1.5.6, 5.10.1.3

clear screen, 1.3.4.1

execute, 1.3.4.2

load script, 1.3.4.3

save script, 1.3.4.4

C

cancel button, 1.3.7.3, 1.3.8.1, 1.3.8.1, 3.1.5.6, 5.10.1.3

CANCEL clause, 12, 12

Cancel key, 4.8

cancel query, 4.8

cancelling an in-progress operation, 1.2.3.1

CENTER clause, 6.3.1.1, 12, 12

CHANGE command, 5.2, 5.2.2, 12

Change Password screen, 3.1.5

CHAR clause

VARIABLE command, 12

CHAR columns

changing format, 12

default format, 6.1.3.1

definition from DESCRIBE, 12

Character Map Windows utility

choosing a font, 1.1.2.2, 1.2.4.2

charset

SQL*Plus Instant Client, E.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.12.4, 12

SQL clause, 12

TIMING clause, 12

clear screen button, 1.3.4.1

clearing your screen, 1.2.3.2

client tier, Preface, Preface

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.1, C.8

CMDSEP variable, 12, 12

COL clause, 6.3.1.2, 12, 12

colons (:)

bind variables, 5.13

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, 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, 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, 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, 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

opening, 1.2.3.1

passing parameters to, 5.11, 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

saving, 1.2.3.1

uniform resource locator, 12, 12, 12, 12

command keys, SQL*Plus Windows GUI, 1.2.2

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.1.2

Euro sign, 1.1.2.2

special character, 1.1.2.2

Windows Character Map utility, 1.1.2.2

commands

collecting timing statistics on, 8.2, 12

copying text, 1.2.1

disabled in schema, 13.1

disabling, 9.2

echo on screen, 12

finding text, 1.2.3.3

host, running from SQL*Plus, 4.9, 12

listing current in buffer, 12

pasting text, 1.2.3.2

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

comments

including in command files, C.1

including in scripts, 5.3, 12, C.1, 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, C.1

COMMIT clause, 12

WHENEVER OSERROR, 12

WHENEVER SQLERROR, 12

COMMIT command, 4.11

communication between tiers, Preface, Preface

COMPATIBILITY variable, C.1, 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

configuration parameter

iSQLPlusAllowScriptsURL, 2.1

iSQLPlusAllowUserMarkup, 2.1

iSQLPlusBannerMessage, 2.1

iSQLPlusConnectIdList, 2.1

log4j.rootLogger, 2.1

configuring

cookies for iSQL*Plus, 2.4

javascript for iSQL*Plus, 2.4

Oracle Net, 2.2.5

SQL*Plus, 2

Windows GUI, 2.5

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 /feature, 3.1.1

connect identifier, 12

field, 1.3.2.3, 1.3.3.5

in CONNECT command, 12

in COPY command, B.1

in DESCRIBE command, 12

in SQLPLUS command, 3.5.2

connect port conflict, 2.3.1

connect string

See connection identifier

connection identifier, 3.2.1, 3.3.3.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

cookies, configuring for iSQL*Plus, 2.4

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.3

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

copying text, 1.2.1, 1.2.3.2

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

database tier, Preface, Preface

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, 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

connections, 2.3.6

DBA Login screen, 1.3.3

DBA Workspace, 1.3.5

iSQL*Plus access, 9.6.2

mode, 12

privilege, 1.3.3, 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

default port conflict, 2.3.1

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

iSQL*Plus, 2.3.8

PL/SQL commands, 9.2

SQL commands, 9.2

SQL*Plus commands, 9.2

DISCONNECT command, 3.1, 12

DOCUMENT command, C.1, C.1, C.4

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

DOCUMENT variable, C.1, C.1, C.9

DROP command

disabling, 9.2

DUPLICATES clause, 12

dynamic reports, creating, 7.2

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

Edit menu, 1.2.3.2

EDITFILE variable, 12, 12

editor

defining, 1.2.3.2

invoking, 1.2.3.2

registry entries, 2.5.2.1

EDITOR operating system variable, 12

EMBEDDED variable, 12, 12

enabling iSQL*Plus, 2.3.8

Enter statements field, 1.3.6.1, 1.3.6.1, 1.3.6.2, 1.3.6.3

entities, HTML, 7.1.3

ENTMAP, 3.5.1.5

ENTMAP clause, 3.5.1.5, 7.1.3, 12

environment variables

iSQL*Plus, 2.1

JAVA_HOME, 2.1

JRE_HOME, 2.1

LD_LIBRARY_PATH, 2.1

LOCAL, 2.1

NLS_LANG, 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

SQLPLUS, 2.1

TNS_ADMIN, 2.1

TWO_TASK, 2.1

error

SQL*Plus Instant Client unsupported charset, E.1.2.1

error messages

COPY command, 13.3

interpreting, 4.12

iSQL*Plus, 13.2

sqlplus, 13.1

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

Euro sign

command-line interface, 1.1.2.2

GUI, 1.2.4, 1.2.4.2

example

interactive HTML report, 7.1.1, 7.1.1

execute button, 1.3.4.2

EXECUTE command, 12

executing

a CREATE command, 4.5.1

statements, 4.1.2

executing scripts

See running

execution plan, 8.1.2

execution statistics

including in report, 12

EXIT clause

WHENEVER OSERROR, 12

WHENEVER SQLERROR, 12

EXIT command, 3.4.1, 3.4.2, 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

exiting

iSQL*Plus, Preface, 3.4.3

SQL*Plus GUI, 1.2.3.1

Expired Password screen, 3.1.3

extension, 12, 12, 12

F

FAILURE clause, 12

features

new, Preface

FEEDBACK variable, 12, 12

fields

connection identifier, 1.3.2.3, 1.3.3.5

enter statements, 1.3.6.1, 1.3.6.1, 1.3.6.2, 1.3.6.3

new password, 3.1.5.3

password, 1.3.2.2, 1.3.3.4

privilege, 1.3.3.6

script location, 1.3.8.4

username, 1.3.2.1, 1.3.3.3, 3.1.5.1

file extensions, 2.2.3, 12, 12, 12

File menu, 1.2.3.1

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, E.2.3

finding text, 1.2.3.3

FLAGGER variable, 12, 12

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.1.2

changing face and size in GUI, 1.2.4, 1.2.4.1

changing in GUI, 1.2.4

euro sign in command-line, 1.1.2.2

fixed pitch TrueType, 1.2.4

Oracle Database home, 1.2.4.1

setting default in GUI, 2.5.2.3

setting default size in GUI, 2.5.2.4

special character in command-line, 1.1.2.2

Windows Character Map utility, 1.1.2.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.4

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

enabling or disabling iSQL*Plus help, 2.3.8

installing command-line, 2.2.4

iSQL*Plus online, 3.3.10

menu, 1.2.3.5

online, 3.3.2, 12

HELP command, ? command, 12

HIDE clause, 12

History screen, 1.3.6

HOST command, 4.9, 12

host string, 3.3.3.1

HTML, 7.1.1

clause, 3.5.1.5

entities, 2.3.9, 2.3.10, 2.3.11, 7.1.3

option, 3.5.1.5

spooling to file, 3.5.1.5, 3.5.1.5

tag, 7.1

HTTP

Application Server authentication, 9.6.3

HTTPS security, 9.6

security, 9.6

hyphen

continuing a long SQL*Plus command, 4.6.1.1, 12

I

IMMEDIATE mode, 12

infinity sign (~), 12

initialization parameters

displaying, 12

INIT.ORA file

parameter file, 12

input

accepting [Return], 5.12.3

accepting values from the user, 5.12.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, E

SQL*Plus Instant Client by copying, E.1

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

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

SQL*Plus Instant Client on Linux, E.2.1

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

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

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

installation by copying, E.1

installation by copying from 10g Client, E.3

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

installation on Linux, E.2.1

installation on UNIX or Windows, E.2.2

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

installation, Windows files to copy, E.3.2

INSTANCE variable, 12, 12

instances

shutting down, 12

starting, 12

Instant Client

SQL*Plus, E

Instant Client packages, E.1

iSQL*Plus

access modes, 9.6.2

Application Server running, 2.3.2

Change Password screen, 3.1.5

configuring Oracle Net, 2.2.5

DBA Login screen, 1.3.3

dynamic reports, 7.2

enabling cookies, 2.4

enabling javascript, 2.4

enabling or disabling, 2.3.8

enabling or disabling iSQL*Plus help, 2.3.8

enabling restricted database access, 2.3.5

environment variables, 2.1

error messages, 13.2

exiting, Preface, 3.4.3

Expired Password screen, 3.1.3

History screen, 1.3.6

language support, 3.3.10

logging, 2.3.3

online help, 3.3.10

port conflict, 2.3.1

Preferences screen, 1.3.8

retained session settings, 2.4.1

security, 9.6, 9.6

session-timeout, 2.3.4

setting up SSL, 2.3.7

starting, 3.3.4, 3.3.4, 3.3.9

starting from a URL, 3.3.9

stopping, 3.3.6

substitution variables, 5.10

three-tier model, Preface

user access, 9.6.2

user interface, Preface, Preface, Preface

Workspace, 1.3.4

iSQL*Plus DBA URL, 2.3.6

iSQLPlusAllowScriptsURL

configuration parameter, 2.1, 2.3.10

iSQLPlusAllowUserMarkup

configuration parameter, 2.1, 2.3.11

iSQLPlusBannerMessage

configuration parameter, 2.1, 2.3.9

iSQLPlusConnectIdList

configuration parameter, 2.1, 2.3.5

isqlplusctl

starting Application Server, 3.3.4

J

JAAS, 2.3.6

Japanese

Java Authentication and Authorization Service (JAAS), 2.3.6

Java AuthoriZatioN (JAZN), 2.3.6

JAVA_HOME

environment variables, 2.1

javascript, configuring for iSQL*Plus, 2.4

JAZN, 2.3.6

JRE_HOME

environment variables, 2.1

JUSTIFY clause, 12, 12

L

LABEL variable

SHOW command, C.1, C.1

labels

in COMPUTE command, 6.2.6, 12

language

SQL*Plus Instant Client, E.1.2

language support in iSQL*Plus, 3.3.10

LD_LIBRARY_PATH

environment variables, 2.1

LEFT clause, 6.3.1.1, 12, 12

lightweight OCI package, E.1.2

LIKE clause, 6.1.4, 12, 12

limits, SQL*Plus, A

line numbers, for SQL commands, 4.4

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, E.2.1

SQL*Plus Instant Client files to copy, E.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

load script button, 1.3.4.3

LOBOFFSET variable, 12, 12

LOCAL

environment variables, 2.1

LOCK TABLE command

disabling, 9.2

Log On dialog, 3.3.3.1

LOG_ARCHIVE_DEST parameter, 12

log4j.rootLogger, 2.3.3

configuration parameter, 2.1

LOGFILE clause, 12

logging, 2.3.3

logging off

conditionally, 12, 12

Oracle Database, 3.1, 12

SQL*Plus, 3.4.1, 12

logging on

Oracle Database, 12

SQL*Plus, 3.3.1

user profile, 2.2.2.1

See glogin.sql

Logout, Preface, 3.4.3

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, 12

LONGRAW

column definition from DESCRIBE, 12

M

-MARKUP, 3.5.1.5, 3.5.1.5, 7.1, 7.1, 12, 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.1, C.10

media recovery, 12

menus, Windows GUI, 1.2.3

message logging, 2.3.3

message, sending to screen, 5.12.1, 12

middle tier, Preface

MOUNT clause, 12

mounting a database, 12

mouse, using to copy command, 1.2.1

multiple Oracle Database homes, specifying font, 1.2.4.1

N

national language support

O

objects, describing, 12

obsolete commands

BTITLE, C.2

COLUMN command DEFAULT clause, C.3

DOCUMENT, C.1, C.1, C.4

NEWPAGE, C.1, C.1, C.5

SET command BUFFER variable, C.6

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

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

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

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

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

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

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

SHOW command LABEL variable, C.1, C.1

TTITLE command old form, C.14

OCI Instant Client, E

OCI package

basic, E.1.1

lightweight, E.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

Options menu, 1.2.3.4

ORA_NLS10

environment variables, 2.1

Oracle Database Client, E

Oracle Database home

specifying font, 1.2.4.1

Oracle Net, Preface, 9.6

configuring, 2.2.5

connect identifier, 12

security, 9.6

ORACLE_HOME

environment variables, 2.1

ORACLE_PATH

environment variables, 2.1

ORACLE_SID

environment variables, 2.1

Oracle10g, Preface

globalization support, 11.4

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, E.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.11, 12, 12, 12

iSQL*Plus session-timeout, 2.3.4

iSQLPlusAllowScriptsURL, 2.3.10

iSQLPlusAllowUserMarkup, 2.3.11

iSQLPlusBannerMessage, 2.3.9

SQLPATH, 2.5.2.2

SQLPLUS_FONT, 1.2.4, 2.5.2.3

SQLPLUS_FONT_SIZE, 1.2.4, 1.2.4, 2.5.2.4

parameter files (INIT.ORA files)

specifying alternate, 12

PARAMETERS clause, 12

password

Application Server authentication, 1.3.3.2

changing in iSQL*Plus, 3.1.3, 3.1.5

changing with the PASSWORD command, 12

field, 1.3.2.2, 1.3.3.4

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

pasting text, 1.2.3.2

PATH

environment variables, 2.1

PAUSE command, 5.12.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

port conflict, 2.3.1

pound sign (#), 12

predefined variable

_CONNECT_IDENTIFIER, 2.2.2.1, 12, 12

_DATE, 12, 12

_EDITOR, 1.2.3.2, 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

Preferences screen, 1.3.8

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

privileges

list, 1.3.3.6

Product User Profile table, 9.1, 9.6.5

prompt

SET SQLPROMPT, 8.5.10, 12, 12

PROMPT clause, 5.12.1, 12

PROMPT command, 5.12.1, 12

customizing prompts for value, 5.12.2

prompts for value

bypassing with parameters, 5.11

customizing, 5.12.2

through ACCEPT, 5.12.1

through substitution variables, 5.9.1

PUPBLD.SQL, 9.1.1

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

redo Log Files

ARCHIVE LOG command, 12

REFCURSOR bind variables

in a stored function, 5.14

REFCURSOR clause

VARIABLE command, 12

REGEDIT.EXE, 2.5.2.1

REGEDT32.EXE, 2.5.2.1

registry

editor, 1.2.4, 2.5.2.1, 2.5.2.2, 2.5.2.3, 2.5.2.4

REGEDIT.EXE, 2.5.2.1

REGEDT32.EXE, 2.5.2.1

registry entry

SQLPATH, 2.1, 2.5.2.2

SQLPLUS_FONT, 1.2.4, 2.1, 2.5.2.3

SQLPLUS_FONT_SIZE, 1.2.4, 1.2.4, 2.1, 2.5.2.4

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, C.1

creating dynamic, 7.2

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, 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

running from a URL, 7.2

SILENT mode, 7.1.2

starting on a new page, 12

title, 12, C.1, C.1

RESTRICT, 3.5.1.7, 9.4, 12

restricted database access, 2.3.5

return code, specifying, 5.6, 12, 12, 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

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

Run menu command, 1.2.3.1

S

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

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

save script button, 1.3.4.4

saving environment attributes, 12

saving, command files, 1.2.3.1

SCAN variable, C.1, 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, 7.2

screen buffer area, 1.2.3.4

SCREEN clause, 5.12.4, 12

screens

Change Password, 3.1.5

clearing, 5.12.4, 12

connection identifier field, 1.3.2.3, 1.3.3.5

DBA Login, 1.3.3

DBA Workspace, 1.3.5

enter statements field, 1.3.6.1, 1.3.6.1, 1.3.6.2, 1.3.6.3

Expired Password, 3.1.3

History, 1.3.6

new password field, 3.1.5.3

password field, 1.3.2.2, 1.3.3.4

Preferences, 1.3.8

privilege list, 1.3.3.6

script location field, 1.3.8.4

username field, 1.3.2.1, 1.3.3.3, 3.1.5.1

Workspace, 1.3.4

scripts

extension, 12, 12, 12

location field, 1.3.8.4

registering, 8.5.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, E.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

defining, 1.2.3.2

invoking, 1.2.3.2

operating system, 5.1.1, 12

three-tier model, Preface

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, C.1

displaying at top of page, 6.3, 12, C.1, 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, 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, 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.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, E.2.2

SQL*Plus Instant Client files to copy, E.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

URL

running dynamic reports, 7.2

starting iSQL*Plus, 3.3.9

USER clause, 12

user profile, 2.2.2

glogin.sql, 2.2.2

V

V$SESSION virtual table, 12

V$SQLAREA virtual table, 12

value area, 1.2.3.4

value screen area, 1.2.3.4

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

BINARY_DOUBLE clause, 12

BINARY_FLOAT 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.13

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, Preface, 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, E.2.2

notepad, 12

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

Windows GUI

application window, 1.2, 3.3.3.2

cancelling, 1.2.3.1

changing face and size, 1.2.4, 1.2.4.1

changing font, 1.2.4

command keys, 1.2.2

configuring, 2.5

exiting, 1.2.3.1

File menu, 1.2.3.1

Log On dialog, 3.3.3.1

menus, 1.2.3

starting SQL*Plus, 3.3.3.1

Windows service

starting iSQL*Plus Application Server, 3.3.4

WORD_WRAPPED clause, 6.1.3.2, 6.1.7, 12

Workspace, 1.3.4

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